protected void ButtonDUserControl_Click(object sender, EventArgs e)
{
if (DropDownList7.SelectedValue == "DDL")
{
Response.Write(((DropDownList)PlaceHolder2.FindControl("DDL1")).SelectedItem + "<br/>");
}
else if (DropDownList7.SelectedValue == "TB")
{
Response.Write(((TextBox)PlaceHolder2.FindControl("TB1")).Text + "<br/>");
}
}
private SpeedSearchQuery BuildQuery()
{
var ssq = new SpeedSearchQuery {
SearchText = SearchRequest.Text
};
if (string.IsNullOrEmpty(ssq.SearchText))
{
throw new UserObservableException(GetLocalResourceObject("SpeedSearch_Error_Keyword_Required").ToString());
}
ssq.SearchType = SearchType.SelectedIndex;
ssq.IncludeStemming = SearchFlags.Items[0].Selected;
ssq.IncludeThesaurus = SearchFlags.Items[1].Selected;
ssq.IncludePhonic = SearchFlags.Items[2].Selected;
ssq.WhichPage = _whichResultsPage;
ssq.ItemsPerPage = 10;
_state.SelectedIndexes.Clear();
for (var i = 0; i < _indexes.Count; i++)
{
var thisIndex = (CheckBox)PlaceHolder1.FindControl("Index" + i);
if ((thisIndex != null) && (thisIndex.Checked))
{
ssq.Indexes.Add(new SpeedSearchIndex(_indexes[i].IndexName, _indexes[i].Type.Value, _indexes[i].IsSecure ?? false));
_state.SelectedIndexes.Add(i);
}
}
if (ssq.Indexes.Count == 0)
{
throw new UserObservableException(GetLocalResourceObject("SpeedSearch_Error_Index_Required").ToString());
}
var freqfilter = (CheckBox)PlaceHolder2.FindControl("FreqUsed");
if ((freqfilter != null) && (freqfilter.Checked))
{
ssq.UseFrequentFilter = true;
}
foreach (var fd in _searchFilters.Values)
{
var filter = (TextBox)PlaceHolder2.FindControl(fd.DisplayName);
if ((filter != null) && (!string.IsNullOrEmpty(filter.Text)))
{
ssq.Filters.Add(new SpeedSearchFilter(fd.DisplayName, filter.Text, fd.CommonIndexes, fd.FieldType, fd.IndexType));
}
}
return(ssq);
}
public void getDepressionScreeningData()
{
var PSM = new PatientScreeningManager();
List <PatientScreening> screeningList = PSM.GetPatientScreeningByVisitId(PatientId, PmVisitId);
//.GetPatientScreening(PatientId);
if (screeningList != null)
{
foreach (var value in screeningList)
{
depressionId = Convert.ToInt32(value.ScreeningTypeId);
RadioButtonList rblPC1Qs = (RadioButtonList)PlaceHolder1.FindControl("uds" + value.ScreeningCategoryId.ToString());
if (rblPC1Qs != null)
{
rblPC1Qs.SelectedValue = value.ScreeningValueId.ToString();
}
RadioButtonList rblPC2Qs = (RadioButtonList)PlaceHolder2.FindControl("uds" + value.ScreeningCategoryId.ToString());
if (rblPC2Qs != null)
{
rblPC2Qs.SelectedValue = value.ScreeningValueId.ToString();
}
}
}
var PCN = new PatientClinicalNotesLogic();
List <PatientClinicalNotes> notesList = PCN.getPatientClinicalNotesByVisitId(PatientId, PmVisitId);
//.getPatientClinicalNotes(PatientId);
if (notesList.Any())
{
foreach (var value in notesList)
{
TextBox ntb = (TextBox)PlaceHolder2.FindControl("uds" + value.NotesCategoryId.ToString());
if (ntb != null)
{
ntb.Text = value.ClinicalNotes;
}
}
}
}
//save dynamic values of sucategories
protected void btnreadsub_Click(object sender, EventArgs e)
{
//save_performancetest();
//retrieve_performancetest();
int count = this.NumberOfControls1;
int id = Convert.ToInt32(ddperfcategory.SelectedValue);
for (int i = 0; i < count; i++)
{
TextBox txsub = (TextBox)PlaceHolder2.FindControl("txtDatasub" + i.ToString());
//Add the Controls to the container of your choice
SqlConnection con = new SqlConnection(sqlcon);
con.Open();
SqlCommand cmd = new SqlCommand("insert into Perf_SubCategory(CategoryID,SubCategory_Name)values('" + id + "','" + txsub.Text.Trim().Replace("'", "''") + "')", con);
cmd.ExecuteNonQuery();
txsub.Text = "";
ddperfcategory.Items.Clear();
}
string path1 = Page.Request.Url.AbsolutePath;
Response.Redirect(path1);
}
private SpeedSearchQuery BuildQuery()
{
SpeedSearchQuery ssq = new SpeedSearchQuery();
ssq.SearchText = SearchRequest.Text;
ssq.SearchType = SearchType.SelectedIndex;
ssq.IncludeStemming = SearchFlags.Items[0].Selected;
ssq.IncludeThesaurus = SearchFlags.Items[1].Selected;
ssq.IncludePhonic = SearchFlags.Items[2].Selected;
ssq.WhichPage = whichResultsPage;
ssq.ItemsPerPage = 10;
for (int i = 0; i < _Indexes.Count; i++)
{
CheckBox thisIndex = (CheckBox)PlaceHolder1.FindControl("Index" + i.ToString());
if ((thisIndex != null) && (thisIndex.Checked))
{
ssq.Indexes.Add(_Indexes[i].IndexName);
_State.SelectedIndexes.Add(i);
}
}
CheckBox freqfilter = (CheckBox)PlaceHolder2.FindControl("FreqUsed");
if ((freqfilter != null) && (freqfilter.Checked))
{
ssq.UseFrequentFilter = true;
}
foreach (SlxFieldDefinition fd in _SearchFilters.Values)
{
TextBox filter = (TextBox)PlaceHolder2.FindControl(fd.DisplayName);
if ((filter != null) && (!string.IsNullOrEmpty(filter.Text)))
{
ssq.Filters.Add(new SpeedSearchFilter(fd.DisplayName, filter.Text, fd.CommonIndexes, fd.FieldType, fd.IndexType));
}
}
return(ssq);
}
protected void btnSave_Click(object sender, EventArgs e)
{
string UpdateCommand = "update SAVINGS$ set CONTTOPENSION=@CONTTOPENSION, MEDICLAIM=@MEDICLAIM, HANDICAPPED=@HANDICAPPED, MEDICAL=@MEDICAL, EDULOAN=@EDULOAN, DONATION=@DONATION, PHDISABLED=@PHDISABLED, PUBLICPF=@PUBLICPF, HOUSELOAN=@HOUSELOAN, INTONHOUSELOAN=@INTONHOUSELOAN, INTONNSC=@INTONNSC, NSS=@NSS, MUTUALFUNDS=@MUTUALFUNDS, EQUITYLINK=@EQUITYLINK, TUTIONFEES=@TUTIONFEES, NSC=@NSC, LIC=@LIC, JEEVANSURAKSHA=@JEEVANSURAKSHA, LIPOSTAL=@LIPOSTAL, UNITLINK=@UNITLINK, MEP=@MEP, INVSTINFRA=@INVSTINFRA, OTHERS=@OTHERS, SEC80CCG=@SEC80CCG, SEC80DDB=@SEC80DDB, SEC80GG=@SEC80GG, SEC80GGC=@SEC80GGC, SEC80TTA=@SEC80TTA, SEC80U=@SEC80U, NPS=@NPS ";
SqlConnection con = con = new SqlConnection(ConfigurationManager.ConnectionStrings["UniversityDatabaseConnectionString"].ToString());
foreach (string s in Globals.DynamicControlsList1)
{
UpdateCommand = UpdateCommand + "," + s + "=@" + s;
}
foreach (string s in Globals.DynamicControlsList2)
{
UpdateCommand = UpdateCommand + "," + s + "=@" + s;
}
UpdateCommand = UpdateCommand + " where EMPNO=@EMPNO and SAVING_YEAR=@SAVING_YEAR";
SqlCommand cmd1 = new SqlCommand(UpdateCommand, con);
cmd1.Parameters.AddWithValue("@EMPNO", lblEmployeeNoValue.Text);
cmd1.Parameters.AddWithValue("@SAVING_YEAR", lblSavingYearValue.Text);
cmd1.Parameters.AddWithValue("@CONTTOPENSION", txtConToPension.Text);
cmd1.Parameters.AddWithValue("@MEDICLAIM", txtMediPremium.Text);
cmd1.Parameters.AddWithValue("@HANDICAPPED", txtHandicappedDepend.Text);
cmd1.Parameters.AddWithValue("@MEDICAL", txtMediTreatment.Text);
cmd1.Parameters.AddWithValue("@EDULOAN", txtRepayLoan.Text);
cmd1.Parameters.AddWithValue("@DONATION", txtDonationCmrf.Text);
cmd1.Parameters.AddWithValue("@PHDISABLED", txtBlindOrPh.Text);
cmd1.Parameters.AddWithValue("@PUBLICPF", txtPPF.Text);
cmd1.Parameters.AddWithValue("@HOUSELOAN", txtRepayHouseLoan.Text);
cmd1.Parameters.AddWithValue("@INTONHOUSELOAN", txtInterestHouseLoan.Text);
cmd1.Parameters.AddWithValue("@INTONNSC", txtAccureudInterestNSC.Text);
cmd1.Parameters.AddWithValue("@NSS", txtNSS.Text);
cmd1.Parameters.AddWithValue("@MUTUALFUNDS", txtMutualFund.Text);
cmd1.Parameters.AddWithValue("@EQUITYLINK", txtEquityLinked.Text);
cmd1.Parameters.AddWithValue("@TUTIONFEES", txtTutionFees.Text);
cmd1.Parameters.AddWithValue("@NSC", txtNSC.Text);
cmd1.Parameters.AddWithValue("@LIC", txtLicPremium.Text);
cmd1.Parameters.AddWithValue("@JEEVANSURAKSHA", txtJeevanSuraksha.Text);
cmd1.Parameters.AddWithValue("@LIPOSTAL", txtPostalInvestment.Text);
cmd1.Parameters.AddWithValue("@UNITLINK", txtUnitInsurance.Text);
cmd1.Parameters.AddWithValue("@MEP", txtInfrastructureBond.Text);
cmd1.Parameters.AddWithValue("@INVSTINFRA", txtInvestmentInfrastructure.Text);
cmd1.Parameters.AddWithValue("@OTHERS", txtOthers.Text);
cmd1.Parameters.AddWithValue("@SEC80CCG", txtSec80CCG.Text);
cmd1.Parameters.AddWithValue("@SEC80DDB", txtSec80DDB.Text);
cmd1.Parameters.AddWithValue("@SEC80GG", txtSec80GG.Text);
cmd1.Parameters.AddWithValue("@SEC80GGC", txtSec80GGC.Text);
cmd1.Parameters.AddWithValue("@SEC80TTA", txtSec80TTA.Text);
cmd1.Parameters.AddWithValue("@SEC80U", txtSec80U.Text);
cmd1.Parameters.AddWithValue("@NPS", txtNPS.Text);
foreach (string s in Globals.DynamicControlsList1)
{
//try
//{
cmd1.Parameters.AddWithValue("@" + s, (placeholder.FindControl("txt" + s) as TextBox).Text);
//}
//catch
//{
// Response.Write("<script>alert('placeholder.FindControl: txt" +s + "');</script>");
//}
}
foreach (string s in Globals.DynamicControlsList2)
{
//try
//{
cmd1.Parameters.AddWithValue("@" + s, (PlaceHolder2.FindControl("txt" + s) as TextBox).Text);
//}
//catch
//{
// Response.Write("<script>alert('placeholder.FindControl: txt" + s + "');</script>");
//}
}
con.Open();
Response.Write("<script>alert('UPDATE COMMAND:" + UpdateCommand + "');</script>");
int status = 0;
status = cmd1.ExecuteNonQuery();
con.Close();
if (status == -1)
{
Response.Write("<script>alert('Error while saving data!!');</script>");
}
else
{
//Response.Write("<script>alert('Data Saved Successfully!!');</script>");
//Response.Redirect("Savings.aspx");
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Data saved sucessfully');window.location ='Savings.aspx';", true);
}
}
//List<string> DynamicControlsList1;
//List<string> DynamicControlsList2;
protected void Page_Load(object sender, EventArgs e)
{
if (Session["User_Id"] == null)
{
Response.Redirect("LoginPage.aspx");
}
if (!IsPostBack)
{
String value = Request.QueryString.ToString();
Char delimiter = '&';
String[] substrings = value.Split(delimiter);
if (substrings[0].StartsWith("EMPNO="))
{
substrings[0] = substrings[0].Remove(0, "EMPNO=".Length);
}
if (substrings[1].StartsWith("SAVING_YEAR="))
{
substrings[1] = substrings[1].Remove(0, "SAVING_YEAR=".Length);
}
Int16 Empid = 0, SavingYear = 0, id, year;
if (Int16.TryParse(substrings[0], out id))
{
Empid = id;
}
if (Int16.TryParse(substrings[1], out year))
{
SavingYear = year;
}
Response.Write("<script>alert('empid=" + substrings[0] + " saving year=" + substrings[1] + "');</script>");
lblEmployeeNoValue.Text = substrings[0];
lblSavingYearValue.Text = substrings[1];
DataSet ds = SetDataValues(Convert.ToInt16(substrings[0]), Convert.ToInt16(substrings[1]));
txtConToPension.Text = ds.Tables[0].Rows[0]["CONTTOPENSION"].ToString();
txtMediPremium.Text = ds.Tables[0].Rows[0]["MEDICLAIM"].ToString();
txtHandicappedDepend.Text = ds.Tables[0].Rows[0]["HANDICAPPED"].ToString();
txtMediTreatment.Text = ds.Tables[0].Rows[0]["MEDICAL"].ToString();
txtRepayLoan.Text = ds.Tables[0].Rows[0]["EDULOAN"].ToString();
txtDonationCmrf.Text = ds.Tables[0].Rows[0]["DONATION"].ToString();
txtBlindOrPh.Text = ds.Tables[0].Rows[0]["PHDISABLED"].ToString();
txtPPF.Text = ds.Tables[0].Rows[0]["PUBLICPF"].ToString();
txtRepayHouseLoan.Text = ds.Tables[0].Rows[0]["HOUSELOAN"].ToString();
txtInterestHouseLoan.Text = ds.Tables[0].Rows[0]["INTONHOUSELOAN"].ToString();
txtAccureudInterestNSC.Text = ds.Tables[0].Rows[0]["INTONNSC"].ToString();
txtNSS.Text = ds.Tables[0].Rows[0]["NSS"].ToString();
txtMutualFund.Text = ds.Tables[0].Rows[0]["MUTUALFUNDS"].ToString();
txtEquityLinked.Text = ds.Tables[0].Rows[0]["EQUITYLINK"].ToString();
txtTutionFees.Text = ds.Tables[0].Rows[0]["TUTIONFEES"].ToString();
txtNSC.Text = ds.Tables[0].Rows[0]["NSC"].ToString();
txtLicPremium.Text = ds.Tables[0].Rows[0]["LIC"].ToString();
txtJeevanSuraksha.Text = ds.Tables[0].Rows[0]["JEEVANSURAKSHA"].ToString();
txtPostalInvestment.Text = ds.Tables[0].Rows[0]["LIPOSTAL"].ToString();
txtUnitInsurance.Text = ds.Tables[0].Rows[0]["UNITLINK"].ToString();
txtInfrastructureBond.Text = ds.Tables[0].Rows[0]["MEP"].ToString();
txtInvestmentInfrastructure.Text = ds.Tables[0].Rows[0]["INVSTINFRA"].ToString();
txtOthers.Text = ds.Tables[0].Rows[0]["OTHERS"].ToString();
txtSec80CCG.Text = ds.Tables[0].Rows[0]["SEC80CCG"].ToString();
txtSec80DDB.Text = ds.Tables[0].Rows[0]["SEC80DDB"].ToString();
txtSec80GG.Text = ds.Tables[0].Rows[0]["SEC80GG"].ToString();
txtSec80GGC.Text = ds.Tables[0].Rows[0]["SEC80GGC"].ToString();
txtSec80TTA.Text = ds.Tables[0].Rows[0]["SEC80TTA"].ToString();
txtSec80U.Text = ds.Tables[0].Rows[0]["SEC80U"].ToString();
txtNPS.Text = ds.Tables[0].Rows[0]["NPS"].ToString();
foreach (string s in Globals.DynamicControlsList1)
{
(placeholder.FindControl("txt" + s) as TextBox).Text = ds.Tables[0].Rows[0][s].ToString();
}
foreach (string s in Globals.DynamicControlsList2)
{
(PlaceHolder2.FindControl("txt" + s) as TextBox).Text = ds.Tables[0].Rows[0][s].ToString();
}
}
}
protected void txtEmpNo_TextChanged(object sender, EventArgs e)
{
int previousYear = DateTime.Now.Year - 1;
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["UniversityDatabaseConnectionString"].ToString());
SqlCommand cmd = new SqlCommand("select * from SAVINGS$ where SAVING_YEAR=@SAVING_YEAR and EMPNO=@EMPNO", con);
cmd.Parameters.AddWithValue("@SAVING_YEAR", previousYear);
cmd.Parameters.AddWithValue("@EMPNO", txtEmpNo.Text);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.Read())
{
//txtEmpNo.Text = rdr["EMPNO"].ToString();
txtConToPension.Text = rdr["CONTTOPENSION"].ToString();
txtMediPremium.Text = rdr["MEDICLAIM"].ToString();
txtHandicappedDepend.Text = rdr["HANDICAPPED"].ToString();
txtMediTreatment.Text = rdr["MEDICAL"].ToString();
txtRepayLoan.Text = rdr["EDULOAN"].ToString();
txtDonationCmrf.Text = rdr["DONATION"].ToString();
txtBlindOrPh.Text = rdr["PHDISABLED"].ToString();
txtPPF.Text = rdr["PUBLICPF"].ToString();
txtRepayHouseLoan.Text = rdr["HOUSELOAN"].ToString();
txtInterestHouseLoan.Text = rdr["INTONHOUSELOAN"].ToString();
txtAccureudInterestNSC.Text = rdr["INTONNSC"].ToString();
txtNSS.Text = rdr["NSS"].ToString();
txtMutualFund.Text = rdr["MUTUALFUNDS"].ToString();
txtEquityLinked.Text = rdr["EQUITYLINK"].ToString();
txtTutionFees.Text = rdr["TUTIONFEES"].ToString();
txtNSC.Text = rdr["NSC"].ToString();
txtLicPremium.Text = rdr["LIC"].ToString();
txtJeevanSuraksha.Text = rdr["JEEVANSURAKSHA"].ToString();
txtPostalInvestment.Text = rdr["LIPOSTAL"].ToString();
txtUnitInsurance.Text = rdr["UNITLINK"].ToString();
txtInfrastructureBond.Text = rdr["MEP"].ToString();
txtInvestmentInfrastructure.Text = rdr["INVSTINFRA"].ToString();
txtOthers.Text = rdr["OTHERS"].ToString();
txtSec80CCG.Text = rdr["SEC80CCG"].ToString();
txtSec80DDB.Text = rdr["SEC80DDB"].ToString();
txtSec80GG.Text = rdr["SEC80GG"].ToString();
txtSec80GGC.Text = rdr["SEC80GGC"].ToString();
txtSec80TTA.Text = rdr["SEC80TTA"].ToString();
txtSec80U.Text = rdr["SEC80U"].ToString();
txtNPS.Text = rdr["NPS"].ToString();
foreach (string s in DynamicControlsList)
{
(placeholder.FindControl("txt" + s) as TextBox).Text = rdr[s].ToString();
}
foreach (string s in DynamicControlsList)
{
(PlaceHolder2.FindControl("txt" + s) as TextBox).Text = rdr[s].ToString();
}
}
else
{
//txtEmpNo.Text = "0";
ddlSavingsYear.SelectedIndex = 0;
txtConToPension.Text = "0";
txtMediPremium.Text = "0";
txtHandicappedDepend.Text = "0";
txtMediTreatment.Text = "0";
txtRepayLoan.Text = "0";
txtDonationCmrf.Text = "0";
txtBlindOrPh.Text = "0";
txtPPF.Text = "0";
txtRepayHouseLoan.Text = "0";
txtInterestHouseLoan.Text = "0";
txtAccureudInterestNSC.Text = "0";
txtNSS.Text = "0";
txtMutualFund.Text = "0";
txtEquityLinked.Text = "0";
txtTutionFees.Text = "0";
txtNSC.Text = "0";
txtLicPremium.Text = "0";
txtJeevanSuraksha.Text = "0";
txtPostalInvestment.Text = "0";
txtUnitInsurance.Text = "0";
txtInfrastructureBond.Text = "0";
txtInvestmentInfrastructure.Text = "0";
txtOthers.Text = "0";
txtSec80CCG.Text = "0";
txtSec80DDB.Text = "0";
txtSec80GG.Text = "0";
txtSec80GGC.Text = "0";
txtSec80TTA.Text = "0";
txtSec80U.Text = "0";
txtNPS.Text = "0";
foreach (string s in DynamicControlsList)
{
(placeholder.FindControl("txt" + s) as TextBox).Text = "0";
}
foreach (string s in DynamicControlsList)
{
(PlaceHolder2.FindControl("txt" + s) as TextBox).Text = "0";
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
//string InsertCommand = "insert into SAVINGS$ values (@EMPNO,@SAVING_YEAR,@CONTTOPENSION,@MEDICLAIM,@HANDICAPPED,@MEDICAL,@EDULOAN,@DONATION,@PHDISABLED,@PUBLICPF,@HOUSELOAN,@INTONHOUSELOAN,@INTONNSC,@NSS,@MUTUALFUNDS,@EQUITYLINK,@TUTIONFEES,@NSC,@LIC,@JEEVANSURAKSHA,@LIPOSTAL,@UNITLINK,@MEP,@INVSTINFRA,@OTHERS";
string InsertCommand = "insert into SAVINGS$(EMPNO, SAVING_YEAR, CONTTOPENSION, MEDICLAIM, HANDICAPPED, MEDICAL, EDULOAN, DONATION, PHDISABLED, PUBLICPF, HOUSELOAN, INTONHOUSELOAN, INTONNSC, NSS, MUTUALFUNDS, EQUITYLINK, TUTIONFEES, NSC, LIC, JEEVANSURAKSHA, LIPOSTAL, UNITLINK, MEP, INVSTINFRA, OTHERS, SEC80CCG, SEC80DDB, SEC80GG, SEC80GGC, SEC80TTA, SEC80U, NPS";
//80C SECTIONS
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["UniversityDatabaseConnectionString"].ToString());
SqlCommand cmd = new SqlCommand("select * from SECTIONS", con); //SECTIONS=80C SECTIONS
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
List <string> ControlList1 = new List <string>();
String controlsNames1 = "";
String controlsValues1 = "";
while (rdr.Read())
{
string ControlName = (string)rdr["NAME"];
ControlName = ControlName.Replace(" ", "");
//InsertCommand = InsertCommand + ",@" + ControlName;
controlsNames1 = controlsNames1 + "," + ControlName;
controlsValues1 = controlsValues1 + ",@" + ControlName;
ControlList1.Add(ControlName);
}
rdr.Close();
con.Close();
// SAVINGS SECTIONS
String controlsNames2 = "";
String controlsValues2 = "";
cmd = new SqlCommand("SELECT * FROM SAVINGS_SECTIONS$ WHERE NAME != '80C'", con);
con.Open();
rdr = cmd.ExecuteReader();
List <string> ControlList2 = new List <string>();
while (rdr.Read())
{
string ControlName = (string)rdr["NAME"];
ControlName = ControlName.Replace(" ", "");
//InsertCommand = InsertCommand + ",@" + ControlName;
controlsNames2 = controlsNames2 + "," + ControlName;
controlsValues2 = controlsValues2 + ",@" + ControlName;
ControlList2.Add(ControlName);
}
rdr.Close();
con.Close();
InsertCommand = InsertCommand + controlsNames1 + controlsNames2 + ") values(@EMPNO,@SAVING_YEAR,@CONTTOPENSION,@MEDICLAIM,@HANDICAPPED,@MEDICAL,@EDULOAN,@DONATION,@PHDISABLED,@PUBLICPF,@HOUSELOAN,@INTONHOUSELOAN,@INTONNSC,@NSS,@MUTUALFUNDS,@EQUITYLINK,@TUTIONFEES,@NSC,@LIC,@JEEVANSURAKSHA,@LIPOSTAL,@UNITLINK,@MEP,@INVSTINFRA,@OTHERS, @SEC80CCG, @SEC80DDB, @SEC80GG, @SEC80GGC, @SEC80TTA, @SEC80U, @NPS" + controlsValues1 + controlsValues2 + ")";
//InsertCommand = InsertCommand + ")";
con.Open();
//Response.Write("<script>alert('INSERT CMD= " + InsertCommand + "');</script>");
//Response.Write("<script>alert('CONTTOPENSION= "+txtConToPension.Text+ " MEDICLAIM="+ txtMediPremium.Text+"');</script>");
SqlCommand cmd1 = new SqlCommand(InsertCommand, con);
cmd1.Parameters.AddWithValue("@EMPNO", txtEmpNo.Text);
cmd1.Parameters.AddWithValue("@SAVING_YEAR", ddlSavingsYear.SelectedValue);
cmd1.Parameters.AddWithValue("@CONTTOPENSION", txtConToPension.Text);
cmd1.Parameters.AddWithValue("@MEDICLAIM", txtMediPremium.Text);
cmd1.Parameters.AddWithValue("@HANDICAPPED", txtHandicappedDepend.Text);
cmd1.Parameters.AddWithValue("@MEDICAL", txtMediTreatment.Text);
cmd1.Parameters.AddWithValue("@EDULOAN", txtRepayLoan.Text);
cmd1.Parameters.AddWithValue("@DONATION", txtDonationCmrf.Text);
cmd1.Parameters.AddWithValue("@PHDISABLED", txtBlindOrPh.Text);
cmd1.Parameters.AddWithValue("@PUBLICPF", txtPPF.Text);
cmd1.Parameters.AddWithValue("@HOUSELOAN", txtRepayHouseLoan.Text);
cmd1.Parameters.AddWithValue("@INTONHOUSELOAN", txtInterestHouseLoan.Text);
cmd1.Parameters.AddWithValue("@INTONNSC", txtAccureudInterestNSC.Text);
cmd1.Parameters.AddWithValue("@NSS", txtNSS.Text);
cmd1.Parameters.AddWithValue("@MUTUALFUNDS", txtMutualFund.Text);
cmd1.Parameters.AddWithValue("@EQUITYLINK", txtEquityLinked.Text);
cmd1.Parameters.AddWithValue("@TUTIONFEES", txtTutionFees.Text);
cmd1.Parameters.AddWithValue("@NSC", txtNSC.Text);
cmd1.Parameters.AddWithValue("@LIC", txtLicPremium.Text);
cmd1.Parameters.AddWithValue("@JEEVANSURAKSHA", txtJeevanSuraksha.Text);
cmd1.Parameters.AddWithValue("@LIPOSTAL", txtPostalInvestment.Text);
cmd1.Parameters.AddWithValue("@UNITLINK", txtUnitInsurance.Text);
cmd1.Parameters.AddWithValue("@MEP", txtInfrastructureBond.Text);
cmd1.Parameters.AddWithValue("@INVSTINFRA", txtInvestmentInfrastructure.Text);
cmd1.Parameters.AddWithValue("@OTHERS", txtOthers.Text);
cmd1.Parameters.AddWithValue("@SEC80CCG", txtSec80CCG.Text);
cmd1.Parameters.AddWithValue("@SEC80DDB", txtSec80DDB.Text);
cmd1.Parameters.AddWithValue("@SEC80GG", txtSec80GG.Text);
cmd1.Parameters.AddWithValue("@SEC80GGC", txtSec80GGC.Text);
cmd1.Parameters.AddWithValue("@SEC80TTA", txtSec80TTA.Text);
cmd1.Parameters.AddWithValue("@SEC80U", txtSec80U.Text);
cmd1.Parameters.AddWithValue("@NPS", txtNPS.Text);
foreach (string s in ControlList1)
{
cmd1.Parameters.AddWithValue("@" + s, (placeholder.FindControl("txt" + s) as TextBox).Text);
}
foreach (string s in ControlList2)
{
cmd1.Parameters.AddWithValue("@" + s, (PlaceHolder2.FindControl("txt" + s) as TextBox).Text);
}
Response.Write("<script>alert('INSERT COMMAND:" + InsertCommand + "');</script>");
int status = 0;
status = cmd1.ExecuteNonQuery();
con.Close();
if (status == -1)
{
Response.Write("<script>alert('Error while saving data!!');</script>");
}
else
{
//Response.Write("<script>alert('Data Saved Successfully!!');</script>");
//Response.Redirect("Savings.aspx");
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Data saved sucessfully');window.location ='Savings.aspx';", true);
}
//Response.Redirect("Savings.aspx");
}
catch (Exception ee)
{
Response.Write("<script>alert('Error while saving data!!');</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
ImageButton1.Visible = false;
con.Open();
SqlCommand cmd5 = new SqlCommand("select tsize from tbltheatre where tname='" + Session["tname"].ToString() + "'", con);
tsize = Convert.ToInt16(cmd5.ExecuteScalar());
//SqlCommand cmd6 = new SqlCommand("select ttcost from tbltheatre where tname='")
// cmd6 =new SqlDataAdapter("select tsize,ttcost from tbltheatre where tname='" + Session["tname"].ToString() + "'", con);
//DataSet ds2 = new DataSet();
//cmd6.Fill(ds2);
//tsize = Convert.ToInt16(ds2.Tables[0].Rows[0]["tsize"].ToString());
SqlCommand cmd6 = new SqlCommand("select ttcost from tbltheatre where tname='" + Session["tname"].ToString() + "'", con);
tcost = Convert.ToInt16(cmd6.ExecuteScalar());
Label1.Text = "Ticket Cost Rs. " + tcost.ToString();
// Label1.Text ="Ticket Cost RS "+ ds2.Tables[0].Rows[0]["ttcost"].ToString()+"/";
s = tsize / 5;
int i, j, k, l, m, n, o, p, q, r;
for (i = 1; i <= s; i++)
{
CheckBox ch = new CheckBox();
ch.ID = i.ToString();
ch.Text = i.ToString();
PlaceHolder1.Controls.Add(ch);
}
for (j = i; j <= s + s; j++)
{
CheckBox ch1 = new CheckBox();
ch1.ID = j.ToString();
ch1.Text = j.ToString();
PlaceHolder2.Controls.Add(ch1);
}
for (k = j; k <= s + s + s; k++)
{
CheckBox ch2 = new CheckBox();
ch2.ID = k.ToString();
ch2.Text = k.ToString();
PlaceHolder3.Controls.Add(ch2);
}
for (l = k; l <= s + s + s + s; l++)
{
CheckBox ch3 = new CheckBox();
ch3.ID = l.ToString();
ch3.Text = l.ToString();
PlaceHolder4.Controls.Add(ch3);
}
for (m = l; m <= s + s + s + s + s; m++)
{
CheckBox ch4 = new CheckBox();
ch4.ID = m.ToString();
ch4.Text = m.ToString();
PlaceHolder5.Controls.Add(ch4);
}
string u = "";
SqlDataAdapter da = new SqlDataAdapter("select nooftickets, seatno from tblbooking where tname='" + Session["tname"].ToString() + "' and mname='" + Request.QueryString["mname"].ToString() + "' and showdate='" + Session["bdate"].ToString() + "' and showtime='" + Session["stime"].ToString() + "'", con);
DataSet ds = new DataSet();
da.Fill(ds);
int rcount = ds.Tables[0].Rows.Count;
if (rcount > 0)
{
rcount = rcount - 1;
while (rcount >= 0)
{
u = ds.Tables[0].Rows[rcount][1].ToString();
//string u = "32,55,1,4,8";
string[] a = u.Split(new char[] { ',' });
int b, c, d, f, z, y;
for (y = 0; y <= a.Length - 1; y++)
{
for (z = 1; z <= s; z++)
{
CheckBox lc = (CheckBox)PlaceHolder1.FindControl(z.ToString());
if (lc.Text == a[y])
{
lc.Enabled = false;
}
}
for (b = z; b <= s + s; b++)
{
CheckBox lc1 = (CheckBox)PlaceHolder2.FindControl(b.ToString());
if (lc1.Text == a[y])
{
lc1.Enabled = false;
}
}
for (c = b; c <= s + s + s; c++)
{
CheckBox lc2 = (CheckBox)PlaceHolder3.FindControl(c.ToString());
if (lc2.Text == a[y])
{
lc2.Enabled = false;
}
}
for (d = c; d <= s + s + s + s; d++)
{
CheckBox lc3 = (CheckBox)PlaceHolder4.FindControl(d.ToString());
if (lc3.Text == a[y])
{
lc3.Enabled = false;
}
}
for (f = d; f <= s + s + s + s + s; f++)
{
CheckBox lc4 = (CheckBox)PlaceHolder5.FindControl(f.ToString());
if (lc4.Text == a[y])
{
lc4.Enabled = false;
}
}
}
rcount = rcount - 1;
}
}
con.Close();
}
protected void Button2_Click(object sender, EventArgs e)
{
con.Open();
SqlDataAdapter cmd5 = new SqlDataAdapter("select tsize,ttcost from tbltheatre where tname='" + Session["tname"].ToString() + "'", con);
DataSet ds1 = new DataSet();
cmd5.Fill(ds1);
tsize = Convert.ToInt16(ds1.Tables[0].Rows[0]["tsize"].ToString());
//tcost = Convert.ToInt16(ds1.Tables[0].Rows[0]["ttcost"].ToString());
s = tsize / 5;
int ss = 0;
string sno = "";
//int s = 100 / 5;
int b, c, d, f, z, y;
for (z = 1; z <= s; z++)
{
CheckBox lc = (CheckBox)PlaceHolder1.FindControl(z.ToString());
if (lc.Checked == true)
{
ss++;
if (ss <= 5)
{
sno = lc.Text + "," + sno;
}
}
if (ss > 5)
{
lc.Checked = false;
}
}
for (b = z; b <= s + s; b++)
{
CheckBox lc1 = (CheckBox)PlaceHolder2.FindControl(b.ToString());
if (lc1.Checked == true)
{
ss++;
if (ss <= 5)
{
sno = sno + "," + lc1.Text;
}
}
if (ss > 5)
{
lc1.Checked = false;
}
}
for (c = b; c <= s + s + s; c++)
{
CheckBox lc2 = (CheckBox)PlaceHolder3.FindControl(c.ToString());
if (lc2.Checked == true)
{
ss++;
if (ss <= 5)
{
sno = sno + "," + lc2.Text;
}
}
if (ss > 5)
{
lc2.Checked = false;
}
}
for (d = c; d <= s + s + s + s; d++)
{
CheckBox lc3 = (CheckBox)PlaceHolder4.FindControl(d.ToString());
if (lc3.Checked == true)
{
ss++;
if (ss <= 5)
{
sno = sno + "," + lc3.Text;
}
}
if (ss > 5)
{
lc3.Checked = false;
}
}
for (f = d; f <= s + s + s + s + s; f++)
{
CheckBox lc4 = (CheckBox)PlaceHolder5.FindControl(f.ToString());
if (lc4.Checked == true)
{
ss++;
if (ss <= 5)
{
sno = sno + "," + lc4.Text;
}
}
if (ss > 5)
{
lc4.Checked = false;
}
}
if (ss > 5 || ss == 0)
{
Response.Write("<script>alert('Select less than or Equal to 5 seats')</script>");
}
if (ss <= 5 && ss > 0)
{
tcst = ss * Convert.ToInt16(ds1.Tables[0].Rows[0]["ttcost"].ToString());
string id = Session["uname"].ToString() + DateTime.Now;
string bookid;
bookid = id.Replace(":", "a");
bookid = bookid.Replace("-", "b");
bookid = bookid.Replace(" ", "c");
SqlCommand cmd = new SqlCommand("insert into tblbooking values('" + Session["uname"].ToString() + "','" + Session["tname"].ToString() + "','" + Request.QueryString["mname"].ToString() + "','" + Session["bdate"].ToString() + "','" + Session["stime"].ToString() + "'," + ss + ",'" + sno + "'," + tcst + ",'" + bookid + "')", con);
if (cmd.ExecuteNonQuery() > 0)
{
//SqlDataAdapter da4 = new SqlDataAdapter("select * from tblbooking where bookid =(select max(bookid) from tblbooking)", con);
SqlDataAdapter da4 = new SqlDataAdapter("select * from tblbooking where bookid ='" + bookid + "'", con);
DataSet ds4 = new DataSet();
da4.Fill(ds4);
DetailsView1.DataSource = ds4;
DetailsView1.DataBind();
Response.Write("<script>alert('Booking Successfull ')</script>");
ImageButton1.Visible = true;
}
else
{
Response.Write("<script>alert('Error')</script>");
}
}
con.Close();
}
