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
Recommended Answers
Jump to PostKeep in mind that Form_Load event handler will run on a background thread, and it is not recommended when changing state of objects, but more or less to ready data for the form. More then likely there is an error happening and it is silently throwing an exception (which is …
All 4 Replies
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.