private void UpdatePresident(int id)
{
try
{
PresidentBll obj = new PresidentBll();
obj.Id = id;
obj.DistrictNo = ddlDistNo.SelectedItem.Text.Trim().ToString();
obj.ClubName = ddlClubName.SelectedItem.Text.Trim().ToString();
obj.FirstName = txtFirstName.Text.Trim().ToString();
obj.LastName = txtLastName.Text.Trim().ToString();
obj.Email = txtEmail.Text.Trim().ToString();
obj.Mobile = txtMobile.Text.Trim().ToString();
// obj.DesiType = "Executive Committee";
// obj.Password = txtPassword.Text.Trim().ToString();
int i = obj.UpdatePresident();
if (i > 0)
{
Clear();
showmsg("Executive Committee Has Been Updated Successfully", "ViewExecutiveCommittee.aspx");
//string jv = "<script>alert('Candidates Has Been Updated Successfully');</script>";
//ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
}
}
catch { }
}
//private void BindPresidents(int districtNo)
//{
// DataTable dt = new DataTable();
// PresidentBll obj = new PresidentBll();
// obj.DistrictNo = districtNo.ToString();
// dt = obj.GetPresidentByDistNo();
// if (dt.Rows.Count > 0)
// {
// Session["AllPresidents"] = districtNo;
// btnSendLoginPass.Visible = true;
// btnSendTestLoginPass.Visible = true;
// lblMsg.Visible = false;
// RadGrid1.Visible = true;
// RadGrid1.DataSource = dt;
// RadGrid1.DataBind();
// }
// else
// {
// lblMsg.Visible = true;
// RadGrid1.Visible = false;
// }
//}
private void BindPresidents(int districtNo, string designation)
{
DataTable dt = new DataTable();
PresidentBll obj = new PresidentBll();
obj.DistrictNo = districtNo.ToString();
obj.DesiType = designation.ToString();
dt = obj.GetDesiForSendMail();
if (dt.Rows.Count > 0)
{
Session["AllPresidents"] = districtNo;
btnSendLoginPass.Visible = true;
btnSendTestLoginPass.Visible = true;
lblMsg.Visible = false;
RadGrid1.Visible = true;
RadGrid1.DataSource = dt;
RadGrid1.DataBind();
}
else
{
lblMsg.Visible = true;
RadGrid1.Visible = false;
}
}
protected void RadGrid1_ItemCommand(object source, Telerik.Web.UI.GridCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
string i = e.CommandArgument.ToString();
int id = int.Parse(i.ToString());
PresidentBll obj = new PresidentBll();
obj.Id = id;
if (obj.DeletePresident() > 0)
{
RadGrid1.DataBind();
}
}
}
private void GetAllPresident()
{
PresidentBll obj = new PresidentBll();
DataTable dt = new DataTable();
dt = obj.GetAllPresidentReport();
if (dt.Rows.Count > 0)
{
btnExporttoExcel.Visible = true;
RadGrid1.Visible = true;
RadGrid1.DataSourceID = string.Empty;
RadGrid1.DataSource = dt;
RadGrid1.DataBind();
}
}
protected void ddlDistNo_SelectedIndexChanged(object sender, EventArgs e)
{
PresidentBll obj = new PresidentBll();
obj.DistrictNo = ddlDistNo.SelectedItem.Text.Trim();
DataTable dt = new DataTable();
dt = obj.GetPresidentReport();
if (dt.Rows.Count > 0)
{
btnExporttoExcel.Visible = true;
RadGrid1.Visible = true;
RadGrid1.DataSourceID = string.Empty;
RadGrid1.DataSource = dt;
RadGrid1.DataBind();
}
}
private void AddPresident()
{
try
{
string strClubName = string.Empty;
strClubName = ddlClubName.SelectedItem.Text.Trim().ToString();
if (strClubName == "Select")
{
strClubName = "";
}
/************Code for find IP address of user's machine**********/
string ipaddress;
ipaddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
if (ipaddress == "" || ipaddress == null)
{
ipaddress = Request.ServerVariables["REMOTE_ADDR"];
}
/***************************************************************/
PresidentBll obj = new PresidentBll();
string password = MakePassword(8);
obj.DistrictNo = ddlDistNo.SelectedItem.Text.Trim().ToString();
obj.ClubName = strClubName;
obj.FirstName = txtFirstName.Text.Trim().ToString();
obj.LastName = txtLastName.Text.Trim().ToString();
obj.Email = txtEmail.Text.Trim().ToString();
obj.Mobile = txtMobile.Text.Trim().ToString();
obj.Password = password;
obj.Ipaddress = ipaddress;
obj.DesiType = "Executive Committee";
int i = obj.AddPresident();
if (i > 0)
{
Clear();
string jv = "<script>alert('Executive Committee Has Been Added Successfully');</script>";
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
}
}
catch (Exception ex) { string s = ex.Message; }
}
//protected void btnSendLoginPass_Click(object sender, EventArgs e)
//{
// int id = 0;
// string email, password, clubName, presidentName, distNo = "";
// foreach (GridDataItem item in RadGrid1.MasterTableView.Items)
// {
// try
// {
// CheckBox chkbox = (CheckBox) item.FindControl("chkActive");
// Label lblMemId = (Label) item.FindControl("lblMemId");
// if (chkbox.Checked)
// {
// id = Int32.Parse(lblMemId.Text.ToString());
// try
// {
// DBconnection con = new DBconnection();
// con.SetCommandQry = "select * from club_presidents_tbl where id='" + id + "'";
// DataTable dt = con.ExecuteTable();
// email = dt.Rows[0]["email"].ToString();
// password = dt.Rows[0]["password"].ToString();
// clubName = dt.Rows[0]["club_name"].ToString();
// presidentName = dt.Rows[0]["first_name"].ToString() + " " + dt.Rows[0]["last_name"].ToString();
// distNo = dt.Rows[0]["district_no"].ToString();
// SendMailtoClient(presidentName, clubName, email, password, distNo);
// }
// catch { }
// }
// chkbox.Checked = false;
// }
// catch { }
// }
// // ManageGrid();
//}
//private void SendMailtoClient(string presidentName, string clubName, string email, string password, string distNo)
//{
// try
// {
// //string years, website = "";
// //if(distNo==3231)
// //{
// // years = "2017-18";
// // website = "http://rid3231evoting.com/";
// //}
// //if (distNo == 3231)
// //{
// // years = "2017-18";
// // website = "http://rid3231evoting.com/";
// //}
// //if (distNo == 3231)
// //{
// // years = "2017-18";
// // website = "http://rid3231evoting.com/";
// //}
// MailMessage mail = new MailMessage();
// //mail.To.Add(email);
// mail.To.Add("*****@*****.**");
// mail.From = new MailAddress("*****@*****.**");
// // mail.Bcc.Add("*****@*****.**");
// mail.Subject = "RID" + distNo + " E-Voting Login Information";
// mail.IsBodyHtml = true;
// string pathVal = Server.MapPath("~");
// string readFileName = pathVal + "/Mail/PresidentLoginMail.htm";
// string strMessage = "";
// StreamReader sr1 = new StreamReader(readFileName);
// strMessage = sr1.ReadToEnd();
// strMessage = strMessage.Replace("xxxDistrictNo", distNo.ToString());
// //strMessage = strMessage.Replace("xxxYears", years);
// // strMessage = strMessage.Replace("xxxWebsite", website);
// strMessage = strMessage.Replace("xxxPresident", presidentName);
// //strMessage = strMessage.Replace("xxxClub", clubName);
// strMessage = strMessage.Replace("xxxEmail", email);
// strMessage = strMessage.Replace("xxxPassword", password);
// mail.Body = strMessage;
// sr1.Close();
// SmtpClient emailClient = new SmtpClient();
// emailClient.Credentials = new NetworkCredential("*****@*****.**", "G&s5h%90");
// emailClient.Port = 587;
// emailClient.Host = "smtp.zoho.com";
// emailClient.EnableSsl = true;
// emailClient.Send(mail);
// string jv = "<script>alert('Mail has been sent successfully');</script>";
// ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
// }
// catch (Exception ex)
// {
// string ss = ex.ToString();
// }
//}
private void GetExecutiveCommittee(string districtNo)
{
PresidentBll obj = new PresidentBll();
DataTable dt = new DataTable();
obj.DistrictNo = districtNo;
dt = obj.GetExecutiveCommittee();
if (dt.Rows.Count > 0)
{
lblMsg.Visible = false;
RadGrid1.Visible = true;
RadGrid1.DataSourceID = string.Empty;
RadGrid1.DataSource = dt;
RadGrid1.DataBind();
}
else
{
RadGrid1.Visible = false;
lblMsg.Visible = true;
}
}
private void GetPresident(int id)
{
PresidentBll obj = new PresidentBll();
obj.Id = id;
DataTable dt = new DataTable();
dt = obj.GetPresidentById();
if (dt.Rows.Count > 0)
{
lblHeading.Text = "Edit Executive Committee's Details";
ddlDistNo.SelectedItem.Text = dt.Rows[0]["district_no"].ToString();
int distNo = int.Parse(dt.Rows[0]["district_no"].ToString());
BindClubByDistId(distNo);
ddlClubName.SelectedItem.Text = dt.Rows[0]["club_name"].ToString();
txtFirstName.Text = dt.Rows[0]["first_name"].ToString();
txtLastName.Text = dt.Rows[0]["last_name"].ToString();
txtEmail.Text = dt.Rows[0]["email"].ToString();
txtMobile.Text = dt.Rows[0]["mobile"].ToString();
//txtPassword.Text = dt.Rows[0]["password"].ToString();
}
}
