protected void lnkBtnLogout_Click(object sender, EventArgs e) { try { try { DBconnection con = new DBconnection(); con.AddParam("@id", int.Parse(Session["MemberTrackId"].ToString())); con.SetCommandSP = "z_UpdateUserLoginTracks"; con.ExecuteNonQuery(); } catch { } } catch { } //Session.Abandon(); //Response.Redirect("Default.aspx"); try { Session.Abandon(); // lblUsername.Text = "Guest"; lnkBtnLogin.Visible = true; // lnlBtnLogout.Visible = false; Response.Redirect("http://rotarydist3141.com/members_login.aspx?id=Profile"); } catch { } }
private void AddDomain() { try { int club_id = int.Parse(DDLClubName.SelectedValue.ToString()); DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_AddDomain"; obj.AddParam("@domain_name", txtDomainName.Text.Trim().ToString()); obj.AddParam("@ftp_username", txtFTPusername.Text.Trim().ToString()); obj.AddParam("@ftp_password", txtFTPpassword.Text.Trim().ToString()); obj.AddParam("@club_id", club_id); // MX Record string emailSP = ""; emailSP = DDLesp.SelectedValue.ToString(); if (emailSP == "Other") { emailSP = txtESPother.Text.Trim().ToString(); } obj.AddParam("@email_sp", emailSP); obj.AddParam("@mx_record", txtMXrecord.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 { } }
private void UpdateAward(int award_id) { try { DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_UpdateDistrictAward"; obj.AddParam("@award_id", award_id); 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(); showmsg("Record updated successfully !", "view_award.aspx"); } } 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 { } }
private void UpdateHotLinks(int id) { try { DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_UpdateHotLink"; obj.AddParam("@id", id); obj.AddParam("@title", txtTitle.Text.ToString()); obj.AddParam("@link_file", txtlink.Text.ToString()); int i = int.Parse(rbtnFor.SelectedValue.ToString()); if (i == 0 || i == 2) { obj.AddParam("@DistrictClubID", 0); } else { int cid = int.Parse(DDLClubName.SelectedValue.ToString()); obj.AddParam("@DistrictClubID", cid); } obj.AddParam("@link_for", rbtnFor.SelectedItem.Text.Trim().ToString()); int exe = obj.ExecuteNonQuery(); if (exe > 0) { clear(); showmsg("Record has been updated successfully", "view_hotlinks.aspx"); } } catch { } }
private void UpdateDomain(int id) { try { int club_id = int.Parse(DDLClubName.SelectedValue.ToString()); DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_UpdateDomain"; obj.AddParam("@id", id); obj.AddParam("@club_id", club_id); obj.AddParam("@domain_name", txtDomainName.Text.Trim().ToString()); obj.AddParam("@ftp_username", txtFTPusername.Text.Trim().ToString()); obj.AddParam("@ftp_password", txtFTPpassword.Text.Trim().ToString()); // MX Record string emailSP = ""; emailSP = DDLesp.SelectedValue.ToString(); if (emailSP == "Other") { emailSP = txtESPother.Text.Trim().ToString(); } obj.AddParam("@email_sp", emailSP); obj.AddParam("@mx_record", txtMXrecord.Text.Trim().ToString()); int exe = obj.ExecuteNonQuery(); if (exe > 0) { Clear(); showmsg("Record updated successfully !", "view_domain_ftp.aspx"); } } catch { } }
private void UpdateEclubs(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_UpdateEclubs"; obj.AddParam("@id", id); obj.AddParam("@club_name", txtClubname.Text.Trim().ToString()); obj.AddParam("@day", DDLDay.SelectedItem.Text.Trim().ToString()); obj.AddParam("@time", time); obj.AddParam("@district", txtDistrictNo.Text.Trim().ToString()); obj.AddParam("@country", txtCountry.Text.Trim().ToString()); obj.AddParam("@website", txtWebsite.Text.Trim().ToString()); int exe = obj.ExecuteNonQuery(); if (exe > 0) { clear(); showmsg("Record updated successfully !", "view_rotary_eclubs.aspx"); } } catch { } }
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 { } }
public int AddPassportDetails() { int i = 0; DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_AddPassportDetails"; obj.AddParam("@booking_id", this.registrationNo); obj.AddParam("@mem_dob", this.MemberDob); obj.AddParam("@mem_passport_no", this.MemberPassportNo); obj.AddParam("@mem_place_of_issue", this.MemberPlaceofIssue); obj.AddParam("@mem_date_of_issue", this.MemberDateofIssue); obj.AddParam("@mem_date_of_expiry", this.MemberDateofExpiry); obj.AddParam("@mem_img", this.MemberImg); obj.AddParam("@mem_pass_front_img", this.MemberPassportFrontImg); obj.AddParam("@mem_pass_back_img", this.MemberPassportBackImg); obj.AddParam("@spouse_dob", this.SpouseDob); obj.AddParam("@spouse_passport_no", this.SpousePassportNo); obj.AddParam("@spouse_place_of_issue", this.SpousePlaceofIssue); obj.AddParam("@spouse_date_of_issue", this.SpouseDateofIssue); obj.AddParam("@spouse_date_of_expiry", this.SpouseDateofExpiry); obj.AddParam("@spouse_img", this.SpouseImg); obj.AddParam("@spouse_pass_front_img", this.SpousePassportFrontImg); obj.AddParam("@spouse_pass_back_img", this.SpousePassportBackImg); obj.AddParam("@ipaddress", this.ipaddress); i = obj.ExecuteNonQuery(); return(i); }
private void AddUpcomingBOD() { try { //int distID = int.Parse(Session["DistrictClubID"].ToString()); int distID = int.Parse(DDLClubName.SelectedValue.ToString()); DBconnection obj = new DBconnection(); obj.SetCommandSP = "sp_AddUpcomingBOD"; int memid = int.Parse(DDLMember.SelectedValue.ToString()); string name = DDLMember.SelectedItem.Text.ToString(); string[] nameA = name.Split(' '); obj.AddParam("@fname", nameA[0]); obj.AddParam("@lname", nameA[1]); obj.AddParam("@designation", DDLDesignation.SelectedItem.Text.ToString()); obj.AddParam("@designation_id", int.Parse(DDLDesignation.SelectedValue.ToString())); obj.AddParam("@member_id", memid); obj.AddParam("@DistrictClubID", distID); obj.AddParam("@added_by", "Club"); 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 { } }
// update public int UpdateDistClubData() { int i = 0; try { DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_update_dist_club_data"; obj.AddParam("@id", this.id); obj.AddParam("@ds", this.ds); obj.AddParam("@gc", this.gc); obj.AddParam("@ag", this.ag); obj.AddParam("@phf", this.phf); obj.AddParam("@trfsm", this.trfsm); obj.AddParam("@md", this.md); obj.AddParam("@phsm", this.phsm); obj.AddParam("@ocv_date", this.ocvDate); obj.AddParam("@installation_date", this.installationDate); obj.AddParam("@installation_time", this.installationTime); obj.AddParam("@chief_guest", this.installationChiefGuest); obj.AddParam("@installation_venue", this.installationVenue); obj.AddParam("@club_trf", this.clubTrfStatus); i = obj.ExecuteNonQuery(); } catch { } return(i); }
private void AddSponser() { int maxOrdNo = GetMaxOrdNo(); string path = ""; try { DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_AddSponser_Dist"; SaveImages img = new SaveImages(); path = img.AddImages(FileUpload1.PostedFile, "Sponsers_Logo"); obj.AddParam("@start_date", DateTime.Parse(StartDate.SelectedDate.ToString())); obj.AddParam("@end_date", DateTime.Parse(EndDate.SelectedDate.ToString())); obj.AddParam("@title", txtTitle.Text.ToString()); obj.AddParam("@url", txtURL.Text.ToString()); obj.AddParam("@status", DDLStatus.SelectedItem.Text.Trim().ToString()); obj.AddParam("@logo", path); obj.AddParam("@display_order", maxOrdNo + 1); 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 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 AddSASA() { if (Page.IsValid) { try { DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_Add_service_above_self_awards"; 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 Added Successfully');</script>"; ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false); } } catch { } } }
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 { } }
// Update RI President public int UpdateRIPresident() { int i = 0; try { DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_UpdateRIPresident"; obj.AddParam("@district_no", this.district_no); obj.AddParam("@participant", this.participant); obj.AddParam("@description", this.description); obj.AddParam("@id", this.id); obj.AddParam("@year", this.year); obj.AddParam("@fname", this.fname); obj.AddParam("@mname", this.mname); obj.AddParam("@lname", this.lname); obj.AddParam("@club_name", this.club_name); obj.AddParam("@district", this.district); obj.AddParam("@country", this.country); obj.AddParam("@theme", this.theme); obj.AddParam("@convention", this.convention); obj.AddParam("@president_image", this.president_image); obj.AddParam("@theme_logo", this.theme_logo); obj.AddParam("@convention_image", this.convention_image); i = obj.ExecuteNonQuery(); } catch { } return(i); }
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 { } } }
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 { } }
private void UpdateAttendance(int id) { DateTime?dt1, dt2; try { DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_UpdateClubAttendance"; obj.AddParam("@id", id); obj.AddParam("@club_id", int.Parse(DDLClubName.SelectedValue.ToString())); obj.AddParam("@month", DDLMonth.SelectedItem.Text.ToString()); obj.AddParam("@President", lblPresiName.Text.ToString()); obj.AddParam("@Secretary", lblSecName.Text.Trim().ToString()); obj.AddParam("@Membership_Strength", txtMemStrength.Text.Trim()); obj.AddParam("@Average_Attendance", txtAvgAttendance.Text.Trim()); obj.AddParam("@No_of_Meetings_Held", txtMeetingHeld.Text.Trim()); obj.AddParam("@No_of_Meetings_Cancelled", txtMeetingCancelled.Text.Trim()); try { dt1 = DateTime.Parse(dateCancelledMtng1.SelectedDate.ToString()); obj.AddParam("@Canceled_Meeting_Date_1", dt1); } catch { obj.AddParam("@Canceled_Meeting_Date_1", ""); } obj.AddParam("@Reason_for_Cancelled_1", txtCancelledMtngRes1.Text.Trim()); try { dt2 = DateTime.Parse(dateCancelledMtng2.SelectedDate.ToString()); obj.AddParam("@Canceled_Meeting_Date_2", dt2); } catch { obj.AddParam("@Canceled_Meeting_Date_2", ""); } obj.AddParam("@Reason_for_Cancelled_2", txtCancelledMtngRes2.Text.Trim()); obj.AddParam("@ds", lblDS.Text.ToString()); obj.AddParam("@ag", lblAG.Text.ToString()); obj.AddParam("@gc", lblGC.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); } } catch { } }
private void AddEclubs() { 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_AddEclubs"; obj.AddParam("@club_name", txtClubname.Text.Trim().ToString()); obj.AddParam("@day", DDLDay.SelectedItem.Text.Trim().ToString()); obj.AddParam("@time", time); obj.AddParam("@district", txtDistrictNo.Text.Trim().ToString()); obj.AddParam("@country", txtCountry.Text.Trim().ToString()); obj.AddParam("@website", txtWebsite.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 { } }
public int AddCandidate() { int i = 0; DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_AddCandidates"; obj.AddParam("@election_id", this.ElectionId); obj.AddParam("@district_no", this.DistrictNo); obj.AddParam("@years", this.Years); obj.AddParam("@club_name", this.ClubName); obj.AddParam("@name", this.Name); obj.AddParam("@joining_date", this.JoiningDate); obj.AddParam("@classification", this.Classification); obj.AddParam("@membership_no", this.MembershipNo); obj.AddParam("@email", this.Email); obj.AddParam("@mobile", this.Mobile); obj.AddParam("@birthday", this.Birthday); obj.AddParam("@description", this.Description); obj.AddParam("@photo", this.Photo); obj.AddParam("@biodata", this.BioData); obj.AddParam("@ipaddress", this.Ipaddress); i = obj.ExecuteNonQuery(); return(i); }
// 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); }
protected void RadGrid1_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e) { if (e.CommandName == "Delete") { string i = e.CommandArgument.ToString(); int id = int.Parse(i.ToString()); DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_DeleteProjectContacts"; obj.AddParam("@id", id); if (obj.ExecuteNonQuery() > 0) { // RadGrid1.DataBind(); //BindContacts(0); //int idd = int.Parse(Request.QueryString["id"].ToString()); // GetProjects(idd); // BindImages(idd); } } if (e.CommandName == "Edit") { string i = e.CommandArgument.ToString(); int id = int.Parse(i.ToString()); DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_GetProjectContactsById"; obj.AddParam("@id", id); if (obj.ExecuteNonQuery() > 0) { GetContacts(id); } } }
public bool ExcluirLogin(int id) { SqlCommand comando = new DBconnection().GetConnction(); comando.CommandText = "DELETE FROM login WHERE login id = @ID"; comando.Parameters.AddWithValue("@ID", id); return(comando.ExecuteNonQuery() == 1); }
public bool DeleteCategoryDetails(string Name) { bool IsDeleted = false; List <SqlParameter> sqlParameters = new List <SqlParameter>(); sqlParameters.Add(new SqlParameter("@CategoryName", Name)); IsDeleted = DBconnection.ExecuteNonQuery(SPNames.DeleteItemByName, sqlParameters.ToArray()); return(IsDeleted); }
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(); }
public int DeleteCandidate() { int i = 0; DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_DeleteCandidates"; obj.AddParam("@id", this.Id); i = obj.ExecuteNonQuery(); return(i); }
public int DeletePrtoject() { int i = 0; DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_DeletePrtoject"; obj.AddParam("@id", this.id); i = obj.ExecuteNonQuery(); return(i); }
//private void BindIW(int id) //{ // DataTable dt = new DataTable(); // DBconnection obj = new DBconnection(); // obj.SetCommandQry = "SELECT * FROM distclub_iw_tbl where club_id=" + id; // dt = obj.ExecuteTable(); // if (dt.Rows.Count > 0) // { // //GridView1.DataSourceID = "SqlDataSource1"; // rbtnIW.SelectedIndex = 0; // trIW.Visible = true; // GridView1.DataSource = dt; // GridView1.DataBind(); // } // else // { // rbtnIW.SelectedIndex = 1; // trIW.Visible = false; // } //} private void DeleteAllTempData() { try { DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_DeleteTempClubData"; int exe = obj.ExecuteNonQuery(); } catch { } }