protected void btnAddIndustry_Click(object sender, EventArgs e) { if (txtAddIndustry.Text == "") { lblAddIndustryError.Text = "Required"; } else { using (GESEntities db = new GESEntities()) { try { Industry newIndustry = new Industry(); newIndustry.IndustryName = txtAddIndustry.Text.ToString(); newIndustry.IndustryDescription = txtAddIndustry.Text.ToString(); newIndustry.Status = "Active"; db.Industries.AddObject(newIndustry); db.SaveChanges(); txtAddIndustry.Text = ""; lblAddIndustry.Text = "Added succesfully"; lblAddIndustryError.Text = ""; refreshIndustryEDS(); } catch (Exception exp) { throw new Exception("ERROR: Unable to Add entry - " + exp.Message.ToString(), exp); } } } }
protected void btnAddMachType_Click(object sender, EventArgs e) { if (txtAddMachType.Text == "") { lblAddMachTypeError.Text = "Required"; } else { using (GESEntities db = new GESEntities()) { try { MachineType newMachineType = new MachineType(); newMachineType.MachineTypeName = txtAddMachType.Text.ToString(); newMachineType.MachineTypeDescription = txtAddMachType.Text.ToString(); newMachineType.Status = "Active"; db.MachineTypes.AddObject(newMachineType); db.SaveChanges(); txtAddMachType.Text = ""; lblAddMach.Text = "Added succesfully"; lblAddMachTypeError.Text = ""; refreshMachineTypeEDS(); } catch (Exception exp) { throw new Exception("ERROR: Unable to Add entry - " + exp.Message.ToString(), exp); } } } }
void Application_Start(object sender, EventArgs e) { using (GESEntities db = new GESEntities()) { var getCounters = (from c in db.Counters where c.CounterType == "UserCounter" select c.NumberOfHits).Sum(); if (getCounters != null) { totalNumberOfUsers = Int32.Parse(getCounters.ToString()); } else { totalNumberOfUsers = 0; } } }
protected void CreateUserButton_Click(object sender, EventArgs e) { lblError.Text = ""; using (GESEntities db = new GESEntities()) { try { //Check that email doesn't exist var getUser = (from c in db.Users where c.Email == Email.Text.ToString() select c).FirstOrDefault(); if (getUser != null) { lblError.Text = "This Email address has already been registered"; } else { //Register user User newUser = new User(); newUser.UserName = Guid.NewGuid().ToString(); newUser.Password = Password.Text.ToString(); newUser.Email = Email.Text.ToString(); //newUser.FirstName = txtFirstName.Text.ToString(); //newUser.LastName = txtSurname.Text.ToString(); //newUser.CellNo = txtCellNo.Text.ToString(); //newUser.AddrCity = txtTown.Text.ToString(); newUser.RoleID = 2; db.Users.AddObject(newUser); db.SaveChanges(); //Send Welcome Email SendWelcomeMail(Email.Text.ToString()); Response.Redirect("~/MyQuip.aspx"); } } catch (Exception exp) { throw new Exception("ERROR: Unable to register New User - " + exp.Message.ToString(), exp); } } }
private void refreshEquipmentDetail() { using (GESEntities db = new GESEntities()) { try { int machineID = 0; try { Int32.TryParse(Request["MachineID"].ToString(), out machineID); } catch { machineID = 0; } var MachineList = (from c in db.vUsedMachineLists where c.MachineID == machineID select c); FormView_Product.DataSource = MachineList; FormView_Product.DataSourceID = ""; FormView_Product.DataBind(); var machineDetail = MachineList.FirstOrDefault(); Page.Header.Title = machineDetail.ManufacturerName + " " + machineDetail.ModelName + " " + machineDetail.Year + " " + machineDetail.MachineTypeName + " for sale" + " " + machineDetail.Location; Page.Header.Description = machineDetail.ManufacturerName + " " + machineDetail.ModelName + " " + machineDetail.Year + " " + machineDetail.MachineTypeName + " for sale" + " in " + machineDetail.Location; Page.Header.Keywords = machineDetail.ManufacturerName + ", " + machineDetail.ModelName + ", " + machineDetail.Year + ", " + machineDetail.MachineTypeName + " for sale" + ", " + machineDetail.MachineTypeName + " for sale " + machineDetail.Location; lblSearchResultLabel.Text = Page.Header.Title; } catch (Exception exp) { throw new Exception("ERROR: Unable to retrieve machine info - " + exp.Message.ToString(), exp); } } }
protected void gridPhotos_RowCommand(object sender, GridViewCommandEventArgs e) { int index = Convert.ToInt32(e.CommandArgument); string buttonPressed = e.CommandName.ToString(); int PhotoID = Int32.Parse(this.gridPhotos.Rows[index].Cells[0].Text); int MachineID = Int32.Parse(lblMachineID.Text.Substring(lblMachineID.Text.IndexOf(":") + 1).Trim()); if (buttonPressed == "deletePhoto") { //Delete from Photo table using (GESEntities db = new GESEntities()) { try { var deletePhoto = (from c in db.Photos where c.PhotoID == PhotoID select c).FirstOrDefault(); if (deletePhoto != null) { db.DeleteObject(deletePhoto); db.SaveChanges(); } } catch (Exception exp) { throw new Exception("ERROR: Unable to delete photo - " + exp.Message.ToString(), exp); } } //Delete from file server string fileName = this.gridPhotos.Rows[index].Cells[3].Text; fileName = Server.MapPath(fileName); File.Delete(fileName); } else if (buttonPressed == "setThumbnail") { using (GESEntities db = new GESEntities()) { try { var MachinePhotos = (from c in db.Photos where c.MachineID == MachineID select c); if (MachinePhotos != null) { foreach (var MachinePhotoItem in MachinePhotos) { UpdateMachinePhotoRow(MachinePhotoItem.PhotoID); } } var PhotoRow = (from c in db.Photos where c.PhotoID == PhotoID select c).FirstOrDefault(); if (PhotoRow != null) { PhotoRow.ShowThumbnail = "Y"; db.SaveChanges(); } } catch (Exception exp) { throw new Exception("ERROR: Unable to Set Thumbnail - " + exp.Message.ToString(), exp); } } } //gridPhotos.SelectedIndex = e.NewSelectedIndex; //Refresh Grid PhotosEntityDataSource.WhereParameters.Clear(); PhotosEntityDataSource.AutoGenerateWhereClause = true; PhotosEntityDataSource.WhereParameters.Add("MachineID", TypeCode.Int32, MachineID.ToString()); }
public void UpdateMachinePhotoRow(int MachinePhotoItem) { using (GESEntities db = new GESEntities()) { try { var MachinePhotoRow = (from c in db.Photos where c.PhotoID == MachinePhotoItem select c).FirstOrDefault(); if (MachinePhotoRow != null) { MachinePhotoRow.ShowThumbnail = "N"; db.SaveChanges(); } } catch (Exception exp) { throw new Exception("ERROR: Unable to update photo row- " + exp.Message.ToString(), exp); } } }
private void refreshMachineTypeEDS() { using (GESEntities db = new GESEntities()) { try { var MachineList = (from c in db.MachineTypes where c.Status == "Active" select c).OrderBy(x => x.MachineTypeName); lbMachineType.DataSource = MachineList; lbMachineType.DataSourceID = ""; lbMachineType.DataBind(); } catch (Exception ex) { } } }
public void UpdateMachineRow(int MachineID) { using (GESEntities db = new GESEntities()) { try { var editMachine = (from c in db.Machines where c.MachineID == MachineID select c).FirstOrDefault(); if (editMachine != null) { editMachine.ManufacturerID = Int32.Parse(listManufacturer.SelectedItem.Value); editMachine.MachineTypeID = Int32.Parse(listMachineType.SelectedItem.Value); editMachine.ModelID = Int32.Parse(listModel.SelectedItem.Value); editMachine.IndustryID = Int32.Parse(listIndustry.SelectedItem.Value); editMachine.MachineDescription = txtMachineDescription.Text.ToString(); editMachine.MachineGrade = txtMachineGrade.Text.ToString(); editMachine.SerialNo = txtSerial.Text.ToString(); editMachine.Year = txtYear.Text.ToString(); editMachine.Mileage = txtMileage.Text.ToString(); editMachine.Location = txtLocation.Text.ToString(); editMachine.CostPrice = ConvertStringDecimal(txtCostPrice.Text.ToString()); editMachine.SellPrice = ConvertStringDecimal(txtSalesPrice.Text.ToString()); editMachine.Status = listStatus.SelectedItem.Value; editMachine.DealerMachine = listDealerMachine.SelectedItem.Value; db.SaveChanges(); } } catch (Exception exp) { throw new Exception("ERROR: Unable to Update Cart Item - " + exp.Message.ToString(), exp); } } }
protected void btnEnquiry_Click(object sender, EventArgs e) { int enquiryID = 0; using (GESEntities db = new GESEntities()) { try { //Create a visitor user ID if not already logged in //------------------------------------------------------------------------+ // Add New User Record | //------------------------------------------------------------------------+ User newUser = new User(); newUser.UserName = "******" + Guid.NewGuid().ToString(); newUser.Password = "******"; newUser.FirstName = txtFirstName.Text.ToString(); newUser.LastName = txtSurname.Text.ToString(); newUser.Email = txtEmail.Text.ToString(); newUser.CellNo = txtCellNo.Text.ToString(); newUser.AddrCity = txtTown.Text.ToString(); newUser.RoleID = 1; //Visitor db.Users.AddObject(newUser); db.SaveChanges(); //------------------------------------------------------------------------+ // Add New Enquiry Record | //------------------------------------------------------------------------+ Enquiry newEnquiry = new Enquiry(); newEnquiry.UserID = newUser.UserID; newEnquiry.DateInserted = DateTime.Now; newEnquiry.Comments = txtComments.Text.ToString(); newEnquiry.MachineID = 0; db.Enquiries.AddObject(newEnquiry); db.SaveChanges(); enquiryID = newEnquiry.EnquiryID; } catch (Exception exp) { throw new Exception("ERROR: Unable to Submit Enquiry - " + exp.Message.ToString(), exp); } } //------------------------------------------------------------------------+ // Send off the email notification | //------------------------------------------------------------------------+ string body = ""; string subject = ""; using (GESEntities db = new GESEntities()) { try { subject = "GES Website Enquiry # " + enquiryID.ToString() + " from the JCB Parts Lead Page"; body = body + "Lead Detail" + Environment.NewLine + "-----------" + Environment.NewLine + "First Name : " + txtFirstName.Text.ToString() + Environment.NewLine + "Surname : " + txtSurname.Text.ToString() + Environment.NewLine + "Email : " + txtEmail.Text.ToString() + Environment.NewLine + "Cell No : " + txtCellNo.Text.ToString() + Environment.NewLine + "Town : " + txtTown.Text.ToString() + Environment.NewLine + "Comments/Requirements : " + txtComments.Text.ToString(); //Send Mail MailMessage mailObj = new MailMessage("*****@*****.**", "*****@*****.**", subject, body); mailObj.To.Add("*****@*****.**"); mailObj.CC.Add("*****@*****.**"); mailObj.Body = body.ToString(); SmtpClient SMTPServer = new SmtpClient(); SMTPServer.Host = "smtp.gmail.com"; SMTPServer.Credentials = new System.Net.NetworkCredential("*****@*****.**", "reevesie007"); SMTPServer.EnableSsl = true; try { SMTPServer.Send(mailObj); Response.Redirect("~/LeadManagement/Lead-Enquiry-Confirmation.aspx", false); } catch (Exception ex) { string error = ex.ToString(); } } catch (Exception exp) { throw new Exception("ERROR: Unable to send mail - " + exp.Message.ToString(), exp); } } }
//private void refreshManufacturerEDS() //{ // ManufacturerEntityDataSource.WhereParameters.Clear(); // ManufacturerEntityDataSource.AutoGenerateWhereClause = true; // ManufacturerEntityDataSource.WhereParameters.Add("Status", TypeCode.String, "Active"); //} protected void btnAddMachine_Click(object sender, EventArgs e) { string userName = ""; System.Security.Principal.IPrincipal User = HttpContext.Current.User; userName = User.Identity.Name.ToUpper(); if (userName == "DEMO") { string newMachineID = "0"; string mode = Request["mode"].ToString(); string industryID = Request["industryID"].ToString(); string machineTypeID = Request["machineTypeID"].ToString(); Response.Redirect("AddUsedEquipment_Page3.aspx?mode=" + mode + "&machineID=" + newMachineID + "&industryID=" + industryID + "&machineTypeID=" + machineTypeID + "&Model=" + tbModel.Text.Replace(" ", "-") + "&ManufacturerID=" + lbManufacturer.SelectedItem.Value + "&uploadMethod=arigma", false); } else { using (GESEntities db = new GESEntities()) { try { if (Request["mode"].ToString() == "new") { Machine newMachine = new Machine(); newMachine.ManufacturerID = Int32.Parse(lbManufacturer.SelectedItem.Value); newMachine.MachineTypeID = Int32.Parse(Request["machineTypeID"].ToString()); newMachine.ModelName = tbModel.Text; newMachine.IndustryID = Int32.Parse(Request["industryID"].ToString()); newMachine.MachineDescription = txtMachineDescription.Text.ToString(); newMachine.MachineGrade = txtMachineGrade.Text.ToString(); newMachine.SerialNo = txtSerial.Text.ToString(); newMachine.Year = txtYear.Text.ToString(); newMachine.Mileage = txtMileage.Text.ToString(); newMachine.Location = txtLocation.Text.ToString(); newMachine.ContactPerson = txtContactPerson.Text.ToString(); newMachine.EmailAddress = txtEmailAddress.Text.ToString(); newMachine.ContactNumber = txtContactNumber.Text.ToString(); newMachine.CostPrice = ConvertStringDecimal(txtCostPrice.Text.ToString()); newMachine.SellPrice = ConvertStringDecimal(txtSalesPrice.Text.ToString()); newMachine.Status = listStatus.SelectedItem.Value; newMachine.DealerMachine = "N"; newMachine.DateInserted = DateTime.Now; db.Machines.AddObject(newMachine); db.SaveChanges(); string newMachineID = newMachine.MachineID.ToString(); string mode = Request["mode"].ToString(); string industryID = Request["industryID"].ToString(); string machineTypeID = Request["machineTypeID"].ToString(); Response.Redirect("AddUsedEquipment_Page3.aspx?mode=" + mode + "&machineID=" + newMachineID + "&industryID=" + industryID + "&machineTypeID=" + machineTypeID + "&Model=" + tbModel.Text.Replace(" ", "-") + "&ManufacturerID=" + lbManufacturer.SelectedItem.Value + "&uploadMethod=arigma", false); } else { int machineID = 0; try { Int32.TryParse(Request["machineID"].ToString(), out machineID); } catch { machineID = 0; } var editMachine = (from c in db.Machines where c.MachineID == machineID select c).FirstOrDefault(); if (editMachine != null) { editMachine.ManufacturerID = Int32.Parse(lbManufacturer.SelectedItem.Value); editMachine.MachineTypeID = Int32.Parse(Request["machineTypeID"].ToString()); editMachine.ModelName = tbModel.Text; editMachine.IndustryID = Int32.Parse(Request["industryID"].ToString()); editMachine.MachineDescription = txtMachineDescription.Text.ToString(); editMachine.MachineGrade = txtMachineGrade.Text.ToString(); editMachine.SerialNo = txtSerial.Text.ToString(); editMachine.Year = txtYear.Text.ToString(); editMachine.Mileage = txtMileage.Text.ToString(); editMachine.Location = txtLocation.Text.ToString(); editMachine.CostPrice = ConvertStringDecimal(txtCostPrice.Text.ToString()); editMachine.SellPrice = ConvertStringDecimal(txtSalesPrice.Text.ToString()); editMachine.Status = listStatus.SelectedItem.Value; editMachine.DealerMachine = "N"; editMachine.DateInserted = DateTime.Now; db.SaveChanges(); Response.Redirect("AddUsedEquipment_Page3.aspx?mode=" + Request["mode"].ToString() + "&machineID=" + Request["machineID"].ToString() + "&industryID=" + Request["industryID"].ToString() + "&machineTypeID=" + Request["machineTypeID"].ToString() + "&Model=" + tbModel.Text.Replace(" ", "-") + "&ManufacturerID=" + lbManufacturer.SelectedItem.Value + "&uploadMethod=arigma", false); } } } catch (Exception exp) { if (exp.Message.Contains("inner exception")) { lblStatus.Text = "ERROR: Unable to add/edit used equipment- " + exp.InnerException.ToString(); } else { lblStatus.Text = "ERROR: Unable to add/edit used equipment- " + exp.Message.ToString(); } } } } }
void Session_Start(object sender, EventArgs e) { // Increase the two counters totalNumberOfUsers += 1; currentNumberOfUsers += 1; try { // Save the Total Number of Users to the database using (GESEntities db = new GESEntities()) { string execPath = Server.HtmlEncode(Request.CurrentExecutionFilePath); DateTime sDate = DateTime.Now.Date; var editCounters = (from c in db.Counters where c.CounterType == "UserCounter" && c.ExecutionPath == execPath && c.DateInserted == sDate select c).FirstOrDefault(); if (editCounters != null) { //Edit editCounters.NumberOfHits += 1; db.SaveChanges(); } else { //Insert Counter newCounter = new Counter(); newCounter.CounterType = "UserCounter"; newCounter.NumberOfHits = 1; newCounter.ExecutionPath = Server.HtmlEncode(Request.CurrentExecutionFilePath); newCounter.DateInserted = DateTime.Now.Date; db.Counters.AddObject(newCounter); db.SaveChanges(); } } } catch (Exception exp) { throw new Exception("ERROR: Unable to update counter - " + exp.Message.ToString(), exp); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int machineID = 0; try { Int32.TryParse(Request["machineID"].ToString(), out machineID); } catch { machineID = 0; } hfMachineID.Value = machineID.ToString(); hfBody.Value = ""; string source = ""; try { source = Request["source"].ToString(); if (source == "used-equipment") { using (GESEntities db = new GESEntities()) { try { var Machines = (from p in db.vUsedMachineLists where p.MachineID == machineID select p).FirstOrDefault(); hfBody.Value = "Machine Details" + Environment.NewLine + "---------------" + Environment.NewLine + "Machine ID : " + Machines.MachineID + Environment.NewLine + "Manufacturer : " + Machines.ManufacturerName + Environment.NewLine + "Machine Type : " + Machines.MachineTypeName + Environment.NewLine + "Model : " + Machines.ModelName + Environment.NewLine + "Description : " + Machines.MachineDescription + Environment.NewLine + "Condition : " + Machines.MachineGrade + Environment.NewLine + "Serial # : " + Machines.SerialNo + Environment.NewLine + "Year : " + Machines.Year + Environment.NewLine + "Mileage : " + Machines.Mileage + Environment.NewLine + "Location : " + Machines.Location + Environment.NewLine + "Selling Price : " + Machines.SellPrice + Environment.NewLine + "Status : " + Machines.Status + Environment.NewLine + Environment.NewLine; } catch (Exception exp) { throw new Exception("ERROR: Unable to obtain machine detail - " + exp.Message.ToString(), exp); } } txtComments.Text = "Please contact me urgently to discuss the following machine:" + Environment.NewLine + hfBody.Value; } if (source == "equipment-to-sell") { txtComments.Text = "Thanks for clicking our banner advertisement." + Environment.NewLine + Environment.NewLine + "Either give Mark a call on 0732115904 to discuss personally or complete this enquiry page and email pictures to [email protected]." + Environment.NewLine + Environment.NewLine + "When completing this enquiry page please provide as much information as possible i.e. Manufacturer, model, year, hours, condition, known defects/problems"; } if (source == "grease-gun-ad") { txtComments.Text = "I'm interested in your Grease Gun promotion. Please contact me urgently to discuss."; } if (source == "roller-320d-ad") { txtComments.Text = "I'm interested in your 320D Roller for sale. Please contact me urgently to discuss."; } if (source == "140h-rim-for-sale-ad") { txtComments.Text = "I'm interested in your 140H Rim for sale. Please contact me urgently to discuss."; } if (source == "post-ad") { txtComments.Text = "Please contact me to discuss advertising on your site."; } if (source == "shantui-forklift-promo") { txtComments.Text = "I'm interested in your Shantui Forklift promotion. Please contact me urgently to discuss."; } if (source == "shantui-list-page") { using (GESEntities db = new GESEntities()) { try { var Machines = (from p in db.Shantuis where p.ProductID == machineID select p).FirstOrDefault(); hfBody.Value = "Product Details" + Environment.NewLine + "---------------" + Environment.NewLine + "Product ID : " + Machines.ProductID + Environment.NewLine + "Category : " + Machines.Category + Environment.NewLine + "Model : " + Machines.Model + Environment.NewLine + Environment.NewLine; } catch (Exception exp) { throw new Exception("ERROR: Unable to obtain machine detail - " + exp.Message.ToString(), exp); } } txtComments.Text = "Please contact me urgently to discuss the following Shantui machine:" + Environment.NewLine + Environment.NewLine + hfBody.Value; } } catch { source = "Unknown"; } } }
protected void btnUpload_Click(object sender, EventArgs e) { if (uploadFile.HasFile == false) { UploadDetails.Text = "Please first select a file to upload..."; } else { using (GESEntities db = new GESEntities()) { int iMachineID = Int32.Parse(lblMachineID.Text.Substring(lblMachineID.Text.IndexOf(":") + 1).Trim()); //Fetch next photo # in the photo table for this machine int iNextMachinePhotoID = 0; System.Nullable < Int32 > GetNextPhoto = (from p in db.Photos where p.MachineID == iMachineID select (int?)p.MachinePhotoID).Max(); if (GetNextPhoto.HasValue) { iNextMachinePhotoID = GetNextPhoto.Value + 1; } else { iNextMachinePhotoID = 1; } //Save the image string fileName = iMachineID.ToString() + "-" + iNextMachinePhotoID.ToString() + Path.GetExtension(uploadFile.FileName); string filePath = Server.MapPath("~/UsedPics/" + fileName); string fileNameTemp = "Temp" + iMachineID.ToString() + "-" + iNextMachinePhotoID.ToString() + Path.GetExtension(uploadFile.FileName); string filePathTemp = Server.MapPath("~/UsedPics/" + fileNameTemp); uploadFile.SaveAs(filePathTemp); //Resize image Bitmap mg = new Bitmap(filePathTemp); int imgHeight = mg.Height; int imgWidth = mg.Width; bool resizeImage = false; if (imgHeight >= imgWidth) { if (imgHeight > 480) { resizeImage = true; } } else { if (imgWidth > 640) { resizeImage = true; } } if (resizeImage) { Bitmap bp = FixedSize(mg, 640, 480); bp.Save(filePath, System.Drawing.Imaging.ImageFormat.Jpeg); bp.Dispose(); } else { Bitmap bp = FixedSize(mg, imgHeight, imgWidth); bp.Save(filePath, System.Drawing.Imaging.ImageFormat.Jpeg); bp.Dispose(); } mg.Dispose(); //delete Temp file if (File.Exists(filePathTemp)) { File.Delete(filePathTemp); } // Display the uploaded file's details UploadDetails.Text = string.Format(@"Uploaded file: {0}<br /> File size (in bytes): {1:N0}<br /> Content-type: {2}", uploadFile.FileName, uploadFile.FileBytes.Length, uploadFile.PostedFile.ContentType); //insert a row into the photos table Photo newPhoto = new Photo(); newPhoto.MachineID = iMachineID; newPhoto.PhotoName = "Test"; newPhoto.PhotoDescription = "Test"; newPhoto.PhotoUrl = "UsedPics/" + fileName; newPhoto.Status = "Active"; newPhoto.ShowThumbnail = "N"; newPhoto.MachinePhotoID = iNextMachinePhotoID; db.Photos.AddObject(newPhoto); db.SaveChanges(); //Refresh thumbnail list PhotosEntityDataSource.WhereParameters.Clear(); PhotosEntityDataSource.AutoGenerateWhereClause = true; PhotosEntityDataSource.WhereParameters.Add("MachineID", TypeCode.Int32, iMachineID.ToString()); gridPhotos.Visible = true; } } }
protected void btnUploadSpec_Click(object sender, EventArgs e) { if (uploadFile.HasFile == false) { UploadDetails.Text = "Please first select a file to upload..."; } else { using (GESEntities db = new GESEntities()) { int iMachineID = Int32.Parse(lblMachineID.Text.Substring(lblMachineID.Text.IndexOf(":") + 1).Trim()); //Fetch next photo # in the photo table for this machine int iNextSpecID = 0; System.Nullable<Int32> GetNextSpec = (from p in db.Specifications where p.MachineID == iMachineID select (int?)p.MachineSpecID).Max(); if (GetNextSpec.HasValue) { iNextSpecID = GetNextSpec.Value + 1; } else { iNextSpecID = 1; } //Save the image string fileName = iMachineID.ToString() + "-" + iNextSpecID.ToString() + Path.GetExtension(uploadFile.FileName); string filePath = Server.MapPath("~/Specs/" + fileName); string fileNameTemp = "Temp" + iMachineID.ToString() + "-" + iNextSpecID.ToString() + Path.GetExtension(uploadFile.FileName); string filePathTemp = Server.MapPath("~/Specs/" + fileNameTemp); uploadFile.SaveAs(filePathTemp); //delete Temp file if (File.Exists(filePathTemp)) { File.Delete(filePathTemp); } // Display the uploaded file's details UploadDetails.Text = string.Format(@"Uploaded file: {0}<br /> File size (in bytes): {1:N0}<br /> Content-type: {2}", uploadFile.FileName, uploadFile.FileBytes.Length, uploadFile.PostedFile.ContentType); //insert a row into the photos table Specification newSpec = new Specification(); newSpec.MachineID = iMachineID; newSpec.SpecName = "Test"; newSpec.SpecDescription = "Test"; newSpec.SpecUrl = "Specs/" + fileName; newSpec.Status = "Active"; newSpec.MachineSpecID = iNextSpecID; db.Specifications.AddObject(newSpec); db.SaveChanges(); //Refresh thumbnail list SpecsEntityDataSource.WhereParameters.Clear(); SpecsEntityDataSource.AutoGenerateWhereClause = true; SpecsEntityDataSource.WhereParameters.Add("MachineID", TypeCode.Int32, iMachineID.ToString()); gridSpecs.Visible = true; } } }
protected void btnAddModel_Click(object sender, EventArgs e) { if (txtAddModel.Text == "") { lblAddModelError.Text = "Required"; } else { //Check that all fields are populated if (listManufacturer.SelectedIndex < 0) { lblAddModel.Text = "Choose a Manufacturer"; return; } if (listMachineType.SelectedIndex < 0) { lblAddModel.Text = "Choose a Machine Type"; return; } using (GESEntities db = new GESEntities()) { try { Model newModel = new Model(); newModel.ManufacturerID = Int32.Parse(listManufacturer.SelectedItem.Value); ; newModel.MachineTypeID = Int32.Parse(listMachineType.SelectedItem.Value); ; newModel.ModelName = txtAddModel.Text.ToString(); newModel.ModelDescription = txtAddModel.Text.ToString(); newModel.Status = "Active"; db.Models.AddObject(newModel); db.SaveChanges(); hfManufacturer.Value = listManufacturer.SelectedItem.Value; hfMachineType.Value = listMachineType.SelectedItem.Value; hfModel.Value = newModel.ModelID.ToString(); txtAddModel.Text = ""; lblAddModel.Text = "Added succesfully"; refreshModelEDS(); lblAddModelError.Text = ""; } catch (Exception exp) { throw new Exception("ERROR: Unable to Add entry - " + exp.Message.ToString(), exp); } } } }
protected void btnAddManu_Click(object sender, EventArgs e) { if (txtAddManu.Text == "") { lblAddManuError.Text = "Required"; } else { using (GESEntities db = new GESEntities()) { try { Manufacturer newManufacturer = new Manufacturer(); newManufacturer.ManufacturerName = txtAddManu.Text.ToString(); newManufacturer.ManufacturerDescription = txtAddManu.Text.ToString(); newManufacturer.Status = "Active"; db.Manufacturers.AddObject(newManufacturer); db.SaveChanges(); txtAddManu.Text = ""; lblAddManu.Text = "Added succesfully"; ModelEntityDataSource.WhereParameters.Clear(); ModelEntityDataSource.AutoGenerateWhereClause = true; refreshManufacturerEDS(); lblAddManuError.Text = ""; } catch (Exception exp) { throw new Exception("ERROR: Unable to Add entry - " + exp.Message.ToString(), exp); } } } }
protected void btnAddMachine_Click(object sender, EventArgs e) { using (GESEntities db = new GESEntities()) { try { Machine newMachine = new Machine(); newMachine.ManufacturerID = Int32.Parse(listManufacturer.SelectedItem.Value); newMachine.MachineTypeID = Int32.Parse(listMachineType.SelectedItem.Value); newMachine.ModelID = Int32.Parse(listModel.SelectedItem.Value); newMachine.IndustryID = Int32.Parse(listIndustry.SelectedItem.Value); newMachine.MachineDescription = txtMachineDescription.Text.ToString(); newMachine.MachineGrade = txtMachineGrade.Text.ToString(); newMachine.SerialNo = txtSerial.Text.ToString(); newMachine.Year = txtYear.Text.ToString(); newMachine.Mileage = txtMileage.Text.ToString(); newMachine.Location = txtLocation.Text.ToString(); newMachine.ContactPerson = txtContactPerson.Text.ToString(); newMachine.EmailAddress = txtEmailAddress.Text.ToString(); newMachine.ContactNumber = txtContactNumber.Text.ToString(); newMachine.CostPrice = ConvertStringDecimal(txtCostPrice.Text.ToString()); newMachine.SellPrice = ConvertStringDecimal(txtSalesPrice.Text.ToString()); newMachine.Status = listStatus.SelectedItem.Value; newMachine.DealerMachine = "N"; newMachine.DateInserted = DateTime.Now; db.Machines.AddObject(newMachine); db.SaveChanges(); lblMachineID.Text = newMachine.MachineID.ToString(); lblStatus.Text = ". Successully created machine row"; panelUpload.Visible = true; //btnAddMachine.Visible = false; //btnUpdateMachine.Visible = true; //btnAddAnother.Visible = true; Response.Redirect("AddUsedEquipment.aspx?mode=edit&machineID=" + newMachine.MachineID.ToString()); } catch (Exception exp) { throw new Exception("ERROR: Unable to Submit Enquiry - " + exp.Message.ToString(), exp); } } // Response.Redirect("ProductDetails.aspx?ProductID=" + productID); }
protected String insertZOHOLead(string enquiryID, string description, string title) { string price = ""; //Get machine Type and Model using (GESEntities db = new GESEntities()) { try { int machineID = 0; try { Int32.TryParse(hfMachineID.Value, out machineID); } catch { machineID = 0; } if (machineID > 0) { var Machines = (from p in db.vUsedMachineLists where p.MachineID == machineID select p).FirstOrDefault(); title = title.ToLower(); title = title.Replace(" - used equipment page", ""); title = title + " | " + Machines.MachineTypeName + " | " + Machines.ManufacturerName + " | " + Machines.ModelName; price = Machines.SellPrice.ToString(); } } catch (Exception exp) { throw new Exception("ERROR: Unable to obtain machine detail - " + exp.Message.ToString(), exp); } } WebRequest request = null; WebResponse response = null; string zohoResponse = ""; try { string ZOHOApiKey = WebConfigurationManager.AppSettings["ZOHOApiKey"]; string ZOHOUsername = WebConfigurationManager.AppSettings["ZOHOUsername"]; string ZOHOPassword = WebConfigurationManager.AppSettings["ZOHOPassword"]; string ZOHOTicket = getZOHOTicket("ZohoCRM", ZOHOUsername, ZOHOPassword); string uri = string.Format("https://crm.zoho.com/crm/private/xml/Leads/insertRecords?newFormat=1&apikey={0}&ticket={1}", ZOHOApiKey, ZOHOTicket); string xml = @"xmlData=<?xml version=""1.0"" encoding=""utf-8""?>" + @"<Leads>" + @"<row no=""1"">" + @"<FL val=""Lead Owner"">Graham Reeves</FL>" + @"<FL val=""Company"">New Lead</FL>" + @"<FL val=""Title"">" + title + "</FL>" + @"<FL val=""First Name"">" + txtFirstName.Text.ToString() + "</FL>" + @"<FL val=""Last Name"">" + txtSurname.Text.ToString() + "</FL>" + @"<FL val=""Email"">"+txtEmail.Text.ToString()+"</FL>" + @"<FL val=""Mobile"">"+txtCellNo.Text.ToString()+"</FL>" + @"<FL val=""Lead Source"">GES Website</FL>" + @"<FL val=""Lead Status"">Not Contacted</FL>" + @"<FL val=""LeadSourceID"">" + enquiryID + "</FL>" + @"<FL val=""City"">"+txtTown.Text.ToString()+"</FL>" + @"<FL val=""Price Range"">" + price + "</FL>" + @"<FL val=""Description"">" + description + "</FL>" + @"</row>" + @"</Leads>"; UTF8Encoding utf8 = new UTF8Encoding(false); // false = do not output UTF8 byte order mark (BOM) byte[] bytes = utf8.GetBytes(xml); // create web request request = WebRequest.Create(uri); request.Method = "POST"; request.ContentType = "application/x-www-form-urlencoded"; request.ContentLength = bytes.LongLength; // write xml to request stream using (Stream writer = request.GetRequestStream()) { writer.Write(bytes, 0, (int)request.ContentLength); writer.Flush(); } // send xml and get response response = request.GetResponse(); StreamReader reader = new StreamReader(response.GetResponseStream()); zohoResponse = reader.ReadToEnd(); // output results //Response.Write(string.Format("<h1>Zoho lead v{0}<h1><h2>Zoho request<h2><textarea>{1}</textarea><h2>Zoho response<h2><textarea>{2}</textarea>", version, xml, zohoResponse)); } catch (WebException webEx) { throw webEx; } catch (Exception ex) { } finally { // close request and response stream //if (request != null) request.Close(); //if (response != null) response.Close(); } return zohoResponse; }
protected void Page_Load(object sender, EventArgs e) { //if (!IsPostBack) //{ // listManufacturer.Items.Insert(0, new ListItem("--Please select a value--", "-1", true)); // listMachineType.Items.Insert(0, new ListItem("--Please select a value--")); // listModel.Items.Insert(-1, new ListItem("--Please select a value--", "-1")); // listIndustry.Items.Insert(-1, new ListItem("--Please select a value--", "-1")); //} //else //{ // listManufacturer.AppendDataBoundItems = false; // listMachineType.AppendDataBoundItems = false; // listModel.AppendDataBoundItems = false; // listIndustry.AppendDataBoundItems = false; //} string mode = ""; try { mode = Request["mode"].ToString(); } catch { mode = "new"; } if (mode == "edit") { using (GESEntities db = new GESEntities()) { try { if (lblMachineID.Text == "") { int MachineID = 0; Int32.TryParse(Request["MachineID"].ToString(), out MachineID); //show machine data var getmachineRow = (from p in db.Machines where p.MachineID == MachineID select p).FirstOrDefault(); if (getmachineRow != null) { lblMachineID.Text = getmachineRow.MachineID.ToString(); hfManufacturer.Value = getmachineRow.ManufacturerID.Value.ToString(); hfMachineType.Value = getmachineRow.MachineTypeID.ToString(); hfModel.Value = getmachineRow.ModelID.ToString(); hfIndustry.Value = getmachineRow.IndustryID.Value.ToString(); txtMachineDescription.Text = getmachineRow.MachineDescription; txtMachineGrade.Text = getmachineRow.MachineGrade; txtSerial.Text = getmachineRow.SerialNo; txtYear.Text = getmachineRow.Year; txtMileage.Text = getmachineRow.Mileage; txtLocation.Text = getmachineRow.Location; txtContactPerson.Text = getmachineRow.ContactPerson; txtEmailAddress.Text = getmachineRow.EmailAddress; txtContactNumber.Text = getmachineRow.ContactNumber; txtCostPrice.Text = getmachineRow.CostPrice.ToString(); txtSalesPrice.Text = getmachineRow.SellPrice.ToString(); hfStatus.Value = getmachineRow.Status.ToString(); //Show panels and refresh grid panelUpload.Visible = true; gridPhotos.Visible = true; //Show panels and refresh grid gridSpecs.Visible = true; //Refresh Photos grid PhotosEntityDataSource.WhereParameters.Clear(); PhotosEntityDataSource.AutoGenerateWhereClause = true; PhotosEntityDataSource.WhereParameters.Add("MachineID", TypeCode.Int32, MachineID.ToString()); } btnAddMachine.Visible = false; btnUpdateMachine.Visible = true; btnAddAnother.Visible = true; } } catch (Exception exp) { throw new Exception("ERROR: Unable to Submit Enquiry - " + exp.Message.ToString(), exp); } } } else { if (!IsPostBack) { hfManufacturer.Value = "0"; hfMachineType.Value = "0"; hfModel.Value = "0"; hfStatus.Value = "0"; btnAddMachine.Visible = true; btnUpdateMachine.Visible = false; btnAddAnother.Visible = false; } } }
protected void btnEnquiry_Click(object sender, EventArgs e) { bool proceed = true; lblFirstName.Text = ""; lblSurname.Text = ""; lblEmailRequired.Text = ""; lblCellNo.Text = ""; //do normal checks if (txtFirstName.Text == "") { lblFirstName.Text = "Oops.... First Name please"; proceed = false; } if (txtSurname.Text == "") { lblSurname.Text = "Oops.... Surname please"; proceed = false; } if (txtEmail.Text == "") { lblEmailRequired.Text = "Oops.... Email Address please"; proceed = false; } else { if (!Regex.IsMatch(txtEmail.Text, @"\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*")) { lblEmailRequired.Text = "Oops.... Please provide the correct email format"; proceed = false; } } if (txtCellNo.Text == "") { lblCellNo.Text = "Oops.... Cell # please"; proceed = false; } else { if (!Regex.IsMatch(txtCellNo.Text, @"^[0-9]+$")) { lblCellNo.Text = "Oops.... Please provide a numeric only number i.e. no spaces, hyphens, brackets, etc"; proceed = false; } } if (proceed) { btnEnquiry.Attributes.Add("onclick", "javascript:" + btnEnquiry.ClientID + ".disabled=true;" + ClientScript.GetPostBackEventReference(btnEnquiry, "")); int machineID = Int32.Parse(hfMachineID.Value); int enquiryID = 0; string source = ""; try { source = Request["source"].ToString(); } catch { source = "Unknown"; } string body = ""; string subject = ""; using (GESEntities db = new GESEntities()) { try { //Create a visitor user ID if not already logged in //------------------------------------------------------------------------+ // Add New User Record | //------------------------------------------------------------------------+ User newUser = new User(); newUser.UserName = "******" + Guid.NewGuid().ToString(); newUser.Password = "******"; newUser.FirstName = txtFirstName.Text.ToString(); newUser.LastName = txtSurname.Text.ToString(); newUser.Email = txtEmail.Text.ToString(); newUser.CellNo = txtCellNo.Text.ToString(); newUser.AddrCity = txtTown.Text.ToString(); newUser.RoleID = 1; //Visitor newUser.Comments = txtComments.Text.ToString(); db.Users.AddObject(newUser); db.SaveChanges(); //------------------------------------------------------------------------+ // Add New Enquiry Record | //------------------------------------------------------------------------+ Enquiry newEnquiry = new Enquiry(); newEnquiry.UserID = newUser.UserID; newEnquiry.DateInserted = DateTime.Now; newEnquiry.Comments = txtComments.Text.ToString(); newEnquiry.MachineID = machineID; newEnquiry.Source = source; db.Enquiries.AddObject(newEnquiry); db.SaveChanges(); enquiryID = newEnquiry.EnquiryID; if (source == "grease-gun-ad") { subject = "GES Enquiry # " + enquiryID.ToString() + " - Grease Gun Advert"; } else if (source == "post-ad") { subject = "GES Enquiry # " + enquiryID.ToString() + " - Advertising Banners"; } else if (source == "roller-320d-ad") { subject = "GES Enquiry # " + enquiryID.ToString() + " - 320D Roller for sale"; } else if (source == "140h-rim-for-sale-ad") { subject = "GES Enquiry # " + enquiryID.ToString() + " - 140H Rim for sale"; } else if (source == "used-equipment") { subject = "GES Enquiry # " + enquiryID.ToString() + " - Used Equipment page"; } else if (source == "shantui-forklift-promo") { subject = "GES Enquiry # " + enquiryID.ToString() + " - Shantui Forklift Promotion page"; } else if (source == "shantui-list-page") { subject = "GES Enquiry # " + enquiryID.ToString() + " - Shantui list page"; } else if (source == "contact-us") { subject = "GES Enquiry # " + enquiryID.ToString() + " - Contact Us page"; } else if (source == "equipment-to-sell") { subject = "GES Enquiry # " + enquiryID.ToString() + " - Equipment To Sell Banner"; } else { subject = "GES Enquiry # " + enquiryID.ToString() + " - Page source unknown"; } } catch (Exception exp) { throw new Exception("ERROR: Unable to Submit Enquiry - " + exp.Message.ToString(), exp); } } //------------------------------------------------------------------------+ // Send off the email notification | //------------------------------------------------------------------------+ //body = hfBody.Value; body = body + "Lead Detail" + Environment.NewLine + "-----------" + Environment.NewLine + "Lead Source : " + source + Environment.NewLine + "First Name : " + txtFirstName.Text.ToString() + Environment.NewLine + "Surname : " + txtSurname.Text.ToString() + Environment.NewLine + "Email : " + txtEmail.Text.ToString() + Environment.NewLine + "Cell No : " + txtCellNo.Text.ToString() + Environment.NewLine + "Town : " + txtTown.Text.ToString() + Environment.NewLine + "Comments/Requirements : " + Environment.NewLine + Environment.NewLine + txtComments.Text.ToString(); try { string SMTPHost = WebConfigurationManager.AppSettings["SMTPHost"]; string SMTPUsername = WebConfigurationManager.AppSettings["SMTPUsername"]; string SMTPPassword = WebConfigurationManager.AppSettings["SMTPPassword"]; //string SMTPFrom = WebConfigurationManager.AppSettings["SMTPFrom"]; string SMTPFrom = txtEmail.Text.ToString(); string SMTPTo = WebConfigurationManager.AppSettings["SMTPTo"]; string SMTPCc = WebConfigurationManager.AppSettings["SMTPCc"]; #if DEBUG SMTPFrom = WebConfigurationManager.AppSettings["SMTPFromTest"]; SMTPTo = WebConfigurationManager.AppSettings["SMTPToTest"]; SMTPCc = WebConfigurationManager.AppSettings["SMTPCcTest"]; #endif //Send Mail MailMessage mailObj = new MailMessage(); MailAddress from = new MailAddress(SMTPFrom, txtFirstName.Text.ToString() + " " + txtSurname.Text.ToString()); mailObj.From = from; mailObj.Subject = subject + " | " + txtFirstName.Text.ToString() + " " + txtSurname.Text.ToString(); mailObj.Body = body.ToString(); //Get the To receipients char[] separator = new char[] { ';' }; string[] strToSplit = SMTPTo.Split(separator); foreach (string arrStr in strToSplit) { mailObj.To.Add(arrStr); } //Get the CC receipients string[] strCCSplit = SMTPCc.Split(separator); foreach (string arrStr in strCCSplit) { mailObj.CC.Add(arrStr); } SmtpClient SMTPServer = new SmtpClient(); SMTPServer.Host = SMTPHost; SMTPServer.Credentials = new System.Net.NetworkCredential(SMTPUsername, SMTPPassword); //SMTPServer.EnableSsl = true; try { SMTPServer.Send(mailObj); Response.Redirect("EnquiryConfirmation.aspx", false); } catch (Exception ex) { lblError.Text = ex.ToString(); } } catch (Exception exp) { throw new Exception("ERROR: Unable to send mail - " + exp.Message.ToString(), exp); } //Send lead to ZOHO insertZOHOLead(enquiryID.ToString(), body, subject); } }
protected void Page_Load(object sender, EventArgs e) { Response.Clear(); Response.ContentType = "text/xml"; using (XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Encoding.UTF8)) { writer.WriteStartDocument(); writer.WriteStartElement("urlset"); writer.WriteAttributeString("xmlns", "http://www.sitemaps.org/schemas/sitemap/0.9"); writer.WriteStartElement("url"); writer.WriteElementString("loc", "http://www.globalearthmoving.co.za/default.aspx"); writer.WriteElementString("changefreq", "weekly"); writer.WriteElementString("priority", "0"); writer.WriteEndElement(); writer.WriteStartElement("url"); writer.WriteElementString("loc", "http://www.globalearthmoving.co.za/shantui"); writer.WriteElementString("changefreq", "weekly"); writer.WriteElementString("priority", "0.5"); writer.WriteEndElement(); //Get all Shantui products using (GESEntities db = new GESEntities()) { try { var tmpShantui = (from c in db.Shantuis where c.MainPicture == "Y" select c).OrderBy(x => x.MainPictureOrder); foreach (DAL.Shantui tmpShantuiIndex in tmpShantui) { writer.WriteStartElement("url"); writer.WriteElementString("loc", "http://www.globalearthmoving.co.za/Shantui-" + tmpShantuiIndex.Category.Replace(" ","-")); writer.WriteElementString("changefreq", "weekly"); writer.WriteElementString("priority", "0.5"); writer.WriteEndElement(); } } catch (Exception ex) { throw new Exception("ERROR: Unable to Submit Enquiry - " + ex.Message.ToString(), ex); } db.Dispose(); } writer.WriteStartElement("url"); writer.WriteElementString("loc", "http://www.globalearthmoving.co.za/used-equipment"); writer.WriteElementString("lastmod", String.Format("{0:yyyy-MM-dd}", DateTime.Now)); writer.WriteElementString("changefreq", "daily"); writer.WriteElementString("priority", "0.5"); writer.WriteEndElement(); writer.WriteStartElement("url"); writer.WriteElementString("loc", "http://www.globalearthmoving.co.za/tlb-for-sale"); writer.WriteElementString("lastmod", String.Format("{0:yyyy-MM-dd}", DateTime.Now)); writer.WriteElementString("changefreq", "daily"); writer.WriteElementString("priority", "0.5"); writer.WriteEndElement(); writer.WriteStartElement("url"); writer.WriteElementString("loc", "http://www.globalearthmoving.co.za/excavator-for-sale"); writer.WriteElementString("lastmod", String.Format("{0:yyyy-MM-dd}", DateTime.Now)); writer.WriteElementString("changefreq", "daily"); writer.WriteElementString("priority", "0.5"); writer.WriteEndElement(); writer.WriteStartElement("url"); writer.WriteElementString("loc", "http://www.globalearthmoving.co.za/bulldozer-for-sale"); writer.WriteElementString("lastmod", String.Format("{0:yyyy-MM-dd}", DateTime.Now)); writer.WriteElementString("changefreq", "daily"); writer.WriteElementString("priority", "0.5"); writer.WriteEndElement(); writer.WriteStartElement("url"); writer.WriteElementString("loc", "http://www.globalearthmoving.co.za/water-trucks-for-sale"); writer.WriteElementString("lastmod", String.Format("{0:yyyy-MM-dd}", DateTime.Now)); writer.WriteElementString("changefreq", "daily"); writer.WriteElementString("priority", "0.5"); writer.WriteEndElement(); writer.WriteStartElement("url"); writer.WriteElementString("loc", "http://www.globalearthmoving.co.za/compactors-for-sale"); writer.WriteElementString("lastmod", String.Format("{0:yyyy-MM-dd}", DateTime.Now)); writer.WriteElementString("changefreq", "daily"); writer.WriteElementString("priority", "0.5"); writer.WriteEndElement(); writer.WriteStartElement("url"); writer.WriteElementString("loc", "http://www.globalearthmoving.co.za/motor-grader-for-sale"); writer.WriteElementString("lastmod", String.Format("{0:yyyy-MM-dd}", DateTime.Now)); writer.WriteElementString("changefreq", "daily"); writer.WriteElementString("priority", "0.5"); writer.WriteEndElement(); writer.WriteStartElement("url"); writer.WriteElementString("loc", "http://www.globalearthmoving.co.za/dump-truck-for-sale"); writer.WriteElementString("lastmod", String.Format("{0:yyyy-MM-dd}", DateTime.Now)); writer.WriteElementString("changefreq", "daily"); writer.WriteElementString("priority", "0.5"); writer.WriteEndElement(); writer.WriteStartElement("url"); writer.WriteElementString("loc", "http://www.globalearthmoving.co.za/flatbed-truck-for-sale"); writer.WriteElementString("lastmod", String.Format("{0:yyyy-MM-dd}", DateTime.Now)); writer.WriteElementString("changefreq", "daily"); writer.WriteElementString("priority", "0.5"); writer.WriteEndElement(); writer.WriteStartElement("url"); writer.WriteElementString("loc", "http://www.globalearthmoving.co.za/tipper-truck-for-sale"); writer.WriteElementString("lastmod", String.Format("{0:yyyy-MM-dd}", DateTime.Now)); writer.WriteElementString("changefreq", "daily"); writer.WriteElementString("priority", "0.5"); writer.WriteEndElement(); writer.WriteStartElement("url"); writer.WriteElementString("loc", "http://www.globalearthmoving.co.za/wheel-loader-for-sale"); writer.WriteElementString("lastmod", String.Format("{0:yyyy-MM-dd}", DateTime.Now)); writer.WriteElementString("changefreq", "daily"); writer.WriteElementString("priority", "0.5"); writer.WriteEndElement(); writer.WriteStartElement("url"); writer.WriteElementString("loc", "http://www.globalearthmoving.co.za/front-end-loader-for-sale"); writer.WriteElementString("lastmod", String.Format("{0:yyyy-MM-dd}", DateTime.Now)); writer.WriteElementString("changefreq", "daily"); writer.WriteElementString("priority", "0.5"); writer.WriteEndElement(); writer.WriteStartElement("url"); writer.WriteElementString("loc", "http://www.globalearthmoving.co.za/road-roller-for-sale"); writer.WriteElementString("lastmod", String.Format("{0:yyyy-MM-dd}", DateTime.Now)); writer.WriteElementString("changefreq", "daily"); writer.WriteElementString("priority", "0.5"); writer.WriteEndElement(); writer.WriteStartElement("url"); writer.WriteElementString("loc", "http://www.globalearthmoving.co.za/bowser-for-sale"); writer.WriteElementString("lastmod", String.Format("{0:yyyy-MM-dd}", DateTime.Now)); writer.WriteElementString("changefreq", "daily"); writer.WriteElementString("priority", "0.5"); writer.WriteEndElement(); writer.WriteStartElement("url"); writer.WriteElementString("loc", "http://www.globalearthmoving.co.za/tow-tractor-for-sale"); writer.WriteElementString("lastmod", String.Format("{0:yyyy-MM-dd}", DateTime.Now)); writer.WriteElementString("changefreq", "daily"); writer.WriteElementString("priority", "0.5"); writer.WriteEndElement(); //loop thru all used equipment list using (GESEntities db = new GESEntities()) { try { //Get all Used Equipment products var tmpUsed = (from c in db.Machines select c).OrderBy(x => x.MachineID); foreach (DAL.Machine tmpUsedIndex in tmpUsed) { writer.WriteStartElement("url"); writer.WriteElementString("loc", "http://www.globalearthmoving.co.za/UsedEquipmentDetail.aspx?MachineID=" + tmpUsedIndex.MachineID); writer.WriteElementString("lastmod", String.Format("{0:yyyy-MM-dd}", tmpUsedIndex.DateInserted)); writer.WriteElementString("changefreq", "daily"); writer.WriteElementString("priority", "0.5"); writer.WriteEndElement(); } } catch (Exception ex) { throw new Exception("ERROR: Unable to Submit Enquiry - " + ex.Message.ToString(), ex); } db.Dispose(); } writer.WriteStartElement("url"); writer.WriteElementString("loc", "http://www.globalearthmoving.co.za/MyQuip.aspx"); writer.WriteElementString("changefreq", "monthly"); writer.WriteElementString("priority", "0.2"); writer.WriteEndElement(); writer.WriteStartElement("url"); writer.WriteElementString("loc", "http://www.globalearthmoving.co.za/ContactUs.aspx"); writer.WriteElementString("changefreq", "monthly"); writer.WriteElementString("priority", "0.2"); writer.WriteEndElement(); //writer.WriteStartElement("url"); //writer.WriteElementString("loc", "http://www.globalearthmoving.co.za/Enquire.aspx"); //writer.WriteElementString("changefreq", "monthly"); //writer.WriteElementString("priority", "0.2"); //writer.WriteEndElement(); //writer.WriteStartElement("url"); //writer.WriteElementString("loc", "http://www.globalearthmoving.co.za/Account/Login.aspx"); //writer.WriteElementString("changefreq", "monthly"); //writer.WriteElementString("priority", "0.2"); //writer.WriteEndElement(); writer.WriteEndDocument(); writer.Flush(); } Response.End(); }
protected void btnLogin_Click(object sender, EventArgs e) { lblError.Text = ""; string userName = ""; string password = ""; if (txtUserName.Text.ToString().ToUpper() == "ADMIN") { userName = "******"; password = "******"; } //else if (txtUserName.Text.ToString().ToUpper() == "DEMO") //{ // userName = "******"; // password = "******"; //} else { using (GESEntities db = new GESEntities()) { try { string tmpUserName = txtUserName.Text.ToString().ToUpper(); var editUser = (from c in db.Users where c.UserName.ToUpper() == tmpUserName select c).FirstOrDefault(); if (editUser != null) { userName = editUser.UserName; password = editUser.Password; } } catch (Exception exp) { throw new Exception("ERROR: Unable to read from User table - " + exp.Message.ToString(), exp); } } } bool userNameValid = string.Compare(txtUserName.Text.ToString().ToUpper(), userName, true) == 0; bool passwordValid = string.Compare(txtPassword.Text.ToString(), password, false) == 0; if (userNameValid && passwordValid) { //Update User table if (txtUserName.Text.ToString().ToUpper() != "ADMIN") { using (GESEntities db = new GESEntities()) { try { var editUser = (from c in db.Users where c.Email == userName select c).FirstOrDefault(); if (editUser != null) { editUser.LatestLoggedInDate = DateTime.Now; editUser.NumberOfLogins = editUser.NumberOfLogins + 1; db.SaveChanges(); } } catch (Exception exp) { throw new Exception("ERROR: Unable to update user Table - " + exp.Message.ToString(), exp); } } } FormsAuthentication.RedirectFromLoginPage(userName, false); } else { lblError.Text = "Email / Password combination incorrect"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { refreshManufacturerEDS(); string userName = ""; System.Security.Principal.IPrincipal User = HttpContext.Current.User; userName = User.Identity.Name.ToUpper(); if (userName == "ADMIN") { AdminSection.Visible = true; } else { AdminSection.Visible = false; } if (Request["mode"].ToString() == "edit") { using (GESEntities db = new GESEntities()) { try { int machineID = 0; try { Int32.TryParse(Request["machineID"].ToString(), out machineID); } catch { machineID = 0; } //show machine data var getmachineRow = (from p in db.Machines where p.MachineID == machineID select p).FirstOrDefault(); if (getmachineRow != null) { lbManufacturer.SelectedValue = getmachineRow.ManufacturerID.Value.ToString(); tbModel.Text = getmachineRow.ModelName.ToString(); txtMachineDescription.Text = getmachineRow.MachineDescription; txtMachineGrade.Text = getmachineRow.MachineGrade; txtSerial.Text = getmachineRow.SerialNo; txtYear.Text = getmachineRow.Year; txtMileage.Text = getmachineRow.Mileage; txtLocation.Text = getmachineRow.Location; txtContactPerson.Text = getmachineRow.ContactPerson; txtEmailAddress.Text = getmachineRow.EmailAddress; txtContactNumber.Text = getmachineRow.ContactNumber; txtCostPrice.Text = getmachineRow.CostPrice.ToString(); txtSalesPrice.Text = getmachineRow.SellPrice.ToString(); listStatus.SelectedValue = getmachineRow.Status.ToString(); } } catch (Exception exp) { if (exp.Message == "") { throw new Exception("ERROR: Unable to Submit Enquiry - " + exp.InnerException.ToString(), exp); } else { throw new Exception("ERROR: Unable to Submit Enquiry - " + exp.Message.ToString(), exp); } } } } } }