public void ImportImage(FileUpload file) { DataAccess dacess = new DataAccess(); DateTime date = Utility.GetCurrentDateTimeinUTC(); string VendorCat = drpVendorcategory.SelectedItem.Text; string Vendorname = txtvendorname.Text; String contact = txtvendromobile.Text; String Address = txtvendoraddress.Text; try { int VendorID = Convert.ToInt32(HiddenVendorEditID.Value); String VendorName = HiddenVendorName.Value; if (file.HasFile) { string base64 = Request.Form["imgCropped"]; byte[] bytesImages = Convert.FromBase64String(base64.Split(',')[1]); String Savepath = Request.PhysicalApplicationPath + "ImageServer\\Vendor\\"; //Check if size is less than 2 MB if (bytesImages.Length < 2097152) { VendorController vendorController = new VendorController(); bool result = vendorController.AddImage(bytesImages, VendorID, Savepath); if (result) { lblstatus.Text = ""; } else { lblstatus.Text = "Error Saving Image. Try again"; } } else { lblstatus.Text = "Select smaller Image"; } } else { ClientScript.RegisterStartupScript(this.GetType(), "alert()", "alert('Please Select a image to upload')", true); } } catch (Exception ex) { } finally { RemoveFiles(); } }
private void EditVendor() { DataAccess dacess = new DataAccess(); // DateTime Updatedate = System.DateTime.Now; DateTime Updatedate = Utility.GetCurrentDateTimeinUTC(); String NewvendorQuery = null; VendorController vendorController = new VendorController(); try { int VendorID = Convert.ToInt32(HiddenVendorEditID.Value); String VendorName = HiddenVendorName.Value; if (checkEditVendor.Checked) { Vendor editVendor = new Vendor(); editVendor.ID = VendorID; editVendor.ShopCategoryID = Convert.ToInt32(drpVendorcategory.SelectedItem.Value); editVendor.VendorName = txtvendorname.Text; editVendor.ContactNumber = txtMobile2.Text; editVendor.ContactNumber2 = txtvendromobile.Text; editVendor.Address = txtvendoraddress.Text; editVendor.Address2 = txtvendoraddress2.Text; vendorController.UpdateVendor(editVendor); } if (FileVendorImg.HasFile) { string base64 = Request.Form["imgCropped"]; byte[] bytesImages = Convert.FromBase64String(base64.Split(',')[1]); String Savepath = Request.PhysicalApplicationPath + "ImageServer\\Vendor\\"; //Check if size is less than 2 MB if (bytesImages.Length < 2097152) { bool result = vendorController.AddImage(bytesImages, VendorID, Savepath); if (result) { lblstatus.Text = ""; } else { lblstatus.Text = "Error Saving Image. Try again"; } } else { lblstatus.Text = "Select smaller Image"; } } else { ClientScript.RegisterStartupScript(this.GetType(), "alert()", "alert('Please Select a image to upload')", true); } } catch (Exception ex) { int a = 1; } }
protected void btnNewvendor_Click(object sender, EventArgs e) { if (HiddenVendorEditID.Value != "" && HiddenVendorName.Value != "") { EditVendor(); return; } else if (HiddenVendorEditID.Value == "" && HiddenVendorName.Value == "") { DataAccess dacess = new DataAccess(); System.Drawing.Image EditedImage = null; System.Drawing.Image image = null; //DateTime date = System.DateTime.Now; Vendor newVendor = new Vendor(); DateTime date = Utility.GetCurrentDateTimeinUTC(); newVendor.ShopCategoryID = Convert.ToInt32(drpVendorcategory.SelectedItem.Value); newVendor.VendorName = txtvendorname.Text; newVendor.IconFormat = FileVendorImg.PostedFile.ContentType; newVendor.ContactNumber = txtvendromobile.Text; newVendor.ContactNumber2 = txtMobile2.Text; newVendor.Address = txtvendoraddress.Text; newVendor.Address2 = txtvendoraddress2.Text; newVendor.InsertDate = Utility.GetCurrentDateTimeinUTC(); try { if (FileVendorImg.HasFile) { if (FileVendorImg.PostedFile.ContentLength > 20728650) { lblstatus.Text = "Image Size is large, Please select smaller Image"; return; } } VendorController vendorController = new VendorController(); int VendorID = vendorController.AddVendor(newVendor); if (VendorID > 0) { if (FileVendorImg.HasFile) { String Savepath = Request.PhysicalApplicationPath + "Images/Vendor"; //FileVendorImg.SaveAs(Savepath + FileVendorImg.FileName); //image = System.Drawing.Image.FromFile(Savepath + FileVendorImg.FileName); string imagename = Path.GetFileNameWithoutExtension(FileVendorImg.FileName); string base64 = Request.Form["imgCropped"]; byte[] bytesImages = Convert.FromBase64String(base64.Split(',')[1]); vendorController.AddImage(bytesImages, VendorID, Savepath); } else { FillVendorDataList(muser.currentResident.SocietyID, muser.currentResident.UserType); ClientScript.RegisterStartupScript(this.GetType(), "alert('')", "CloseAddVendor()", true); } } else { lblstatus.Text = "Vendor Added Failed"; } } /* * try * { * //Condition to check if the file uploaded or not * if (FileVendorImg.HasFile) * { * if (FileVendorImg.PostedFile.ContentLength < 20728650) * { * //Save the image to local folder * String Savepath = Request.PhysicalApplicationPath + "Images/Vendor"; * //FileVendorImg.SaveAs(Savepath + FileVendorImg.FileName); * //image = System.Drawing.Image.FromFile(Savepath + FileVendorImg.FileName); * * string imagename = Path.GetFileNameWithoutExtension(FileVendorImg.FileName); * * * string base64 = Request.Form["imgCropped"]; * byte[] bytesImages = Convert.FromBase64String(base64.Split(',')[1]); * * * * * using (SqlConnection con1 = new SqlConnection(Utility.SocietyConnectionString)) * { * con1.Open(); * // SqlCommand cmd = new SqlCommand("INSERT INTO Vendors (ShopCategory,VendorName,ContactNumber,Address,VendorIcon,VendorIconFormat) VALUES (@ShopCategory,@VendorName,@ContactNum,@Address,@VendorIcon,@VendorIconFormat)", con1); * SqlCommand cmd = new SqlCommand("Insert Into Vendors (ShopCategory,VendorName,ContactNumber,ContactNumber2,Address,Address2,VendorIcon,VendorIconFormat,date,SocietyID,CmdType) Values ('" + VendorCat + "','" + Vendorname + "','" + contact + "','" + contact2 + "','" + Address + "','" + Address2 + "',@VendorIcon,'" + VendorIconFormat + "','" + Utility.ChangeDateTimeLocalToSQLServerFormat(date) + "'," + SessionVariables.SocietyID + ",'Insert')", con1); + cmd.Parameters.Add("@VendorIcon", SqlDbType.Image).Value = bytesImages; + int count = cmd.ExecuteNonQuery(); + con1.Close(); + + if (count == 1) + { + + FillVendorDataList(muser.currentResident.SocietyID,muser.currentResident.UserType); + + } + + else + { + ClientScript.RegisterStartupScript(this.GetType(), "alert('')", "VendorActionPopup()", true); + lblstatus.Text = "Vendor Added Failed"; + // lblVendrAuctionlMsg.Text = "Vendor Added Failed"; + } + } + } + } + else + { + String InsetdataQuery = "Insert Into Vendors (ShopCategory,VendorName,ContactNumber,ContactNumber2,Address,Address2,date,SocietyID, CmdType) Values ('" + VendorCat + "','" + Vendorname + "','" + contact + "','" + contact2 + "','" + Address + "','" + Address2 + "','" + Utility.ChangeDateTimeLocalToSQLServerFormat(date) + "'," + SessionVariables.SocietyID + ",'insert')"; + bool result = dacess.Update(InsetdataQuery); + + if (result == true) + { + Response.AddHeader("REFRESH", "50;URL=Vendors.aspx"); + Response.Redirect("Vendors.aspx", false); + } + + else + { + ClientScript.RegisterStartupScript(this.GetType(), "alert('')", "Showpopup()", true); + lblstatus.Text = "Vendor Added Failed"; + } + } + + } */ catch (Exception ex) { lblstatus.Text = ex.Message; } finally { // EditedImage.Dispose(); // image.Dispose(); RemoveFiles(); } } }