public void BindStyle()
{
StoreFrontUser ObjReg = new StoreFrontUser();
DataSet ds = new DataSet();
ds = ObjReg.GetStyleFront();
if (ds.Tables[0].Rows.Count > 0)
{
ListItem lst1 = new ListItem();
lst1.Value = "0"; lst1.Text = "Select One";
ddlStyle1.DataTextField = "StyleName";
ddlStyle1.DataValueField = "StyleID";
ddlStyle1.DataSource = ds.Tables[0];
ddlStyle1.DataBind();
ddlStyle1.Items.Insert(0, lst1);
}
if (ds.Tables[1].Rows.Count > 0)
{
lstAddservices1.DataTextField = "ServiceName";
lstAddservices1.DataValueField = "AdditionalServiceID";
lstAddservices1.DataSource = ds.Tables[1];
lstAddservices1.DataBind();
}
}
/* This region use to bind all data breed releated */
public void GetBreed1(string PetType)
{
try
{
StoreFrontUser ObjReg = new StoreFrontUser();
DataSet ds = new DataSet();
ds = ObjReg.GetBreedFront(PetType);
ListItem lst = new ListItem();
lst.Selected = true; lst.Value = "0"; lst.Text = "Select One";
if (ds.Tables[0].Rows.Count > 0)
{
ddlBreed1.DataTextField = "BreedName";
ddlBreed1.DataValueField = "BreedID";
ddlBreed1.DataSource = ds.Tables[0];
ddlBreed1.DataBind();
ddlBreed1.Items.Insert(0, lst);
}
else
{
ddlBreed1.Items.Insert(0, lst);
}
}
catch (Exception ex) { throw ex; }
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
StoreFrontUser ObjStore = new StoreFrontUser();
int Count = ObjStore.UpdateMember(int.Parse(Request.QueryString["Id"].ToString()), txtFirstName.Text.Trim(), txtLastName.Text.Trim(), txtStreet.Text.Trim(), txtCity.Text.Trim(), ddlState.SelectedItem.Text, txtZip.Text.Trim(), txtPhone.Text.Trim(), txtAltMobile.Text.Trim(), txtAltContact.Text.Trim(), txtAltStreet.Text.Trim(), txtCity.Text.Trim(), ddlState1.SelectedItem.Text, txtAltZip.Text.Trim(), txtAltPhone.Text.Trim(), int.Parse(ddlReferralSource.SelectedValue), txtGroomer.Text.Trim(), txtEmailReg.Text.Trim(), txtPasswordReg.Text.Trim());
if (Count == 0)
{
ErrorMessage("Sorry this mail Id already exists.");
}
else
{
SuccessMessage("User information updated successfully.");
}
}
public void GetReferal()
{
StoreFrontUser ObjRef = new StoreFrontUser();
DataSet ds1 = new DataSet();
ds1 = ObjRef.GetReferalSourceFront();
if (ds1.Tables[0].Rows.Count > 0)
{
ddlReferralSource.DataTextField = "ReferalName";
ddlReferralSource.DataValueField = "ReferalID";
ddlReferralSource.DataSource = ds1.Tables[0];
ddlReferralSource.DataBind();
}
}
protected void imgDelete6_Click(object sender, ImageClickEventArgs e)
{
try
{
dvPet6.Visible = false;
if (Convert.ToInt32(PetID6.Text.Trim()) > 0)
{
StoreFrontUser ObjDelPet = new StoreFrontUser();
ObjDelPet.DeletePet(Convert.ToInt32(PetID6.Text.Trim()), GetUpdatedPet(), Convert.ToInt32(Session["UserID"].ToString()));
string Body = "Pet = " + ddlPetType6.SelectedItem.Text + "<br>Pet Name = " + txtPetName6.Text.Trim() + "<br> Breed Name = " + ddlBreed6.SelectedItem.Text +
"<br>Years = " + txtDOB6.Text.Trim() + "<br>Weight = " + txtPetWeight6.Text.Trim() + "<br> Fur Length = " + txtPetLength6.Text.Trim() + "<br><br><br>";
PetDeleteMail(Body);
}
}
catch (Exception ex) { throw ex; }
}
public void BindBreed(string Id)
{
StoreFrontUser ObjReg = new StoreFrontUser();
DataSet ds = new DataSet();
ds = ObjReg.GetBreedFront(Id);
if (ds.Tables[0].Rows.Count > 0)
{
ListItem lst1 = new ListItem();
lst1.Value = "0"; lst1.Text = "Select One";
ddlBreed.DataTextField = "BreedName";
ddlBreed.DataValueField = "BreedID";
ddlBreed.DataSource = ds.Tables[0];
ddlBreed.DataBind();
ddlBreed.Items.Insert(0, lst1);
}
}
public void GetReferal()
{
StoreFrontUser ObjRef = new StoreFrontUser();
DataSet ds1 = new DataSet();
ds1 = ObjRef.GetReferalSourceFront();
if (ds1.Tables[0].Rows.Count > 0)
{
ListItem lst = new ListItem();
lst.Selected = true; lst.Value = "0"; lst.Text = "Select One";
ddlReferralSource.DataTextField = "ReferalName";
ddlReferralSource.DataValueField = "ReferalID";
ddlReferralSource.DataSource = ds1.Tables[0];
ddlReferralSource.DataBind();
ddlReferralSource.Items.Insert(0, lst);
}
}
public string GetAdditionalServices(string Ids)
{
StoreFrontUser ObjReg = new StoreFrontUser();
DataSet ds = new DataSet();
ds = ObjReg.GetStyleFront();
DataTable dt_AdditionalServices = ds.Tables[1];
string[] temp = Ids.Split(',');
string str = string.Empty;
for (int i = 0; i < temp.Length; i++)
{
for (int j = 0; j < dt_AdditionalServices.Rows.Count; j++)
{
if (dt_AdditionalServices.Rows[j]["AdditionalServiceID"].ToString() == temp[i])
{
if (str == "")
{
str = dt_AdditionalServices.Rows[j]["ServiceName"].ToString();
}
else
{
str = str + "," + dt_AdditionalServices.Rows[j]["ServiceName"].ToString();
}
}
}
}
ds.Dispose();
if (str == "")
{
return("Select Service");
}
else
{
return(str);
}
}
protected void ImgAppointment_Click(object sender, ImageClickEventArgs e)
{
if (Session["MemberName"] != null)
{
StoreFrontUser ObjUserCheck = new StoreFrontUser();
DataSet ds = new DataSet();
ds = ObjUserCheck.IsFullProfile(Convert.ToInt32(Session["UserID"].ToString()));
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0][0].ToString() == "1")
{
Response.Redirect("AppointmentNew.aspx");
}
else
{
Response.Redirect("MyAccount.aspx");
}
}
}
else
{
Response.Redirect("Registration_Full.aspx");
}
}
protected void IdSubmit_Click(object sender, EventArgs e)
{
try
{
lblCaptchaError.Visible = false;
lblCaptchaError.Text = "";
StoreFrontUser ObjNewUser = new StoreFrontUser();
int Status = 3;
int Type = CheckPet();
if (Type == 3)
{
Status = CheckStatus();
}
else
{
Status = Type;
}
Session["UserType"] = Status.ToString();
Session["MemberName"] = txtFirstName.Text.Trim() + " " + txtLastName.Text.Trim();
int n = txtPhone.Text.Length;
int UserID = ObjNewUser.AddUserBasic(txtFirstName.Text.Trim(), txtLastName.Text.Trim(), txtStreet.Text.Trim(), txtCity.Text.Trim(), ddlState.SelectedValue, txtZip.Text.Trim(), txtPhone.Text.Trim(), Convert.ToInt32(ddlReferralSource.SelectedValue), txtEmailReg.Text.Trim(), txtPasswordReg.Text.Trim(), Status);
if (UserID != 0)
{
if ((dvPet1.Visible == true) && (txtPetName1.Text.Trim() != "") && (ddlBreed1.SelectedIndex != 0) && (txtPetDOB1.Text.Trim() != "") && (txtPetWeight1.Text.Trim() != "") && (txtPetLength1.Text.Trim() != ""))
{
ObjNewUser.AddPet(UserID, Convert.ToInt32(ddlPetType1.SelectedValue), txtPetName1.Text.Trim(), Convert.ToInt32(ddlBreed1.SelectedValue), Convert.ToInt32(txtPetDOB1.Text.Trim()), Convert.ToDecimal(txtPetWeight1.Text.Trim()), Convert.ToDecimal(txtPetLength1.Text.Trim()));
}
if ((dvPet2.Visible == true) && (txtPetName2.Text.Trim() != "") && (ddlBreed2.SelectedIndex != 0) && (txtDOB2.Text.Trim() != "") && (txtPetWeight2.Text.Trim() != "") && (txtPetLength2.Text.Trim() != ""))
{
ObjNewUser.AddPet(UserID, Convert.ToInt32(ddlPetType2.SelectedValue), txtPetName2.Text.Trim(), Convert.ToInt32(ddlBreed2.SelectedValue), Convert.ToInt32(txtDOB2.Text.Trim()), Convert.ToDecimal(txtPetWeight2.Text.Trim()), Convert.ToDecimal(txtPetLength2.Text.Trim()));
}
if ((dvPet3.Visible == true) && (txtPetName3.Text.Trim() != "") && (ddlBreed3.SelectedIndex != 0) && (txtDOB3.Text.Trim() != "") && (txtPetWeight3.Text.Trim() != "") && (txtPetLength3.Text.Trim() != ""))
{
ObjNewUser.AddPet(UserID, Convert.ToInt32(ddlPetType3.SelectedValue), txtPetName3.Text.Trim(), Convert.ToInt32(ddlBreed3.SelectedValue), Convert.ToInt32(txtDOB3.Text.Trim()), Convert.ToDecimal(txtPetWeight3.Text.Trim()), Convert.ToDecimal(txtPetLength3.Text.Trim()));
}
if ((dvPet4.Visible == true) && (txtPetName4.Text.Trim() != "") && (ddlBreed4.SelectedIndex != 0) && (txtDOB4.Text.Trim() != "") && (txtPetWeight4.Text.Trim() != "") && (txtPetLength4.Text.Trim() != ""))
{
ObjNewUser.AddPet(UserID, Convert.ToInt32(ddlPetType4.SelectedValue), txtPetName4.Text.Trim(), Convert.ToInt32(ddlBreed4.SelectedValue), Convert.ToInt32(txtDOB4.Text.Trim()), Convert.ToDecimal(txtPetWeight4.Text.Trim()), Convert.ToDecimal(txtPetLength4.Text.Trim()));
}
if ((dvPet5.Visible == true) && (txtPetName5.Text.Trim() != "") && (ddlBreed5.SelectedIndex != 0) && (txtDOB5.Text.Trim() != "") && (txtPetWeight5.Text.Trim() != "") && (txtPetLength5.Text.Trim() != ""))
{
ObjNewUser.AddPet(UserID, Convert.ToInt32(ddlPetType5.SelectedValue), txtPetName5.Text.Trim(), Convert.ToInt32(ddlBreed5.SelectedValue), Convert.ToInt32(txtDOB5.Text.Trim()), Convert.ToDecimal(txtPetWeight5.Text.Trim()), Convert.ToDecimal(txtPetLength5.Text.Trim()));
}
if ((dvPet6.Visible == true) && (txtPetName6.Text.Trim() != "") && (ddlBreed6.SelectedIndex != 0) && (txtDOB6.Text.Trim() != "") && (txtPetWeight6.Text.Trim() != "") && (txtPetLength6.Text.Trim() != ""))
{
ObjNewUser.AddPet(UserID, Convert.ToInt32(ddlPetType6.SelectedValue), txtPetName6.Text.Trim(), Convert.ToInt32(ddlBreed6.SelectedValue), Convert.ToInt32(txtDOB6.Text.Trim()), Convert.ToDecimal(txtPetWeight6.Text.Trim()), Convert.ToDecimal(txtPetLength6.Text.Trim()));
}
if ((Request.Cookies["IsLogin"] == null) || (Request.Cookies["IsLogin"].ToString() == "0"))
{
HttpCookie c = new HttpCookie("IsLogin", "1");
c.Expires = new DateTime(2050, 12, 1);
Response.Cookies.Add(c);
}
Session["MemberName"] = txtFirstName.Text.Trim() + " " + txtLastName.Text.Trim();
Session["UserID"] = UserID.ToString();
Session["UserName"] = txtEmailReg.Text.Trim();
Session["UserName"] = txtEmailReg.Text.Trim();
Session["IsLogin"] = "******";
string Name = txtFirstName.Text.Trim() + " " + txtLastName.Text.Trim();
try
{
//send mail to Admin
string Message = ContentManager.GetStaticeContentEmail("RegistrationAdmin.htm").Replace("~", "#");
Message = Message.Replace("<!-- Name -->", Name);
Message = Message.Replace("<!-- Username -->", txtEmailReg.Text.Trim());
MailMessage objMailMsg = new MailMessage(ConfigurationManager.AppSettings["FromEmail"], ConfigurationManager.AppSettings["ToEmail"]);
objMailMsg.BodyEncoding = Encoding.UTF8;
objMailMsg.Subject = "Registration Successfully Completed By " + Name;
objMailMsg.Body = Message;
objMailMsg.Priority = MailPriority.High;
objMailMsg.IsBodyHtml = true;
SmtpClient objSMTPClient = new SmtpClient(ConfigurationManager.AppSettings["SmtpServer"].ToString(), 587);
objSMTPClient.Host = ConfigurationManager.AppSettings["SmtpServer"];
objSMTPClient.EnableSsl = true;
objSMTPClient.Send(objMailMsg);
//send mail to member
Message = ContentManager.GetStaticeContentEmail("Registration.htm").Replace("~", "#");
Message = Message.Replace("<!-- Name -->", Name);
Message = Message.Replace("<!-- Username -->", txtEmailReg.Text.Trim());
objMailMsg = new MailMessage(ConfigurationManager.AppSettings["FromEmail"], txtEmailReg.Text.Trim());
objMailMsg.BodyEncoding = Encoding.UTF8;
objMailMsg.Subject = "Welcome to Fritzy's Club: Registration Successfully Completed";
objMailMsg.Body = Message;
objMailMsg.Priority = MailPriority.High;
objMailMsg.IsBodyHtml = true;
objSMTPClient = new SmtpClient(ConfigurationManager.AppSettings["SmtpServer"].ToString(), 587);
objSMTPClient.Host = ConfigurationManager.AppSettings["SmtpServer"];
objSMTPClient.EnableSsl = true;
objSMTPClient.Send(objMailMsg);
}
catch
{
}
Response.Redirect("~/mobileweb/MB_index.aspx");
}
else
{
lblCaptchaError.Visible = true;
lblCaptchaError.Text = "We’re sorry, this username already exists.";
}
}
catch (Exception ex) { throw ex; }
}
/* Function is use t Import data ti database from excel with */
protected void btnUpload_Click(object sender, EventArgs e)
{
string FirstName, LastName, Street, City, State, Zip, Phone, UserName, Password, AltMobile, AltContact, AltStreet, AltCity, AltState, AltZip, AltPhone, PreferredGroomer;
int UserType;
string Error = string.Empty;
StoreFrontUser ObjNewUser = new StoreFrontUser();
DataSet ds = new DataSet();
string strExtension;
strExtension = Path.GetExtension(flUpload.Value);
if (strExtension == "")
{
ErrorMessage("Please select file to upload");
}
if (strExtension == ".CSV" || strExtension == ".csv")
{
string fileName;
string line;
string fileDir;
StreamReader sr;
fileDir = Server.MapPath("../StoreData/");
fileName = fileDir + "/" + Convert.ToString(DateTime.Now.Ticks) + ".txt";
flUpload.PostedFile.SaveAs(fileName);
sr = File.OpenText(fileName);
int recordCount = 0;
while (sr.Peek() != -1)
{
line = sr.ReadLine();
string[] recordArray;
char[] splitter = { ',' };
recordArray = line.Split(splitter);
if (recordArray[0].Replace(",", "") == "FirstName")
{
continue;
}
else
{
if (recordArray.Length == 18)
{
FirstName = (recordArray[0].Trim().Replace('#', ','));
LastName = (recordArray[1].Trim().Replace('#', ','));
Street = (recordArray[2].Trim().Replace('#', ','));
City = (recordArray[3].Trim().Replace('#', ','));
State = (recordArray[4].Trim().Replace('#', ','));
Zip = (recordArray[5].Trim().Replace('#', ','));
Phone = (recordArray[6].Trim().Replace('#', ','));
UserName = (recordArray[7].Trim().Replace('#', ','));
Password = (recordArray[8].Trim().Replace('#', ','));
AltMobile = (recordArray[9].Trim().Replace('#', ','));
AltContact = (recordArray[10].Trim().Replace('#', ','));
AltStreet = (recordArray[11].Trim().Replace('#', ','));
AltCity = (recordArray[12].Trim().Replace('#', ','));
AltState = (recordArray[13].Trim().Replace('#', ','));
AltZip = (recordArray[14].Trim().Replace('#', ','));
AltPhone = (recordArray[15].Trim().Replace('#', ','));
PreferredGroomer = (recordArray[16].Trim().Replace('#', ','));
if (recordArray[17].Trim().ToLower() == "cat")
{
UserType = 1;
}
else if (recordArray[17].Trim().ToLower() == "dog")
{
UserType = 2;
}
else
{
UserType = 3;
}
int Dup = ObjNewUser.AddUserExcel(FirstName, LastName, Street, City, State, Zip, Phone, UserName, Password, AltMobile, AltContact, AltStreet, AltCity, AltState, AltZip, AltPhone, PreferredGroomer, UserType);
if (Dup == 0)
{
if (Error == "")
{
Error = "Duplicate record - " + UserName;
}
else
{
Error = Error + ", " + UserName;
}
}
recordCount++;
}
else
{
Error = "coloumn count does not match";
}
}
}
if (Error == "")
{
SuccessMessage("Record Added successfully");
}
else
{
ErrorMessage(Error);
}
}
else
{
ErrorMessage("File format does not support. only .csv format allowed.");
}
BindUsers();
}
