private void BindGrid()
{
int distNo = 3141;
DataTable dt = new DataTable();
DBconnection obj = new DBconnection();
//obj.SetCommandSP = "z_GetBodMembersList";
obj.SetCommandSP = "z_GetBodMembersList3141";
obj.AddParam("@district_no", distNo);
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
lblMsg.Visible = false;
RadGrid1.Visible = true;
RadGrid1.DataSource = dt;
RadGrid1.Rebind();
}
else
{
lblMsg.Visible = true;
lblMsg.Text = "No records to display.";
RadGrid1.Visible = false;
}
}
protected void btnSendLoginPass_Click(object sender, EventArgs e)
{
int pid = 0;
string email, Pass = "";
foreach (GridDataItem item in RadGrid1.MasterTableView.Items)
{
try
{
CheckBox chkbox = (CheckBox)item.FindControl("chkActive");
Label lblcid = (Label)item.FindControl("lblcid");
Label lblEmail = (Label)item.FindControl("lblEmail");
if (chkbox.Checked)
{
pid = Int32.Parse(lblcid.Text.ToString());
email = lblEmail.Text.ToString();
if (email != "")
{
try
{
DBconnection con = new DBconnection();
con.SetCommandQry = "select password from View_BodMembers where EmailId='" + email + "' and MemType='Active' order by Name";
DataTable dt = con.ExecuteTable();
Pass = dt.Rows[0]["password"].ToString();
SendMailtoClient(email, Pass);
}
catch { }
}
}
chkbox.Checked = false;
}
catch { }
}
}
private void BindGrid(string clubName, string memberName)
{
DataTable dt = new DataTable();
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_GetMemberwisePositionReport";
obj.AddParam("@club_name", clubName);
obj.AddParam("@MemberName", memberName);
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 SearchGrid(string searchField, string pname)
{
int clubid = int.Parse(DDLClubName.SelectedValue.ToString());
DataTable dt = new DataTable();
DBconnection obj = new DBconnection();
obj.SetCommandQry = "Select ROW_NUMBER () OVER ( ORDER BY years asc ) AS RowNumber,* from roll_of_honour_tbl where DistrictClubID='" + clubid + "' and " + searchField + " like '%'+'" + pname + "'+ '%' ";
//obj.SetCommandQry = "Select ROW_NUMBER () OVER (ORDER BY years asc ) AS RowNumber,* from roll_of_honour_tbl where " + searchField + " like '%'+'" + pname + "'+ '%' ";
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;
lblMsg.Text = "No records to display.";
RadGrid1.Visible = false;
}
}
private void BindGrid(string yrs)
{
DataTable dt = new DataTable();
DBconnection obj = new DBconnection();
obj.SetCommandQry = "SELECT * FROM [View_DistOfficers] where years ='" + yrs + "' order by name";
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
//txtName.Text = "";
lblMsg.Visible = false;
RadGrid1.Visible = true;
RadGrid1.DataSourceID = string.Empty;
RadGrid1.DataSource = dt;
RadGrid1.Rebind();
}
else
{
lblMsg.Visible = true;
RadGrid1.Visible = false;
}
}
private void BindGrid()
{
DataTable dt = new DataTable();
DBconnection obj = new DBconnection();
obj.SetCommandQry = "SELECT * FROM [join_rotary_tbl] order by added_date desc";
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
lblMsg.Visible = false;
btnExporttoExcel.Visible = true;
RadGrid1.Visible = true;
RadGrid1.DataSourceID = string.Empty;
RadGrid1.DataSource = dt;
RadGrid1.DataBind();
}
else
{
lblMsg.Visible = true;
//rbtnType.Visible = false;
btnExporttoExcel.Visible = false;
RadGrid1.Visible = false;
}
}
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_SearchByAlphabetEventRegistration";
obj.AddParam("@name", name);
obj.AddParam("@event_id", int.Parse(DDLEventName.SelectedValue.ToString()));
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 SearchGrid(string searchField, string pname)
{
DataTable dt = new DataTable();
DBconnection obj = new DBconnection();
obj.SetCommandQry = "SELECT * FROM [View_DistOfficers] where " + searchField + " like '%'+'" + pname + "'+ '%' ";
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
//txtName.Text = "";
lblMsg.Visible = false;
RadGrid1.Visible = true;
RadGrid1.DataSourceID = string.Empty;
RadGrid1.DataSource = dt;
RadGrid1.Rebind();
}
else
{
lblMsg.Visible = true;
RadGrid1.Visible = false;
}
}
private void SearchByAlphabet(string name)
{
Session["searchYear"] = null;
Session["searchField"] = null;
Session["name"] = null;
Session["value"] = null;
rbtnSearch.SelectedIndex = 0;
txtName.Visible = true;
ddlSearchYear.SelectedIndex = 0;
ddlSearchYear.Visible = false;
Session["name"] = name;
DataTable dt = new DataTable();
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_SearchByAlphabetBod";
obj.AddParam("@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;
lblMsg.Text = "No records to display.";
RadGrid1.Visible = false;
}
}
private void GetEclubs(int id)
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_GetEclubs";
obj.AddParam("@id", id);
DataTable dt = new DataTable();
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
DDLDay.SelectedItem.Text = dt.Rows[0]["day"].ToString();
string[] time = dt.Rows[0]["time"].ToString().Split(':');
DDLTimeH.SelectedValue = time[0].ToString();
DDLTimeM.SelectedValue = time[1].ToString();
DDLTimeAMPM.SelectedValue = time[2].ToString();
txtClubname.Text = dt.Rows[0]["club_name"].ToString();
txtCountry.Text = dt.Rows[0]["country"].ToString();
txtDistrictNo.Text = dt.Rows[0]["district"].ToString();
txtWebsite.Text = dt.Rows[0]["website"].ToString();
}
}
private void SearchGrid(string searchField, string pname)
{
DataTable dt = new DataTable();
DBconnection obj = new DBconnection();
obj.SetCommandQry = "SELECT ROW_NUMBER () OVER (ORDER BY sub_designation asc) AS RowNumber, * FROM [View_SubDesignations] where " + searchField + " like '%'+'" + pname + "'+ '%' ";
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
//txtName.Text = "";
lblMsg.Visible = false;
RadGrid1.Visible = true;
RadGrid1.DataSourceID = string.Empty;
RadGrid1.DataSource = dt;
RadGrid1.Rebind();
}
else
{
lblMsg.Visible = true;
RadGrid1.Visible = false;
}
}
private void BindGrid(int eventId)
{
DataTable dt = new DataTable();
DBconnection obj = new DBconnection();
obj.SetCommandQry = "Select ROW_NUMBER () OVER (ORDER BY fname asc) AS Sr, fname +' '+lname as Name,* from dist_event_reg_form_tbl where event_id='" + eventId + "'";
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
lblMsg.Visible = false;
btnExporttoExcel.Visible = true;
GridView1.Visible = true;
GridView1.DataSource = dt;
GridView1.DataBind();
}
else
{
lblMsg.Visible = true;
//rbtnType.Visible = false;
btnExporttoExcel.Visible = false;
GridView1.Visible = false;
}
}
private void BindGrid()
{
DataTable dt = new DataTable();
DBconnection obj = new DBconnection();
obj.SetCommandQry = "SELECT * FROM [View_TashkentRegistrations]";
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
lblMsg.Visible = false;
btnExporttoExcel.Visible = true;
RadGrid1.Visible = true;
RadGrid1.DataSourceID = string.Empty;
RadGrid1.DataSource = dt;
RadGrid1.DataBind();
}
else
{
lblMsg.Visible = true;
//rbtnType.Visible = false;
btnExporttoExcel.Visible = false;
RadGrid1.Visible = false;
}
}
private void GetEvents(int eid)
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "sp_GetSpeakerEvents";
obj.AddParam("@event_id", eid);
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]["DistrictClubID"].ToString();
string se = dt.Rows[0]["speaker_events"].ToString();
if (se == "Speaker")
{
TREvents.Visible = false;
TRSpeaker.Visible = true;
TRTopics.Visible = true;
rbtnSpeaEvents.Items[0].Selected = true;
txtspeaker.Text = dt.Rows[0]["name"].ToString();
}
else
{
TREvents.Visible = true;
TRSpeaker.Visible = false;
TRTopics.Visible = false;
rbtnSpeaEvents.Items[1].Selected = true;
txtevents.Text = dt.Rows[0]["event_name"].ToString();
}
string event_type = dt.Rows[0]["event_type"].ToString();
if (event_type == "Club")
{
rbtnEventType.SelectedIndex = 0;
}
if (event_type == "District")
{
rbtnEventType.SelectedIndex = 1;
}
txttopics.Text = dt.Rows[0]["topics"].ToString();
string venue_type = dt.Rows[0]["venue_type"].ToString();
try
{
if (venue_type == "Regular")
{
rbtnvenue.SelectedIndex = 0;
}
else
{
rbtnvenue.SelectedIndex = 1;
}
}
catch { }
txtvenue.Text = dt.Rows[0]["venue"].ToString();
RadDatePicker1.SelectedDate = DateTime.Parse(dt.Rows[0]["date"].ToString());
string[] time = dt.Rows[0]["time"].ToString().Split(':');
if (dt.Rows[0]["time"] != "")
{
DDLTimeH.Text = time[0].ToString();
string ss = time[1].ToString();
string[] sss = ss.Split(' ');
DDLTimeM.SelectedValue = sss[0].ToString();
DDLTime.SelectedValue = sss[1].ToString();
}
string avenue = dt.Rows[0]["avenue"].ToString();
if (avenue != "")
{
DDLAvenueCovered.SelectedItem.Text = avenue;
}
else
{
DDLAvenueCovered.SelectedItem.Text = "Select";
}
string guestAllowed = dt.Rows[0]["guest_allowed"].ToString();
if (guestAllowed == "No")
{
rbtnGuestAll.SelectedIndex = 0;
TRGuestCharge.Visible = false;
}
if (guestAllowed == "Yes")
{
TRGuestCharge.Visible = true;
rbtnGuestAll.SelectedIndex = 1;
txtCost.Text = dt.Rows[0]["guest_charges"].ToString();
}
string dressCode = dt.Rows[0]["dress_code"].ToString();
if (dressCode == "Formals")
{
rbtnDress.SelectedIndex = 0;
}
if (dressCode == "Smart Casuals")
{
rbtnDress.SelectedIndex = 1;
}
if (dressCode == "Ethnic")
{
rbtnDress.SelectedIndex = 2;
}
txtdescription.Text = dt.Rows[0]["description"].ToString();
}
}
protected void cvisvaliduser_ServerValidate(object source, ServerValidateEventArgs args)
{
MailMessage mail = new MailMessage();
try
{
DBconnection con = new DBconnection();
con.SetCommandSP = "Sp_ForgotPasswordAdmin";
con.AddParam("@username", txtuname.Text.Trim());
con.AddParam("@emailid", txtemail.Text.Trim());
DataTable dt = new DataTable();
dt = con.ExecuteTable();
if (dt.Rows.Count > 0)
{
string pass = dt.Rows[0]["Password"].ToString();
args.IsValid = true;
try
{
mail.IsBodyHtml = true;
string email = txtemail.Text;
mail.To.Add(email);
mail.From = new MailAddress("*****@*****.**");
mail.Subject = "RI Dist.3141 Administration Password Recovery";
string msg = "<p>Dear User,</p><p>Your Login Information is: </p>";
msg += "<p> Username: "******"<br />";
msg += "</n> Password: "******"<br />";
msg += "<p>Kindly keep the above information securely to prevent misuse.</p><p>Thanking You,<br />Admin Team <br />RI Dist.3141</p>";
mail.Body = msg;
//SmtpClient emailClient = new SmtpClient();
//emailClient.Credentials = new NetworkCredential("*****@*****.**", "omshanti2012");
//emailClient.Port = 587;
//emailClient.Host = "smtp.gmail.com";
//emailClient.EnableSsl = true;
//emailClient.Send(mail);
SmtpClient emailClient = new SmtpClient();
emailClient.Credentials = new NetworkCredential("*****@*****.**", "G#5x7hR$9");
emailClient.Port = 25;
emailClient.Host = "mail.rotarydist3141.com";
emailClient.EnableSsl = false;
emailClient.Send(mail);
//lblmsg.Text = "Your Password has been sent to your emailid .";
showmsg("Your Password has been sent to your email-id .");
}
catch (Exception exp)
{
lblmsg.Text = "Error : " + exp.Message;
lblmsg.Visible = true;
}
}
else
{
args.IsValid = false;
}
}
catch { args.IsValid = false; }
}
private void GetForm(int id)
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_GetRegistration";
obj.AddParam("@id", id);
DataTable dt = new DataTable();
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
string strRegDt = "";
string strUtrDt = "";
string strChequeDt = "";
string strCategory = dt.Rows[0]["category"].ToString();
try
{
strRegDt = dt.Rows[0]["registration_date"].ToString();
}
catch { }
string strScheemCat = "";
try
{
Decimal regSingleFees, regSpouseFees, regCoupleFees = 0;
DBconnection cmd = new DBconnection();
cmd.SetCommandSP = "z_GetRegistrationFeesAdmin";
cmd.AddParam("@member_type", strCategory);
cmd.AddParam("@reg_date", DateTime.Parse(strRegDt));
DataTable dt1 = new DataTable();
dt1 = cmd.ExecuteTable();
if (dt1.Rows.Count > 0)
{
strScheemCat = dt1.Rows[0]["category"].ToString();
}
}
catch { }
string strRegNo = dt.Rows[0]["booking_id"].ToString();
string strClubname = dt.Rows[0]["club_name"].ToString();
string strRegFor = dt.Rows[0]["registration_for"].ToString();
string strDistNo = dt.Rows[0]["district_no"].ToString();
string strRegType = dt.Rows[0]["registration_type"].ToString();
string strName = dt.Rows[0]["fname"].ToString() + " " + dt.Rows[0]["lname"].ToString();
string strBadgename = dt.Rows[0]["badge_name"].ToString();
string strEmail = dt.Rows[0]["emailId"].ToString();
string strIp = dt.Rows[0]["ipaddress"].ToString();
// string strActualAmt = dt.Rows[0]["amount"].ToString();
// string strDiscount = dt.Rows[0]["discount_amount"].ToString();
string strAmt = dt.Rows[0]["applicable_amount"].ToString();
// bank details
string strPaymentType = dt.Rows[0]["payment_type"].ToString();
string strBank = dt.Rows[0]["bank_name"].ToString();
if (strBank == "Select")
{
strBank = "";
}
string strBranch = dt.Rows[0]["branch_name"].ToString();
string strChequeNo = dt.Rows[0]["cheque_no"].ToString();
try
{
strChequeDt = dt.Rows[0]["cheque_date"].ToString();
}
catch { }
string strUtr = dt.Rows[0]["neft_utr_no"].ToString();
try
{
strUtrDt = dt.Rows[0]["neft_utr_date"].ToString();
}
catch { }
string strCardtype = dt.Rows[0]["card_type"].ToString();
string strCardNo = dt.Rows[0]["card_no"].ToString();
string strExMonth = dt.Rows[0]["expiry_month"].ToString();
if (strExMonth == "Month")
{
strExMonth = "";
}
string strExYear = dt.Rows[0]["expiry_year"].ToString();
if (strExYear == "Year")
{
strExYear = "";
}
string strExDate = "";
strExDate = strExMonth + " " + strExYear;
string balanceAmount = dt.Rows[0]["balance_amount"].ToString();
SendMailtoClient(strRegNo, strRegDt, strCategory, strRegFor, strDistNo, strRegType, strName, strBadgename, strEmail, strPaymentType, strAmt, strIp, strClubname, strBank, strBranch,
strChequeNo, strChequeDt, strUtr, strUtrDt, strScheemCat, strCardtype, strCardNo, strExDate, balanceAmount);
}
}
private void GetProfile(int id)
{
try
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_GetMemberDetails";
obj.AddParam("@MemberId", id);
DataTable dt = new DataTable();
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
lblClubName.Text = dt.Rows[0]["club_name"].ToString();
lblClubNo.Text = dt.Rows[0]["ri_club_No"].ToString();
DateTime chrterdate = DateTime.Parse(dt.Rows[0]["charter_date"].ToString());
lblCharterDate.Text = chrterdate.ToString("dd-MMMM-yyyy");
lblMeetingDay.Text = dt.Rows[0]["meeting_day"].ToString();
lblMeetingTime.Text = dt.Rows[0]["meeting_time"].ToString();
lblVenue.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 = "";
}
// Members Details
lblCharterMember.Text = dt.Rows[0]["CharterMember"].ToString();
lblName.Text = dt.Rows[0]["Title"].ToString() + " " + dt.Rows[0]["FName"].ToString() + " " + dt.Rows[0]["MName"].ToString() + " " + dt.Rows[0]["LName"].ToString();// +" " + dt.Rows[0]["Suffix"].ToString();
lblCallName.Text = dt.Rows[0]["CallName"].ToString();
lblHobbies.Text = dt.Rows[0]["Hobbies"].ToString();
lblFood.Text = dt.Rows[0]["FoodPreference"].ToString();
lblDrink.Text = dt.Rows[0]["DrinkPreference"].ToString();
lblMembershipNo.Text = dt.Rows[0]["MembershipNo"].ToString();
lblMembershipType.Text = dt.Rows[0]["MemType"].ToString();
lblGender.Text = dt.Rows[0]["Gender"].ToString();
lblClassification.Text = dt.Rows[0]["Classification"].ToString();
lblQualification.Text = dt.Rows[0]["Qualification"].ToString();
lblEmail.Text = dt.Rows[0]["EmailId"].ToString();
//lblAltEmail.Text = dt.Rows[0]["AltEmailId"].ToString();
string strAltEmailId = dt.Rows[0]["AltEmailId"].ToString();
if (strAltEmailId != "")
lblEmail.Text = dt.Rows[0]["EmailId"].ToString() + " / " + strAltEmailId;
lblmob1.Text = dt.Rows[0]["Mobile1"].ToString();
string strMobile2 = dt.Rows[0]["Mobile2"].ToString();
if (strMobile2 != "")
lblmob1.Text = dt.Rows[0]["Mobile1"].ToString() + " / " + strMobile2;
//lblMob2.Text = dt.Rows[0]["Mobile2"].ToString();
try
{
DateTime m_dob = DateTime.Parse(dt.Rows[0]["DOB"].ToString());
lblDOB.Text = m_dob.ToString("dd MMMM");
}
catch { }
try
{
lblTRF.Text = dt.Rows[0]["TrfAmt"].ToString();
lblTrfStatus.Text = dt.Rows[0]["TRF"].ToString();
}
catch { }
try
{
DateTime dtt = DateTime.Parse(dt.Rows[0]["DOJ"].ToString());
if (dtt.Year == 1900 && dtt.Month == 1 && dtt.Day == 1)
{
lblDOJ.Text = "";
}
else
{
lblDOJ.Text = dtt.ToString("dd MMMM, yyyy");
}
}
catch { }
lblProposed.Text = "Rtn. " + dt.Rows[0]["ProposedBy"].ToString();
string mornigTime = dt.Rows[0]["MorningBTTC"].ToString();
string noonTime = dt.Rows[0]["NoonBTTC"].ToString();
string eveningTime = dt.Rows[0]["EveningBTTC"].ToString();
string bg = dt.Rows[0]["BG"].ToString().Trim();
if (bg == "Select")
{
lblBG.Text = "";
}
else
{
lblBG.Text = bg + " " + dt.Rows[0]["RHF"].ToString();
}
// Spouse Details
lblSHobbies.Text = dt.Rows[0]["SHobbies"].ToString();
lblSFood.Text = dt.Rows[0]["SFoodPreference"].ToString();
lblSDrink.Text = dt.Rows[0]["SDrinkPreference"].ToString();
lblSpouseName.Text = dt.Rows[0]["SName"].ToString();
try
{
DateTime s_dob = DateTime.Parse(dt.Rows[0]["SDOB"].ToString());
lblSDOB.Text = s_dob.ToString("dd MMMM");
}
catch { }
try
{
DateTime anni = DateTime.Parse(dt.Rows[0]["Anniversary"].ToString());
lblAnni.Text = anni.ToString("dd MMMM");
}
catch { }
lblSMob.Text = dt.Rows[0]["SMobile"].ToString();
lblSEmail.Text = dt.Rows[0]["SEmailId"].ToString();
string sbg = dt.Rows[0]["SBG"].ToString().Trim();
if (sbg == "Select")
{
lblSBG.Text = "";
}
else
{
lblSBG.Text = sbg + " " + dt.Rows[0]["SRHF"].ToString();
}
//Address
lblAddress.Text = dt.Rows[0]["RAdd1"].ToString() + " <br/>" + dt.Rows[0]["RAdd2"].ToString();
lblCity.Text = dt.Rows[0]["RCity"].ToString();
lblPhone1.Text = dt.Rows[0]["RPhoneCc1"].ToString() + " " + dt.Rows[0]["RPhoneAc1"].ToString() + " " + dt.Rows[0]["RPhone1"].ToString();
lblPhone2.Text = dt.Rows[0]["RPhoneCc2"].ToString() + " " + dt.Rows[0]["RPhoneAc2"].ToString() + " " + dt.Rows[0]["RPhone2"].ToString();
lblFax.Text = dt.Rows[0]["RFaxCc"].ToString() + " " + dt.Rows[0]["RFaxAc"].ToString() + " " + dt.Rows[0]["RFax"].ToString();
lblPin.Text = dt.Rows[0]["RPin"].ToString();
lblState.Text = dt.Rows[0]["RState"].ToString();
lblCountry.Text = dt.Rows[0]["RCountry"].ToString();
// Compnay Address
lblCompany.Text = dt.Rows[0]["CompanyName"].ToString();
lblCompDesig.Text = dt.Rows[0]["CompanyDesignation"].ToString();
lblCompAdd.Text = dt.Rows[0]["OAdd1"].ToString() + " <br />" + dt.Rows[0]["OAdd2"].ToString();
lblCompCity.Text = dt.Rows[0]["OCity"].ToString();
lblCompPin.Text = dt.Rows[0]["OPin"].ToString();
lblCompPhone1.Text = dt.Rows[0]["OPhoneCc1"].ToString() + " " + dt.Rows[0]["OPhoneAc1"].ToString() + " " + dt.Rows[0]["OPhone1"].ToString();
lblCompPhone2.Text = dt.Rows[0]["OPhoneCc2"].ToString() + " " + dt.Rows[0]["OPhoneAc2"].ToString() + " " + dt.Rows[0]["OPhone2"].ToString();
lblCompFax.Text = dt.Rows[0]["OFaxCc"].ToString() + " " + dt.Rows[0]["OFaxAc"].ToString() + " " + dt.Rows[0]["OFax"].ToString();
lblCompEmail.Text = dt.Rows[0]["OMail"].ToString();
lblCompState.Text = dt.Rows[0]["OState"].ToString();
lblCompCountry.Text = dt.Rows[0]["OCountry"].ToString();
string website = dt.Rows[0]["Website"].ToString();
if (website == "http://www.")
{
lblWebsite.Text = "";
}
else
{
lblWebsite.Text = website;
}
// Childrens Details
lblChildName1.Text = dt.Rows[0]["C1Name"].ToString();
lblChildGender1.Text = dt.Rows[0]["GenderC1"].ToString();
try
{
DateTime c1 = DateTime.Parse(dt.Rows[0]["C1DOB_D"].ToString());
lblChildDOB1.Text = c1.ToString("dd-MMMM-yyyy");
}
catch { }
lblChildName2.Text = dt.Rows[0]["C2Name"].ToString();
lblChildGender2.Text = dt.Rows[0]["GenderC2"].ToString();
try
{
DateTime c2 = DateTime.Parse(dt.Rows[0]["C2DOB_D"].ToString());
lblChildDOB2.Text = c2.ToString("dd-MMMM-yyyy");
}
catch { }
lblChildName3.Text = dt.Rows[0]["C3Name"].ToString();
lblChildGender3.Text = dt.Rows[0]["GenderC3"].ToString();
try
{
DateTime c3 = DateTime.Parse(dt.Rows[0]["C3DOB_D"].ToString());
lblChildDOB3.Text = c3.ToString("dd-MMMM-yyyy");
}
catch { }
// Communication Prefrence
lblMailRef.Text = dt.Rows[0]["AddressPreference"].ToString();
lblFaxRef.Text = dt.Rows[0]["FaxPreference"].ToString();
lblEmailRef.Text = dt.Rows[0]["MailPreference"].ToString();
string strImg = dt.Rows[0]["MemberImage"].ToString();
if (strImg != "")
{
Session["Image"] = strImg;
MemImage.Visible = true;
MemImage.ImageUrl = "../MemberImages/" + strImg;
}
string strSImg = dt.Rows[0]["SImage"].ToString();
if (strSImg != "")
{
Session["SImage"] = strSImg;
SpouseImage.Visible = true;
SpouseImage.ImageUrl = "../MemberImages/" + strSImg;
}
}
}
catch { }
}
private void GetEvents(int id)
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_Get_upcoming_events";
obj.AddParam("@id", id);
DataTable dt = new DataTable();
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
string year = dt.Rows[0]["year"].ToString();
if (year == "2016 - 2017")
{
rbtnYear.SelectedIndex = 0;
}
if (year == "2017 - 2018")
{
rbtnYear.SelectedIndex = 1;
}
if (year == "2018 - 2019")
{
rbtnYear.SelectedIndex = 2;
}
txtEventName.Text = dt.Rows[0]["event_name"].ToString();
eventDate.SelectedDate = DateTime.Parse(dt.Rows[0]["event_date"].ToString());
try
{
eventTime.SelectedDate = DateTime.Parse(dt.Rows[0]["event_time"].ToString());
}
catch { }
txtVenue1.Text = dt.Rows[0]["venue1"].ToString();
txtVenue2.Text = dt.Rows[0]["venue2"].ToString();
txtVenue3.Text = dt.Rows[0]["venue3"].ToString();
txtEventDesc.Content = dt.Rows[0]["event_description"].ToString();
rbtnDressCode.SelectedItem.Text = dt.Rows[0]["dress_code"].ToString();
txtGPSLati.Text = dt.Rows[0]["gps_latitude"].ToString();
txtGPSLongi.Text = dt.Rows[0]["gps_longitude"].ToString();
string map = dt.Rows[0]["direction_map"].ToString();
if (map != "")
{
Session["DirectionMap"] = map;
mapImg.Visible = true;
mapImg.ImageUrl = "../EventImages/" + map;
}
string img = dt.Rows[0]["image"].ToString();
if (img != "")
{
Session["EventImage"] = img;
eventImg.Visible = true;
eventImg.ImageUrl = "../EventImages/" + img;
}
// Registration
string regFacility = dt.Rows[0]["registration_facility"].ToString();
if (regFacility == "Yes")
{
trRegister.Visible = true;
rbtnRegister.SelectedIndex = 1;
}
else
{
trRegister.Visible = false;
rbtnRegister.SelectedIndex = 0;
}
string regCharges = dt.Rows[0]["registration_charges"].ToString();
if (regCharges == "Yes")
{
RegistrationPanel.Visible = true;
rbtnRegCharge.SelectedIndex = 1;
}
else
{
RegistrationPanel.Visible = false;
rbtnRegCharge.SelectedIndex = 0;
}
// Lead Host Details
txtLeadHostAmt.Text = dt.Rows[0]["lead_host_amt"].ToString();
string[] leadHostClubs = dt.Rows[0]["lead_host_club"].ToString().Split(',');
if (dt.Rows[0]["lead_host_club"].ToString() != null)
{
trLeadHost.Visible = true;
for (int i = 0; i <= leadHostClubs.Length - 1; i++)
{
listHostLubs.Items.Add(leadHostClubs[i]);
}
}
else
{
trLeadHost.Visible = false;
}
// Co-host-I
txtCoHost1Amt.Text = dt.Rows[0]["co_host1_amt"].ToString();
txtCoHost1Title.Text = dt.Rows[0]["co_host1_title"].ToString();
string[] coHost1Clubs = dt.Rows[0]["co_host1_clubs"].ToString().Split(',');
if (dt.Rows[0]["co_host1_clubs"].ToString() != null)
{
trCoHost1.Visible = true;
for (int i = 0; i <= coHost1Clubs.Length - 1; i++)
{
listCoHost1.Items.Add(coHost1Clubs[i]);
}
}
else
{
trCoHost1.Visible = false;
}
// Co-Host-II
txtCoHost2Amt.Text = dt.Rows[0]["co_host2_amt"].ToString();
txtCoHost2Title.Text = dt.Rows[0]["co_host2_title"].ToString();
string[] coHost2Clubs = dt.Rows[0]["co_host2_clubs"].ToString().Split(',');
if (dt.Rows[0]["co_host2_clubs"].ToString() != null)
{
trCoHost2.Visible = true;
for (int i = 0; i <= coHost2Clubs.Length - 1; i++)
{
listCoHost2.Items.Add(coHost2Clubs[i]);
}
}
else
{
trCoHost2.Visible = false;
}
// Co-Host-III
txtCoHost3Amt.Text = dt.Rows[0]["co_host3_amt"].ToString();
txtCoHost3Title.Text = dt.Rows[0]["co_host3_title"].ToString();
string[] coHost3Clubs = dt.Rows[0]["co_host3_clubs"].ToString().Split(',');
if (dt.Rows[0]["co_host3_clubs"].ToString() != null)
{
trCoHost3.Visible = true;
for (int i = 0; i <= coHost3Clubs.Length - 1; i++)
{
listCoHost3.Items.Add(coHost3Clubs[i]);
}
}
else
{
trCoHost3.Visible = false;
}
// Committee-Host Members
txtCommitteeHostAmt.Text = dt.Rows[0]["committee_host_amt"].ToString();
string[] committeeHostMembers = dt.Rows[0]["committee_host_members"].ToString().Split(',');
if (dt.Rows[0]["committee_host_members"].ToString() != null)
{
trCommitteeHost.Visible = true;
for (int i = 0; i <= committeeHostMembers.Length - 1; i++)
{
listCommitteeOfHosts.Items.Add(committeeHostMembers[i]);
}
}
else
{
trCommitteeHost.Visible = false;
}
// Registration Charges
txtCost1.Text = dt.Rows[0]["cost1"].ToString();
txtCost2.Text = dt.Rows[0]["cost2"].ToString();
txtCost3.Text = dt.Rows[0]["cost3"].ToString();
try
{
dateFC1.DbSelectedDate = DateTime.Parse(dt.Rows[0]["dateFC1"].ToString());
}
catch { }
try
{
dateFC2.DbSelectedDate = DateTime.Parse(dt.Rows[0]["dateFC2"].ToString());
}
catch { }
try
{
dateFC3.DbSelectedDate = DateTime.Parse(dt.Rows[0]["dateFC3"].ToString());
}
catch { }
try
{
dateTC1.DbSelectedDate = DateTime.Parse(dt.Rows[0]["dateFT1"].ToString());
}
catch { }
try
{
dateTC2.DbSelectedDate = DateTime.Parse(dt.Rows[0]["dateFT2"].ToString());
}
catch { }
try
{
dateTC3.DbSelectedDate = DateTime.Parse(dt.Rows[0]["dateFT3"].ToString());
}
catch { }
txtAccountName.Text = dt.Rows[0]["account_details"].ToString();
txtPayAddress.Content = dt.Rows[0]["send_payment_address"].ToString();
}
}
protected void btnSendDistrictDirectoryData_Click(object sender, EventArgs e)
{
int clubId = 0;
string email = "-";
string clubName = "-";
string clubNo = "-";
string charterDate = "-";
string mettingDay = "-";
string strMeetingTime = "-";
string venue = "-";
string ds = "-";
string at = "-";
string ag = "-";
string flagshipText = "-";
string strFlagship = "";
int members = 0;
int womenMembers = 0;
int iw, rotract, interact, srCitizen, rcc = 0;
foreach (GridDataItem item in RadGrid1.MasterTableView.Items)
{
try
{
CheckBox chkbox = (CheckBox)item.FindControl("chkActive");
Label lblClubId = (Label)item.FindControl("lblClubId");
Label lblEmail = (Label)item.FindControl("lblEmail");
if (chkbox.Checked)
{
clubId = Int32.Parse(lblClubId.Text.ToString());
//GetClubDetails(clubId);
iw = GetIw(clubId);
rotract = GetRotaract(clubId);
interact = GetInteract(clubId);
srCitizen = GetSrCitizen(clubId);
rcc = GetRcc(clubId);
//GetBodDetails(clubId);
BindGridview(clubId);
BindPresident(clubId);
BindSecretary(clubId);
DataTable dt = new DataTable();
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_GetMaleFemaleMembersByClubId";
obj.AddParam("@club_id", clubId);
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
members = int.Parse(dt.Rows[0]["Total"].ToString());
womenMembers = int.Parse(dt.Rows[0]["WomenMembers"].ToString());
}
try
{
DistrictClub obj1 = new DistrictClub();
obj1.Id = clubId;
DataTable dt1 = new DataTable();
dt1 = obj1.GetClubById();
if (dt1.Rows.Count > 0)
{
// Club Details
clubName = dt1.Rows[0]["club_name"].ToString();
clubNo = dt1.Rows[0]["ri_club_No"].ToString();
DateTime chrterdate = DateTime.Parse(dt1.Rows[0]["charter_date"].ToString());
charterDate = chrterdate.ToString("dd-MMMM-yyyy");
mettingDay = dt1.Rows[0]["meeting_day"].ToString();
try
{
DateTime meetingTime = DateTime.Parse(dt1.Rows[0]["meeting_time"].ToString());
strMeetingTime = meetingTime.ToString("hh:mm tt");
}
catch
{
strMeetingTime = "-";
}
venue = dt1.Rows[0]["venue1"].ToString() + " " + dt1.Rows[0]["venue2"].ToString() + " " + dt1.Rows[0]["city"].ToString();
ds = dt1.Rows[0]["ds"].ToString();
at = dt1.Rows[0]["at"].ToString();
ag = dt1.Rows[0]["ag"].ToString();
flagshipText = dt1.Rows[0]["flagship_text"].ToString();
strFlagship = dt1.Rows[0]["flagship_image"].ToString();
//if (strFlagship != "")
//{
// imgFlagship.Visible = true;
// imgFlagship.ImageUrl = "../ClubsLogo/" + strFlagship;
//}
//else
//{
// imgFlagship.Visible = false;
//}
}
}
catch { }
email = lblEmail.Text.ToString();
if (email != "")
{
try
{
SendMailtoDistDirectory(email, clubId, clubName, clubNo, charterDate, members, womenMembers, iw, rotract, interact, srCitizen, rcc, venue, mettingDay, strMeetingTime, ds, at, ag, flagshipText, strFlagship);
}
catch { }
}
}
chkbox.Checked = false;
}
catch { }
}
}
private void GetSpeaker(int id)
{
try
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_GetSpeakers";
obj.AddParam("@id", id);
DataTable dt = new DataTable();
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
drtitle.SelectedItem.Text = dt.Rows[0]["Title"].ToString();
txtfname.Text = dt.Rows[0]["fname"].ToString();
txtmname.Text = dt.Rows[0]["mname"].ToString();
txtlname.Text = dt.Rows[0]["lname"].ToString();
string type = dt.Rows[0]["type"].ToString();
if (type == "Rotarians")
{
TRClubname.Visible = true;
rbtnRtnType.SelectedIndex = 0;
DDLClubName.SelectedItem.Text = dt.Rows[0]["club_name"].ToString();
}
else
{
TRClubname.Visible = false;
rbtnRtnType.SelectedIndex = 1;
}
string topicType = dt.Rows[0]["topic_type"].ToString();
if (topicType == "Rotary")
{
rbtnTopicType.SelectedIndex = 0;
}
else
{
rbtnTopicType.SelectedIndex = 1;
}
string [] topics = dt.Rows[0]["topics"].ToString().Split(';');
for (int i = 0; i <= topics.Length - 1; i++)
{
TRTopics.Visible = true;
listTopics.Items.Add(topics[i]);
}
//txttopics.Text = dt.Rows[0]["topics"].ToString();
txtAdd1.Text = dt.Rows[0]["address1"].ToString();
txtAdd2.Text = dt.Rows[0]["address2"].ToString();
txtAdd3.Text = dt.Rows[0]["address3"].ToString();
txtCity.Text = dt.Rows[0]["city"].ToString();
txtPin.Text = dt.Rows[0]["pin"].ToString();
string[] rph1 = dt.Rows[0]["phone_resi"].ToString().Split('-');
try
{
txtRPhCC1.Text = rph1[0];
txtRPhAC1.Text = rph1[1];
txtRPh1.Text = rph1[2];
}
catch
{
txtRPhCC1.Text = "";
txtRPhAC1.Text = "";
txtRPh1.Text = "";
}
string[] rphoff = dt.Rows[0]["phone_off"].ToString().Split('-');
try
{
txtOPhCC1.Text = rphoff[0];
txtOPhAC1.Text = rphoff[1];
txtOPh1.Text = rphoff[2];
}
catch
{
txtOPhCC1.Text = "";
txtOPhAC1.Text = "";
txtOPh1.Text = "";
}
string[] mob1 = dt.Rows[0]["mobile"].ToString().Split(' ');
try
{
txtmob1cc.Text = mob1[0];
txtmob1.Text = mob1[1];
}
catch
{
}
txtEmailId.Text = dt.Rows[0]["emailid"].ToString();
txtWebsite.Text = dt.Rows[0]["website"].ToString();
}
}
catch
{
}
}
