void LoadProfile() { objService = new ServeAtDoorstepService(); DataTable dtVen = objService.GetCustomerById(Convert.ToInt32(sLoginId)); if (dtVen.Rows.Count > 0) { spnCusImage.InnerHtml = "<a class='example-image-link' href='image/Vendor.jpg' data-lightbox='example-1'" + "title='Vendor'>" + "<img class='example-image' src='image/Vendor.jpg' alt='Vendor' width='150' height='150' /></a>"; lblLoginName.Text = dtVen.Rows[0]["LoginName"].ToString(); lblEmail.Text = dtVen.Rows[0]["VendorEmail"].ToString(); txtVendorName.Value = dtVen.Rows[0]["VendorName"].ToString(); // txtFirstName.Value = dtCus.Rows[0]["FirstName"].ToString();// +" " + dtCus.Rows[0]["LastName"].ToString(); // txtLastName.Value = dtCus.Rows[0]["LastName"].ToString(); // sLoginname = dtCus.Rows[0]["LoginName"].ToString(); // sPassword = dtCus.Rows[0]["LoginPassword"].ToString(); // sImagePath = dtCus.Rows[0]["ImagePath"].ToString(); // txtEmail.Value = dtCus.Rows[0]["Email"].ToString(); // txtMobile.Value = dtCus.Rows[0]["Mobile"].ToString(); // rdoGender.SelectedValue = dtCus.Rows[0]["Gender"].ToString(); // for (int i = 0; i < ddlCountry.Items.Count; i++) // { // if (ddlCountry.Items[i].Text == dtCus.Rows[0]["CountryName"].ToString()) // ddlCountry.SelectedIndex = i; // } // for (int i = 0; i < ddlState.Items.Count; i++) // { // if (ddlState.Items[i].Text == dtCus.Rows[0]["StateName"].ToString()) // ddlState.SelectedIndex = i; // } // string sState = dtCus.Rows[0]["StateName"].ToString(); // string sStateId = dtCus.Rows[0]["StateId"].ToString(); // DataTable dtCy = objService.SelectCityByStateId(Convert.ToInt32(sStateId)); // ddlCity.Items.Clear(); // ListItem listItem = new ListItem(); // listItem.Text = "<Select City>"; // listItem.Value = "0"; // ddlCity.Items.Add(listItem); // for (int i = 0; i < dtCy.Rows.Count; i++) // { // listItem = new ListItem(); // listItem.Text = dtCy.Rows[i]["CityName"].ToString(); // listItem.Value = dtCy.Rows[i]["CityId"].ToString(); // ddlCity.Items.Add(listItem); // } // for (int i = 0; i < ddlCity.Items.Count; i++) // { // if (ddlCity.Items[i].Text == dtCus.Rows[0]["CityName"].ToString()) // ddlCity.SelectedIndex = i; // } // txtAddress.Value = dtCus.Rows[0]["Address"].ToString(); // txtStreetname.Value = dtCus.Rows[0]["StreetName"].ToString(); // txtZipcode.Value = dtCus.Rows[0]["ZipCode"].ToString(); // sBankId = dtCus.Rows[0]["BankId"].ToString(); // hdnAddress.Value = dtCus.Rows[0]["CityName"].ToString().Trim() + ", " + dtCus.Rows[0]["StateName"].ToString() + ", US"; } }
protected void btnPost_Click(object sender, EventArgs e) { #region .. VALIDATION .. int intError = 0; string strErrorMsg = ""; if (txtQuoteTitle.Value.ToString() == "") { strErrorMsg += " <img src='image/error.jpg' height='40px' width='40px' /> Quiry Title should not be empty. <br/>"; intError++; } if (ddlCategory.SelectedIndex == 0) { strErrorMsg += " <img src='image/error.jpg' height='40px' width='40px' /> Please Select Category. <br/>"; intError++; } if (FileUpload1.PostedFile.ContentLength == 0 || Request.Form["fileName1"] == null) { strErrorMsg += " <img src='image/error.jpg' height='40px' width='40px' /> Please Upload atleast one image. <br/>"; intError++; } if (FileUpload1.PostedFile != null) { if (FileUpload1.PostedFile.ContentLength > (50 * 1024)) { strErrorMsg += " <img src='image/error.jpg' height='40px' width='40px' /> " + FileUpload1.PostedFile.FileName + " Exceeds maximum limit 50 KB. <br/>"; intError++; } } if (FileUpload2.PostedFile != null) { if (FileUpload2.PostedFile.ContentLength > (50 * 1024)) { strErrorMsg += " <img src='image/error.jpg' height='40px' width='40px' /> " + FileUpload2.PostedFile.FileName + " Exceeds maximum limit 50 KB. <br/>"; intError++; } } if (FileUpload3.PostedFile != null) { if (FileUpload3.PostedFile.ContentLength > (50 * 1024)) { strErrorMsg += " <img src='image/error.jpg' height='40px' width='40px' /> " + FileUpload3.PostedFile.FileName + " Exceeds maximum limit 50 KB. <br/>"; intError++; } } if (FileUpload4.PostedFile != null) { if (FileUpload4.PostedFile.ContentLength > (50 * 1024)) { strErrorMsg += " <img src='image/error.jpg' height='40px' width='40px' /> " + FileUpload4.PostedFile.FileName + " Exceeds maximum limit 50 KB. <br/>"; intError++; } } if (FileUpload5.PostedFile != null) { if (FileUpload5.PostedFile.ContentLength > (50 * 1024)) { strErrorMsg += " <img src='image/error.jpg' height='40px' width='40px' /> " + FileUpload5.PostedFile.FileName + " Exceeds maximum limit 50 KB. <br/>"; intError++; } } if (FileUploadVid.PostedFile != null) { if (FileUploadVid.PostedFile.ContentLength > (500 * 1024)) { strErrorMsg += " <img src='image/error.jpg' height='40px' width='40px' /> " + FileUploadVid.PostedFile.FileName + " Exceeds maximum limit 500 KB. <br/>"; intError++; } } #endregion if (intError == 0) { InquiryDetails objQuiry = new InquiryDetails(); objQuiry.InquiryID = 0; objQuiry.InquiryTitle = txtQuoteTitle.Value.ToString(); objQuiry.Description = txtQuoteDesc.Value.ToString(); objQuiry.Keywords = "";// txtQuoteKey.Value.ToString(); objQuiry.CategoryId = Convert.ToInt32(ddlCategory.Value.ToString()); objQuiry.CustomerId = Convert.ToInt32(Session["LoginId"].ToString()); objQuiry.CityId = 0; objQuiry.ImagePath = ""; objQuiry.VideoPath = ""; objService = new ServeAtDoorstepService(); int intQuoId = objService.AddInquiryDetails(objQuiry); #region .. CREATE INQUIRY IMAGE .. string path = string.Empty; string strImgFinalPath = ""; string finalPath = string.Empty; string filePath = string.Empty; int iLoginId = Convert.ToInt32(Session["LoginId"].ToString()); string sFilename = ""; if (FileUpload1.PostedFile != null) { HttpPostedFile myFile = FileUpload1.PostedFile; int nFileLen = myFile.ContentLength; if (nFileLen != 0) { DirectoryInfo dirInfo = null; fileSavePath = "/Data/IQU_" + iLoginId + "_" + intQuoId + "/Images/"; path = Server.MapPath("~" + fileSavePath); if (!Directory.Exists(path)) { dirInfo = Directory.CreateDirectory(path); } sFilename = System.IO.Path.GetFileName(myFile.FileName); path = path + "/" + sFilename; FileUpload1.PostedFile.SaveAs(path); finalPath = Path.Combine(fileSavePath, sFilename); } } strImgFinalPath = finalPath; if (FileUpload2.PostedFile != null) { HttpPostedFile myFile = FileUpload2.PostedFile; int nFileLen = myFile.ContentLength; if (nFileLen != 0) { path = Server.MapPath("~" + fileSavePath); sFilename = System.IO.Path.GetFileName(myFile.FileName); path = path + "/" + sFilename; FileUpload2.PostedFile.SaveAs(path); finalPath = Path.Combine(fileSavePath, sFilename); strImgFinalPath = strImgFinalPath + ":" + finalPath; } } if (FileUpload3.PostedFile != null) { HttpPostedFile myFile = FileUpload3.PostedFile; int nFileLen = myFile.ContentLength; if (nFileLen != 0) { path = Server.MapPath("~" + fileSavePath); sFilename = System.IO.Path.GetFileName(myFile.FileName); path = path + "/" + sFilename; FileUpload3.PostedFile.SaveAs(path); finalPath = Path.Combine(fileSavePath, sFilename); strImgFinalPath = strImgFinalPath + ":" + finalPath; } } if (FileUpload4.PostedFile != null) { HttpPostedFile myFile = FileUpload4.PostedFile; int nFileLen = myFile.ContentLength; if (nFileLen != 0) { path = Server.MapPath("~" + fileSavePath); sFilename = System.IO.Path.GetFileName(myFile.FileName); path = path + "/" + sFilename; FileUpload4.PostedFile.SaveAs(path); finalPath = Path.Combine(fileSavePath, sFilename); strImgFinalPath = strImgFinalPath + ":" + finalPath; } } if (FileUpload5.PostedFile != null) { HttpPostedFile myFile = FileUpload5.PostedFile; int nFileLen = myFile.ContentLength; if (nFileLen != 0) { path = Server.MapPath("~" + fileSavePath); sFilename = System.IO.Path.GetFileName(myFile.FileName); path = path + "/" + sFilename; FileUpload5.PostedFile.SaveAs(path); finalPath = Path.Combine(fileSavePath, sFilename); strImgFinalPath = strImgFinalPath + ":" + finalPath; } } sFilename = ""; finalPath = ""; if (FileUploadVid.PostedFile != null) { HttpPostedFile myFile = FileUploadVid.PostedFile; int nFileLen = myFile.ContentLength; if (nFileLen != 0) { DirectoryInfo dirInfo = null; fileSavePath = "/Data/IQU_" + iLoginId + "_" + intQuoId + "/Video/"; path = Server.MapPath("~" + fileSavePath); if (!Directory.Exists(path)) { dirInfo = Directory.CreateDirectory(path); } sFilename = System.IO.Path.GetFileName(myFile.FileName); path = path + "/" + sFilename; FileUploadVid.PostedFile.SaveAs(path); finalPath = Path.Combine(fileSavePath, sFilename); } } string strVidFinalPath = finalPath; InquiryDetails objIQ = new InquiryDetails(); objIQ.InquiryID = intQuoId; objIQ.ImagePath = strImgFinalPath; objIQ.VideoPath = strVidFinalPath; objService.UpdateInquiryImages(objIQ); #endregion #region .. GET CUSTOMER CITY AND ZIPCODE .. string strCusCity = ""; string strCusZipcode = ""; string strVACity = ""; string strVAZipcode = ""; DataTable dtCus = objService.GetCustomerById(Convert.ToInt32(Session["LoginId"].ToString())); if (dtCus.Rows.Count > 0) { strCusCity = dtCus.Rows[0]["CityName"].ToString(); strCusZipcode = dtCus.Rows[0]["ZipCode"].ToString(); } #endregion DataTable dt = objService.SelectVendorByCategory(objQuiry.CategoryId); if (dt.Rows.Count > 0) { for (int intVen = 0; intVen < dt.Rows.Count; intVen++) { string sVenEmail = dt.Rows[intVen]["VendorEmail"].ToString(); #region .. GET VENDOR AREA .. strVACity = ""; strVAZipcode = ""; DataTable dtVenArea = objService.SelectAreaByVendorId(Convert.ToInt32(dt.Rows[intVen]["VendorID"].ToString())); if (dtVenArea.Rows.Count > 0) { for (int k = 0; k < dtVenArea.Rows.Count; k++) { strVACity = dtVenArea.Rows[k]["VACityName"].ToString(); strVAZipcode = dtVenArea.Rows[k]["VAZipcode"].ToString(); if (strVAZipcode == strCusZipcode) { VendorMessageDetails objVenMsgDet = new VendorMessageDetails(); objVenMsgDet.VendorMessageId = 0; objVenMsgDet.VendorId = Convert.ToInt32(dt.Rows[intVen]["VendorID"].ToString()); objVenMsgDet.SendCustomerId = objQuiry.CustomerId; objVenMsgDet.QuiryId = intQuoId; objVenMsgDet.CategoryId = Convert.ToInt32(objQuiry.CategoryId); objVenMsgDet.MessageTitle = txtQuoteTitle.Value.ToString(); objVenMsgDet.Description = txtQuoteDesc.Value.ToString(); objVenMsgDet.Status = "0"; int intVenMsg = objService.AddVendorMessage(objVenMsgDet); } } } #endregion } } divErrorMessage.InnerHtml = ""; divMessage.InnerHtml = "Your Inquiry posted sucessfully."; txtQuoteTitle.Value = ""; txtQuoteDesc.Value = ""; ddlCategory.SelectedIndex = 0; } else { divErrorMessage.InnerHtml = strErrorMsg; } }
void LoadProfile() { objService = new ServeAtDoorstepService(); DataTable dtCus = objService.GetCustomerById(Convert.ToInt32(sLoginId)); sCustomerId = sLoginId; if (dtCus.Rows.Count > 0) { spnCusImage.InnerHtml = "<a class='example-image-link' href='" + dtCus.Rows[0]["ImagePath"].ToString() + "' data-lightbox='example-1'" + "title='Or press the right arrow on your keyboard.'>" + "<img class='example-image' src='" + dtCus.Rows[0]["ImagePath"].ToString() + "' alt='Plants: image 2 0f 4 thumb' width='150' height='150' /></a>"; lblCusName.Text = dtCus.Rows[0]["FirstName"].ToString() + " " + dtCus.Rows[0]["LastName"].ToString(); lblCusLogName.Text = dtCus.Rows[0]["LoginName"].ToString(); lblCusLogPwd.Text = dtCus.Rows[0]["LoginPassword"].ToString(); lblCusEmail.Text = dtCus.Rows[0]["Email"].ToString(); lblCusMobile.Text = dtCus.Rows[0]["Mobile"].ToString(); string sGender = dtCus.Rows[0]["Gender"].ToString(); if (sGender == "0") lblCusGender.Text = "Rather not say"; else if (sGender == "1") lblCusGender.Text = "Male"; else if (sGender == "2") lblCusGender.Text = "Female"; lblCusState.Text = dtCus.Rows[0]["StateName"].ToString(); lblCusCity.Text = dtCus.Rows[0]["CityName"].ToString(); lblCusCountry.Text = dtCus.Rows[0]["CountryName"].ToString(); lblCusAddr.Text = dtCus.Rows[0]["Address"].ToString(); lblCusStreet.Text = dtCus.Rows[0]["StreetName"].ToString(); lblCusZip.Text = dtCus.Rows[0]["ZipCode"].ToString(); sBankId = dtCus.Rows[0]["BankId"].ToString(); lblBankName.Text = dtCus.Rows[0]["BankName"].ToString(); lblCardNo.Text = dtCus.Rows[0]["CreditCardNumber"].ToString(); lblHolderName.Text = dtCus.Rows[0]["CardHolderName"].ToString(); lblCVC.Text = dtCus.Rows[0]["CVCNumber"].ToString(); hdnAddress.Value = dtCus.Rows[0]["CityName"].ToString().Trim() + ", " + dtCus.Rows[0]["StateName"].ToString() + ", US"; } }
protected void Page_Load(object sender, EventArgs e) { isShowHideControl = "0"; lblWelcomeMsg.Visible = false; lblDashboard.Visible = false; btnPostButton.Visible = false; if (Request.Cookies["LoginType"] != null) { Session.Add("LoginType", Request.Cookies["LoginType"].Value.ToString()); } if (Request.Cookies["LoginId"] != null) { Session.Add("LoginId", Request.Cookies["LoginId"].Value.ToString()); } if (Session["LoginId"] != null && (Session["LoginType"] != null && Session["LoginType"].ToString() == "3")) { lblWelcomeMsg.Visible = true; lblDashboard.Visible = true; btnPostButton.Visible = false; isShowHideControl = "3"; // Admin } else if (Session["LoginId"] != null && (Session["LoginType"] != null && Session["LoginType"].ToString() == "2")) { lblWelcomeMsg.Visible = true; lblDashboard.Visible = true; btnPostButton.Visible = false; isShowHideControl = "2"; // Vendor } else if (Session["LoginId"] != null && (Session["LoginType"] != null && Session["LoginType"].ToString() == "1")) { lblWelcomeMsg.Visible = true; lblDashboard.Visible = true; btnPostButton.Visible = true; isShowHideControl = "1"; // Customer } if (Session["LoginId"] != null) strLoginId = Session["LoginId"].ToString(); if (Session["LoginType"] != null) strLoginType = Session["LoginType"].ToString(); if(strLoginType == "1") { objService = new ServeAtDoorstepService(); DataTable dt = objService.GetCustomerById(Convert.ToInt32(strLoginId)); if (dt.Rows.Count > 0) { strLoginName = dt.Rows[0]["LoginName"].ToString(); } lblWelcomeMsg.Text = "Welcome " + strLoginName; } else if (strLoginType == "2") { objService = new ServeAtDoorstepService(); DataTable dt = objService.GetVendorById(Convert.ToInt32(strLoginId)); if (dt.Rows.Count > 0) { strLoginName = dt.Rows[0]["LoginName"].ToString(); } lblWelcomeMsg.Text = "Welcome " + strLoginName; } else if (strLoginType == "3") { lblWelcomeMsg.Text = "Welcome Admin"; } }
void LoadProfile() { objService = new ServeAtDoorstepService(); DataTable dtCus = objService.GetCustomerById(Convert.ToInt32(sLoginId)); if (dtCus.Rows.Count > 0) { spnCusImage.InnerHtml = "<a class='example-image-link' href='" + dtCus.Rows[0]["ImagePath"].ToString() + "' data-lightbox='example-1'" + "title='Or press the right arrow on your keyboard.'>" + "<img class='example-image' src='" + dtCus.Rows[0]["ImagePath"].ToString() + "' alt='Plants: image 2 0f 4 thumb' width='150' height='150' /></a>"; txtFirstName.Value = dtCus.Rows[0]["FirstName"].ToString();// +" " + dtCus.Rows[0]["LastName"].ToString(); txtLastName.Value = dtCus.Rows[0]["LastName"].ToString(); lblLoginName.Text = dtCus.Rows[0]["LoginName"].ToString(); sLoginname = dtCus.Rows[0]["LoginName"].ToString(); sPassword = dtCus.Rows[0]["LoginPassword"].ToString(); sImagePath = dtCus.Rows[0]["ImagePath"].ToString(); lblEmail.Text = dtCus.Rows[0]["Email"].ToString(); txtEmail.Value = dtCus.Rows[0]["Email"].ToString(); txtMobile.Value = dtCus.Rows[0]["Mobile"].ToString(); rdoGender.SelectedValue = dtCus.Rows[0]["Gender"].ToString(); for (int i = 0; i < ddlCountry.Items.Count; i++) { if (ddlCountry.Items[i].Text == dtCus.Rows[0]["CountryName"].ToString()) ddlCountry.SelectedIndex = i; } for (int i = 0; i < ddlState.Items.Count; i++) { if (ddlState.Items[i].Text == dtCus.Rows[0]["StateName"].ToString()) ddlState.SelectedIndex = i; } string sState = dtCus.Rows[0]["StateName"].ToString(); string sStateId = dtCus.Rows[0]["StateId"].ToString(); DataTable dtCy = objService.SelectCityByStateId(Convert.ToInt32(sStateId)); ddlCity.Items.Clear(); ListItem listItem = new ListItem(); listItem.Text = "<Select City>"; listItem.Value = "0"; ddlCity.Items.Add(listItem); for (int i = 0; i < dtCy.Rows.Count; i++) { listItem = new ListItem(); listItem.Text = dtCy.Rows[i]["CityName"].ToString(); listItem.Value = dtCy.Rows[i]["CityId"].ToString(); ddlCity.Items.Add(listItem); } for (int i = 0; i < ddlCity.Items.Count; i++) { if (ddlCity.Items[i].Text == dtCus.Rows[0]["CityName"].ToString()) ddlCity.SelectedIndex = i; } txtAddress.Value = dtCus.Rows[0]["Address"].ToString(); txtStreetname.Value = dtCus.Rows[0]["StreetName"].ToString(); txtZipcode.Value = dtCus.Rows[0]["ZipCode"].ToString(); sBankId = dtCus.Rows[0]["BankId"].ToString(); hdnAddress.Value = dtCus.Rows[0]["CityName"].ToString().Trim() + ", " + dtCus.Rows[0]["StateName"].ToString() + ", US"; } }