public partial class FrmEndDateSummaryOnLoad : FrmErpSimple
{
List<string> mVehicleRemainderList;
//SMdiForm mMdiParent;
string mCurrentUserId;
string mCurrentPeriodId;
DataTable dataTableVehicleID = new DataTable();
DataTable dataTableVehicleNextKMS = new DataTable();
public FrmEndDateSummaryOnLoad(CErpDataConnection pErpDataConnection, CUserLoginInfo pUserLoginInfo
, CRegional pRegional)
: base(pErpDataConnection, pUserLoginInfo)
{
InitializeComponent();
}
protected override void OnLoad(EventArgs e)
{
mCurrentPeriodId = mUserLoginInfo.GetPeriodID();
mCurrentUserId = mUserLoginInfo.GetUserID();
mCommand = mErpDataConnection.CreateCommand();
mConnection = mErpDataConnection.CreateConnection();
// dttxtDate = new SDateTimeMaskedTextBox();
dttxtDate.Focus();
SearchEndDate();
}
#region EndDateSummary
CDataTable dataTable;
public void SearchEndDate()
{
if (SCUtil.IsDate(dttxtDate.Text))
{
//same code as In Else {},on load date textbox is blank..
}
else
{
string sql;
string dt = mErpDataConnection.GetDBServerDateTime();
dttxtDate.Text = dt;
DateTime dtSearch = dttxtDate.uStringToDateTimeConversion();
DateTime dtDateAfterAdd = dtSearch.AddDays(SCUtil.StringToIntAbsolute(mErpDataConnection.GetRegistryKeyValue("REMINDER_ADD_DAYS")));
string strDtSearch = SCUtil.DateTimeToYYYYMMDD(dtDateAfterAdd);
sql = "SELECT * FROM Rpt_Trans_End_Date_Summary"
+ " WHERE ('" + strDtSearch + "' >= Insurance_End_Date)"
+ " OR ('" + strDtSearch + "' >= Tax_End_Date)"
+ " OR ('" + strDtSearch + "' >= Fitness_End_Date)"
+ " OR ('" + strDtSearch + "' >= Permit_End_Date)";
dataTable = new CDataTable();
mCommand.CommandText = sql;
mCommand.Connection = mConnection;
dataTable = mErpDataConnection.FillDataTable(mCommand);
dgvEndDateSummery.DataSource = dataTable;
for (int i = 1; i < dgvEndDateSummery.Rows.Count; i++)
{
SetCellColor(i, dtDateAfterAdd, "Insurance_End_Date");
SetCellColor(i, dtDateAfterAdd, "Tax_End_Date");
SetCellColor(i, dtDateAfterAdd, "Fitness_End_Date");
SetCellColor(i, dtDateAfterAdd, "Permit_End_Date");
}
dttxtDate.Focus();
}
}
public void SetCellColor(int pRowNumber, DateTime pDate, string pColumn)
{
string strCellValue = dgvEndDateSummery.Rows[pRowNumber - 1].Cells[pColumn].Value.ToString();
DateTime cellDate = SCUtil.StringToDateTimeConversion(strCellValue);
// DateTime dat = Convert.ToDateTime(dgvEndDateSummery.Rows[pRowNumber - 1].Cells[pColumn].Value.ToString());
if (cellDate <= pDate)
{
dgvEndDateSummery.Rows[pRowNumber - 1].Cells[pColumn].Style.BackColor = Color.Cyan;
}
}
jaimin4829 0 Newbie Poster
Mike Askew 131 Veteran Poster Featured Poster
Maligui 1 Application Developer
jaimin4829 commented: But it works on Btn_Click... +1
jaimin4829 0 Newbie Poster
Maligui 1 Application Developer
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.