protected void exportBtn_Click(object sender, EventArgs e)
{
UpdatePanelUpperBox.Update();
List <DataTable> lstdt = (List <DataTable>)Session["ReportsToPrint"];
Common.ExportToExcel_List(lstdt, string.Format("YTD and Weekly Report - {0}-{1}-{2}", DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day));
}
protected void Apply_Click(object sender, EventArgs e)
{
decimal weeklycompensation = -1, Override = -1;
DateTime EffDate = new DateTime();
decimal.TryParse(WeeklyCompensationTxt.Text, out weeklycompensation);
decimal.TryParse(OverrideTxt.Text, out Override);
DateTime.TryParse(EffectiveDate.Text, out EffDate);
if (weeklycompensation == 0 || Override == 0 || EffDate.Year == 1)
{
WeeklyCompensationTxt.BackColor = Color.White;
OverrideTxt.BackColor = Color.White;
EffectiveDate.BackColor = Color.White;
ValidateCompensation.InnerText = "";
ValidateOverride.InnerText = "";
ValidateEffectiveDate.InnerText = "";
UpdatePanelUpperBox.Update();
if (weeklycompensation == 0)
{
ValidateCompensation.InnerText = "Please enter a valid value";
WeeklyCompensationTxt.BackColor = Color.Salmon;
}
if (Override == 0)
{
ValidateOverride.InnerText = "Please enter a valid value";
OverrideTxt.BackColor = Color.Salmon;
}
if (EffDate.Year == 1)
{
ValidateEffectiveDate.InnerText = "Please enter a valid value";
EffectiveDate.BackColor = Color.Salmon;
}
}
else
{
UpdatePanelTopWrapper.Update();
UpdatePanelUpperBox.Update();
string SQLstring;
if (HiddenIdTextBox.Text != "")
{
SQLstring = string.Format(@"UPDATE PAYOUTOverridesPM
SET TrainerId = {0}, StoreName = '{1}', Program = '{2}', WeeklyCompensation = {3}, Override = {4}
WHERE Id = {5}",
trainerAddDDL.SelectedValue,
sstoreAddDDL.SelectedValue,
programAddDDL.SelectedValue,
weeklycompensation,
Override,
HiddenIdTextBox.Text);
}
else
{
SQLstring = string.Format(@"INSERT INTO PAYOUTOverridesPM (TrainerId, StoreName, Program, WeeklyCompensation, Override, EffectiveDate)
VALUES ({0},'{1}','{2}',{3},{4},'{5}')",
trainerAddDDL.SelectedValue,
sstoreAddDDL.SelectedValue,
programAddDDL.SelectedValue,
weeklycompensation,
Override,
EffectiveDate.Text);
}
Queries.ExecuteFromQueryString(SQLstring);
Response.Redirect(Request.RawUrl);
//BindGridData();
}
}
