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(); } }