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 { }
}
