private void AddOCV() { try { string h, m, am, time = ""; h = DDLTimeH.SelectedItem.Text; m = DDLTimeM.SelectedItem.Text; am = DDLTimeAMPM.SelectedItem.Text; time = h + ":" + m + ":" + am; DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_AddOCVCal"; obj.AddParam("@club_name", DDLClubName.SelectedItem.Text.Trim().ToString()); obj.AddParam("@club_id", int.Parse(DDLClubName.SelectedValue.ToString())); obj.AddParam("@date", DateTime.Parse(RadDatePicker1.SelectedDate.Value.ToString())); obj.AddParam("@time", time); int exe = obj.ExecuteNonQuery(); if (exe > 0) { clear(); string jv = "<script>alert('Record Added Successfully');</script>"; ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false); } } catch { } }
private void BindGrid(string yrs, string position) { DataTable dt = new DataTable(); DBconnection obj = new DBconnection(); // obj.SetCommandQry = "SELECT * FROM [View_DistPositionHeldMembers] where district_no='3141' and years='" + yrs + "' and avenue='" + position + "' order by Name"; obj.SetCommandSP = "z_GetPositionByAvenue"; obj.AddParam("@district_no", 3141); obj.AddParam("@years", yrs); obj.AddParam("@avenue", position); dt = obj.ExecuteTable(); if (dt.Rows.Count > 0) { lblMsg.Visible = false; RadGrid1.Visible = true; RadGrid1.DataSourceID = string.Empty; RadGrid1.DataSource = dt; RadGrid1.Rebind(); } else { lblMsg.Visible = true; RadGrid1.Visible = false; } }
private void GetEventByDate() { //string[] dFrom = dateFrom.SelectedDate.ToString().Split(' '); //string[] dTo = dateTo.SelectedDate.ToString().Split(' '); //string dFromm = dFrom[0].Replace('/', '-'); //string dtoo = dTo[0].Replace('/', '-'); DateTime dFromm = DateTime.Parse(dateFrom.DbSelectedDate.ToString()); DateTime dtoo = DateTime.Parse(dateTo.DbSelectedDate.ToString()); //string dtoo = dTo[0].Replace('/', '-'); DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_SortOrderbyDate_sp"; obj.AddParam("@dFrom", dFromm); obj.AddParam("@dTo", dtoo); DataTable dt = new DataTable(); dt = obj.ExecuteTable(); if (dt.Rows.Count > 0) { lblMsg.Visible = false; RadGrid1.Visible = true; RadGrid1.DataSourceID = string.Empty; RadGrid1.DataSource = dt; RadGrid1.Rebind(); } else { lblMsg.Visible = true; RadGrid1.Visible = false; } }
private void UpdateOCV(int id) { try { string h, m, am, time = ""; h = DDLTimeH.SelectedItem.Text; m = DDLTimeM.SelectedItem.Text; am = DDLTimeAMPM.SelectedItem.Text; time = h + ":" + m + ":" + am; DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_UpdateOCVCal"; obj.AddParam("@id", id); obj.AddParam("@club_name", DDLClubName.SelectedItem.Text.Trim().ToString()); obj.AddParam("@club_id", int.Parse(DDLClubName.SelectedValue.ToString())); obj.AddParam("@date", DateTime.Parse(RadDatePicker1.SelectedDate.Value.ToString())); obj.AddParam("@time", time); int exe = obj.ExecuteNonQuery(); if (exe > 0) { clear(); showmsg("Record updated successfully !", "view_ocv_cal.aspx"); } } catch { } }
private void UpdatePastDistrictGove(int id) { try { DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_UpdatePastDistGove"; obj.AddParam("@id", id); string yrs = DDLYears.SelectedItem.Text.ToString(); obj.AddParam("@year", yrs); obj.AddParam("@rotarian_name", txtRotarian.Text.ToString()); obj.AddParam("@club_name", txtClubName.Text.ToString()); int exe = obj.ExecuteNonQuery(); if (exe > 0) { clear(); showmsg("Record Updated Successfully", "view_past_district_gove.aspx"); //string jv = "<script>alert('Record Updated Successfully');</script>"; //ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false); } } catch { } }
private void AddAward() { try { DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_AddDistrictAward"; obj.AddParam("@category", DDLCategory.SelectedItem.Text.Trim().ToString()); obj.AddParam("@award_name", txtAwardName.Text.Trim().ToString()); string ss = DDLDonor.SelectedItem.Text.Trim().ToString(); if (ss == "Select") { obj.AddParam("@donor", txtOtherDonor.Text.Trim().ToString()); } else { obj.AddParam("@donor", DDLDonor.SelectedItem.Text.Trim().ToString()); } obj.AddParam("@constituted_on", DDLYear.SelectedItem.Text.Trim().ToString()); int exe = obj.ExecuteNonQuery(); if (exe > 0) { clear(); string jv = "<script>alert('Record Added Successfully');</script>"; ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false); } } catch { } }
protected void btnUpdate_Click(object sender, EventArgs e) { DBconnection obj = new DBconnection(); obj.SetCommandSP = "UpdateImagetoDB"; obj.AddParam("@ID", 1); obj.AddParam("@Name", TextBox1.Text.Trim().ToString()); obj.AddParam("@Picture", (byte[])Session["Image"]); obj.ExecuteNonQuery(); }
private void UpdateDisconRegistrationRate(int id) { try { DBconnection obj = new DBconnection(); obj.SetCommandSP = "disc_UpdateDisconRegistrationFees"; obj.AddParam("@id", id); obj.AddParam("@member_type", rbtnMemType.SelectedItem.Text.Trim().ToString()); obj.AddParam("@category", ddlCat.SelectedItem.Text.Trim().ToString()); obj.AddParam("@registration_fees_for", rbtnRegisFor.SelectedItem.Text.Trim().ToString()); try { obj.AddParam("@date_from", DateTime.Parse(dateFrom.SelectedDate.ToString())); } catch { obj.AddParam("@date_from", null); } try { obj.AddParam("@date_to", DateTime.Parse(dateTo.SelectedDate.ToString())); } catch { obj.AddParam("@date_to", null); } obj.AddParam("@amount", decimal.Parse(txtAmt.Text.Trim().ToString())); int exe = obj.ExecuteNonQuery(); if (exe > 0) { clear(); showmsg("Record updated successfully !", "view_add_discon_registration_rate.aspx"); } } catch { } }
private void UpdateDonors(int id) { try { DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_UpdateBenif_Bequest"; obj.AddParam("@id", id); obj.AddParam("@level", ddlLevel.SelectedItem.Text.ToString()); obj.AddParam("@title", drtitle.SelectedItem.Text.ToString()); obj.AddParam("@fname", txtfname.Text.ToString()); obj.AddParam("@mname", txtmname.Text.ToString()); obj.AddParam("@lname", txtlname.Text.ToString()); obj.AddParam("@DistrictClubID", int.Parse(DDLClubName.SelectedValue.ToString())); obj.AddParam("@club_name", DDLClubName.SelectedItem.Text.ToString()); obj.AddParam("@achieved_date", DateTime.Parse(RadDatePicker1.SelectedDate.ToString())); int exe = obj.ExecuteNonQuery(); if (exe > 0) { clear(); //string jv = "<script>alert('Record Has Been Updated Successfully');</script>"; //ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false); showmsg("Record Has Been Updated Successfully", "view_benefactors_members.aspx"); } } catch { } }
public DataTable GetDistrictClub() { DBconnection obj = new DBconnection(); DataTable dt = new DataTable(); obj.SetCommandSP = "z_GetDistClub"; obj.AddParam("@district_no", this.DistrictNo); obj.AddParam("@voting_eligibility", this.VotingEligibility); dt = obj.ExecuteTable(); return(dt); }
public DataTable GetVoteResultByNonePref3() { DBconnection obj = new DBconnection(); DataTable dt = new DataTable(); obj.SetCommandSP = "z_GetVotingResultByNonePref3"; obj.AddParam("@district_no", this.DistrictNo); obj.AddParam("@years", this.Years); dt = obj.ExecuteTable(); return(dt); }
public DataTable GetDesiForSendMail() { DBconnection obj = new DBconnection(); DataTable dt = new DataTable(); obj.SetCommandSP = "z_GetDesiForSendMail"; obj.AddParam("@district_no", this.DistrictNo); obj.AddParam("@desig_type", this.DesiType); dt = obj.ExecuteTable(); return(dt); }
public DataTable GetCandidateInPref2() { DBconnection obj = new DBconnection(); DataTable dt = new DataTable(); obj.SetCommandSP = "z_GetCandidatesInPref2"; obj.AddParam("@district_no", this.DistrictNo); obj.AddParam("@candidate_id", this.CandidatesId); dt = obj.ExecuteTable(); return(dt); }
public DataTable GetCandidateByDistNo() { DBconnection obj = new DBconnection(); DataTable dt = new DataTable(); obj.SetCommandSP = "z_GetCandidatesByDistNo"; obj.AddParam("@years", this.Years); obj.AddParam("@district_no", this.DistrictNo); dt = obj.ExecuteTable(); return(dt); }
private void BindGridDate() { Session["SearchField"] = null; Session["SearchBy"] = null; Session["SearchByAlphabetic"] = null; Session["SortBy"] = null; Session["SortByDateRange"] = "Date Range"; //string[] dFrom = dateFrom.SelectedDate.ToString().Split(' '); //string[] dTo = dateTo.SelectedDate.ToString().Split(' '); //string dFromm = dFrom[0].Replace('/', '-'); //string dtoo = dTo[0].Replace('/', '-'); DateTime dFromm = DateTime.Parse(dateFrom.DbSelectedDate.ToString()); DateTime dtoo = DateTime.Parse(dateTo.DbSelectedDate.ToString()); //string dtoo = dTo[0].Replace('/', '-'); DBconnection obj = new DBconnection(); ///************Code For Local Database **********/ //try //{ // string distConnString = obj.GetLocalConnString(); // obj.SetConnString = distConnString; //} //catch //{ //} ///*********************************************/ obj.SetCommandSP = "z_SortOrderbyDate"; obj.AddParam("@dFrom", dFromm); obj.AddParam("@dTo", dtoo); DataTable dt = new DataTable(); dt = obj.ExecuteTable(); if (dt.Rows.Count > 0) { PanelDate.Visible = true; lblError.Visible = false; RadGrid1.Visible = true; RadGrid1.DataSourceID = string.Empty; RadGrid1.DataSource = dt; RadGrid1.Rebind(); } else { lblError.Visible = true; RadGrid1.Visible = false; } }
public int UpdateColors() { int i = 0; DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_UpdateDistrictNo"; obj.AddParam("@id", this.id); obj.AddParam("@district_no", this.districtNo); i = obj.ExecuteNonQuery(); return(i); }
public int UpdateDollorRate() { int i = 0; DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_UpdateDollorRate"; obj.AddParam("@id", this.id); obj.AddParam("@dollor_rate", this.dollorRate); i = obj.ExecuteNonQuery(); return(i); }
public DataTable GetVotedClubs() { DBconnection obj = new DBconnection(); DataTable dt = new DataTable(); obj.SetCommandSP = "z_GetVotedClubs"; obj.AddParam("@district_no", this.DistrictNo); obj.AddParam("@election_id", this.ElectionId); // obj.AddParam("@years", this.Years); dt = obj.ExecuteTable(); return(dt); }
public DataTable GetVotingResultDistrictWise() { DBconnection obj = new DBconnection(); DataTable dt = new DataTable(); obj.SetCommandSP = "z_GetVotingResultByDistrictWise"; obj.AddParam("@election_id", this.ElectionId); obj.AddParam("@district_no", this.DistrictNo); dt = obj.ExecuteTable(); return(dt); }
protected void btnSubmit_Click(object sender, EventArgs e) { if (Page.IsValid) { DBconnection con = new DBconnection(); DataTable objdt = new DataTable(); con.SetCommandSP = "z_LoginUser"; con.AddParam("@uname", txtUsername.Text.Trim().ToString()); con.AddParam("@pass", txtPassword.Text.Trim().ToString()); objdt = con.ExecuteTable(); if (objdt.Rows.Count > 0) { // LblInvalid.Visible = false; Session["user"] = txtUsername.Text; Session["Admin"] = txtUsername.Text; Session["AdminUserName"] = objdt.Rows[0]["FName"].ToString() + " " + objdt.Rows[0]["LName"].ToString(); //Session["AdminUserName"] = objdt.Rows[0]["Name"].ToString(); Session["Uid"] = objdt.Rows[0]["UID"].ToString(); Session["Add"] = objdt.Rows[0]["UAdd"].ToString(); Session["View"] = objdt.Rows[0]["UView"].ToString(); Session["Edit"] = objdt.Rows[0]["UEdit"].ToString(); Session["Delete"] = objdt.Rows[0]["UDelete"].ToString(); if (ckremember.Checked) { if (ckremember.Checked) { if (Request.Browser.Cookies == true) { HttpCookie loginCook = new HttpCookie("UserCook1"); loginCook["AdminUserName"] = txtUsername.Text.ToString(); loginCook["AdminPass"] = txtPassword.Text.ToString(); loginCook.Expires = DateTime.Now.AddDays(1); Response.Cookies.Add(loginCook); } } } Response.Redirect("ViewDistrictClubs.aspx"); } else { //LblInvalid.Visible = true; string msg = "Invalid Username or Password"; showmsg(msg); } } }
private void UpdateAOSC(int id) { if (Page.IsValid) { try { DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_UpdateAvenues_of_service"; obj.AddParam("@id", id); obj.AddParam("@years", DDLYears.SelectedItem.Text.ToString()); obj.AddParam("@title", drtitle.SelectedItem.Text.ToString()); obj.AddParam("@fname", txtfname.Text.ToString()); obj.AddParam("@mname", txtmname.Text.ToString()); obj.AddParam("@lname", txtlname.Text.ToString()); obj.AddParam("@DistrictClubID", int.Parse(DDLClubName.SelectedValue.ToString())); obj.AddParam("@club_name", DDLClubName.SelectedItem.Text.ToString()); int exe = obj.ExecuteNonQuery(); if (exe > 0) { clear(); //string jv = "<script>alert('Record Has Been Updated Successfully');</script>"; //ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false); showmsg("Record Has Been Updated Successfully", "view_major_donors.aspx"); } } catch { } } }
// Add public int AddRiDgData() { int i = 0; try { // year, name, clubName, designation, classfication, image, description DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_AddRiDgData"; obj.AddParam("@year", this.year); obj.AddParam("@name", this.name); obj.AddParam("@club_name", this.clubName); obj.AddParam("@designation", this.designation); obj.AddParam("@classification", this.classfication); obj.AddParam("@image", this.image); obj.AddParam("@description", this.description); obj.AddParam("@ipaddress", this.ipaddress); i = obj.ExecuteNonQuery(); } catch { } return(i); }
private void AddDistOfficers() { try { DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_AddDistOfficers"; obj.AddParam("@Member_id", int.Parse(DDLMemName.SelectedValue.ToString())); obj.AddParam("@years", DDLYears.SelectedItem.Text.Trim().ToString()); obj.AddParam("@type", rbtnType.SelectedItem.Text.Trim().ToString()); obj.AddParam("@DistDesigID", int.Parse(DDLDesig.SelectedValue.ToString())); //try //{ // obj.AddParam("@DistSubDesigID", int.Parse(DDLSubDesig.SelectedValue.ToString())); //} //catch //{ // obj.AddParam("@DistSubDesigID", 0); //} //string topics = ""; //if (listTopics.Items.Count > 0) //{ // RFVDesig.Visible = false; // foreach (ListItem li in listTopics.Items) // { // topics = topics + li.Value.Trim().ToString() + ";"; // } //} //if (int.Parse(DDLDesig.SelectedValue.ToString())!= 0) //{ // topics = topics + int.Parse(DDLDesig.SelectedValue.ToString()); //} int exe = obj.ExecuteNonQuery(); if (exe > 0) { clear(); string jv = "<script>alert('Record has been added successfully');</script>"; ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false); } } catch { } }
private void SearchByAlphabet(string name) { rbtnSearch.ClearSelection(); txtName.Text = ""; DDLClubName.Visible = false; txtName.Visible = true; btnSearch.Visible = true; Session["value"] = null; Session["searchField"] = null; Session["name"] = name; DataTable dt = new DataTable(); DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_SearchByAlphabetPeaceSeminar"; obj.AddParam("@f_name", name); dt = obj.ExecuteTable(); if (dt.Rows.Count > 0) { lblMsg.Visible = false; RadGrid1.Visible = true; RadGrid1.DataSourceID = string.Empty; RadGrid1.DataSource = dt; RadGrid1.Rebind(); } else { lblMsg.Visible = true; RadGrid1.Visible = false; } }
private void GetClubDetails(int id) { DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_GetDistrictClubDetails"; obj.AddParam("@id", id); DataTable dt = new DataTable(); dt = obj.ExecuteTable(); if (dt.Rows.Count > 0) { string[] time = dt.Rows[0]["time"].ToString().Split(':'); DDLTimeH.SelectedItem.Text = time[0].ToString(); DDLTimeM.SelectedItem.Text = time[1].ToString(); DDLTime.SelectedItem.Text = time[2].ToString(); txtvenue.Text = dt.Rows[0]["venue1"].ToString() + " " + dt.Rows[0]["venue2"].ToString() + " " + dt.Rows[0]["city"].ToString(); //string gps = dt.Rows[0]["gps_latitude"].ToString(); //if (gps != "") //{ // lblGPS.Text = "Latitude : " + dt.Rows[0]["gps_latitude"].ToString() + " " + "Longitude : " + dt.Rows[0]["gps_longitude"].ToString(); //} //else //{ // lblGPS.Text = ""; //} } }
private void GetUser(int id) { try { DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_GetUser"; obj.AddParam("@UID", id); DataTable dt = new DataTable(); dt = obj.ExecuteTable(); if (dt.Rows.Count > 0) { txtPassword.TextMode = TextBoxMode.SingleLine; txtConfirmPassword.TextMode = TextBoxMode.SingleLine; txtUsername.Text = dt.Rows[0]["UserName"].ToString(); txtPassword.Text = dt.Rows[0]["Password"].ToString(); txtConfirmPassword.Text = dt.Rows[0]["Password"].ToString(); txtFirstName.Text = dt.Rows[0]["FName"].ToString(); txtLastName.Text = dt.Rows[0]["LName"].ToString(); txtDesignation.Text = dt.Rows[0]["Designation"].ToString(); string uAdd = dt.Rows[0]["UAdd"].ToString(); if (uAdd == "True") { UAddCheckBox.Checked = true; } string uEdit = dt.Rows[0]["UEdit"].ToString(); if (uEdit == "True") { UEditCheckBox.Checked = true; } string uDelete = dt.Rows[0]["UDelete"].ToString(); if (uDelete == "True") { UDeleteCheckBox.Checked = true; } string uView = dt.Rows[0]["UView"].ToString(); if (uView == "True") { UViewCheckBox.Checked = true; } txtEmail.Text = dt.Rows[0]["Email"].ToString(); txtMobCC.Text = dt.Rows[0]["MobileCC"].ToString(); txtMobile.Text = dt.Rows[0]["Mobile"].ToString(); txtPhCC.Text = dt.Rows[0]["Phone_CC"].ToString(); txtPhAC.Text = dt.Rows[0]["Phone_AC"].ToString(); txtPhone.Text = dt.Rows[0]["Phone"].ToString(); txtCity.Text = dt.Rows[0]["City"].ToString(); txtState.Text = dt.Rows[0]["State"].ToString(); txtAddress1.Text = dt.Rows[0]["Address1"].ToString(); txtAddress2.Text = dt.Rows[0]["Address2"].ToString(); } } catch { } }
private void BindGrid(string clubName) { DataTable dt = new DataTable(); DBconnection obj = new DBconnection(); //obj.SetCommandQry = "SELECT * FROM [View_DistPositionHeldMembers] where district_no='3141' and years='" + yrs + "' and club_name='" + clubName + "' order by Name"; obj.SetCommandSP = "z_GetClubwisePositionReport"; // obj.AddParam("@years", yrs); obj.AddParam("@club_name", clubName); dt = obj.ExecuteTable(); if (dt.Rows.Count > 0) { lblMsg.Visible = false; RadGrid1.Visible = true; RadGrid1.DataSourceID = string.Empty; RadGrid1.DataSource = dt; RadGrid1.Rebind(); } else { lblMsg.Visible = true; RadGrid1.Visible = false; } }
private void GetInstalation(int id) { DDLClubName.DataSourceID = "DSDistClubNo"; DDLClubName.DataBind(); DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_GetInstalationCal"; obj.AddParam("@id", id); DataTable dt = new DataTable(); dt = obj.ExecuteTable(); if (dt.Rows.Count > 0) { DDLClubName.SelectedItem.Text = dt.Rows[0]["club_name"].ToString(); DDLClubName.SelectedValue = dt.Rows[0]["club_id"].ToString(); RadDatePicker1.DbSelectedDate = DateTime.Parse(dt.Rows[0]["date"].ToString()); string[] time = dt.Rows[0]["time"].ToString().Split(':'); DDLTimeH.SelectedValue = time[0].ToString(); DDLTimeM.SelectedValue = time[1].ToString(); DDLTimeAMPM.SelectedValue = time[2].ToString(); DDLcg.SelectedItem.Text = dt.Rows[0]["cheif_guest"].ToString(); DDLcg.SelectedValue = dt.Rows[0]["cheif_guest"].ToString(); } }
private void SearchByAlphabet(string name) { Session["name"] = name; DataTable dt = new DataTable(); DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_SearchByAlphabetProject"; obj.AddParam("@f_name", name); dt = obj.ExecuteTable(); if (dt.Rows.Count > 0) { lblMsg.Visible = false; RadGrid1.Visible = true; RadGrid1.DataSourceID = string.Empty; RadGrid1.DataSource = dt; RadGrid1.Rebind(); } else { lblMsg.Visible = true; RadGrid1.Visible = false; } }
private void GetPositionHeld(int id) { DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_GetPositionHeld"; obj.AddParam("@id", id); DataTable dt = new DataTable(); dt = obj.ExecuteTable(); if (dt.Rows.Count > 0) { DDLClubName.DataSourceID = "DSDistClubName"; DDLClubName.DataBind(); int clubId = int.Parse(dt.Rows[0]["club_id"].ToString()); BindMembers(clubId); DDLClubName.SelectedValue = dt.Rows[0]["club_id"].ToString(); DDLMember.SelectedValue = dt.Rows[0]["member_id"].ToString(); DDLPHYear.SelectedItem.Text = dt.Rows[0]["years"].ToString(); DDLPHeld.SelectedValue = dt.Rows[0]["position_held_on"].ToString(); GetDistAvenue(DDLPHYear.SelectedItem.Text.Trim()); DDLAvenue.SelectedItem.Text = dt.Rows[0]["avenue"].ToString(); // GetDistDesignation(int.Parse(DDLAvenue.SelectedValue.ToString())); DDLPosition.SelectedItem.Text = dt.Rows[0]["position"].ToString(); } }