private string SavePhotoPath(string _adsId, int _order, int _photoId, string _photoPath) { //-- SavePhotoPath //-- Save Photo at the Server Folder and store filepath into Table //-- - if there is no parameter for PhotoId, it's meant for Existing Photos //-- Parameters: //-- _adsId (string) //-- _order (int) //-- _photoId (int) //-- _photoPath (string) //-- Return Value: bool FileUpload fupImageCurrent; try { //-- set current fupImage fupImageCurrent = (FileUpload)PostForm.FindControl("fupAdImg" + _order.ToString()); string photoFileName = Path.GetFileName(fupImageCurrent.FileName); //-- if current filename and new filename are different, then update. else ignore. if (Common.pathPhotosAds + "/" + _adsId + "/" + photoFileName != _photoPath) { //-- Validation on Photo Filetype if (fupImageCurrent.PostedFile.ContentType != "image/jpeg") { throw new Exception("Only JPEG files are accepted!"); } //-- Validation on Photo Filesize if (fupImageCurrent.PostedFile.ContentLength >= 2097152) { throw new Exception("The file has to be less than 2MB"); } //-- If AdsId folder does not exist in Ads Images folder, create string adSpecificFolderPath = "~/" + Common.pathPhotosAds + "/" + _adsId; if (!System.IO.Directory.Exists(Server.MapPath(adSpecificFolderPath))) { System.IO.Directory.CreateDirectory(Server.MapPath(adSpecificFolderPath)); } //-- Delete old photo if (System.IO.File.Exists(Server.MapPath("~/" + _photoPath))) { System.IO.File.Delete(Server.MapPath("~/" + _photoPath)); } //-- Save File into designated server folder, remove first if existing if (System.IO.File.Exists(Server.MapPath(adSpecificFolderPath + "/" + photoFileName))) { System.IO.File.Delete(Server.MapPath(adSpecificFolderPath + "/" + photoFileName)); } fupImageCurrent.SaveAs(Server.MapPath(adSpecificFolderPath + "/" + photoFileName)); //-- Close the file fupImageCurrent.FileContent.Close(); //-- Recreate Parameters, then Update record sqlAdPhotos.UpdateParameters.Clear(); sqlAdPhotos.UpdateParameters.Add("prmPhotoId", _photoId.ToString()); sqlAdPhotos.UpdateParameters.Add("prmCaption", ""); sqlAdPhotos.UpdateParameters.Add("prmPath", Common.pathPhotosAds + "/" + _adsId + "/" + photoFileName); sqlAdPhotos.UpdateParameters.Add("prmOrder", _order.ToString()); //-- Save to Audit Log //-- Update Photos Record sqlAdPhotos.Update(); } return(_photoId.ToString()); } catch (Exception ex) { return(""); } }
private string SavePhotoPath(string _adsId, int _order) { //-- SavePhotoPath //-- Save Photo at the Server Folder and store filepath into Table //-- Parameters: //-- _adsId (string) //-- _order (int) //-- Return Value: bool FileUpload fupImageCurrent; try { //-- set current fupImage fupImageCurrent = (FileUpload)PostForm.FindControl("fupAdImg" + _order.ToString()); //-- Validation on Photo Filetype if (fupImageCurrent.PostedFile.ContentType != "image/jpeg") { throw new Exception("Only JPEG files are accepted!"); } //-- Validation on Photo Filesize if (fupImageCurrent.PostedFile.ContentLength >= 2097152) { throw new Exception("The file has to be less than 2MB"); } //-- If AdsId folder does not exist in Ads Images folder, create string adSpecificFolderPath = "~/" + Common.pathPhotosAds + "/" + _adsId; if (!System.IO.Directory.Exists(Server.MapPath(adSpecificFolderPath))) { System.IO.Directory.CreateDirectory(Server.MapPath(adSpecificFolderPath)); } //-- Save File into designated server folder, remove first if existing string photoFileName = Path.GetFileName(fupImageCurrent.FileName); if (System.IO.File.Exists(Server.MapPath(adSpecificFolderPath + "/" + photoFileName))) { System.IO.File.Delete(Server.MapPath(adSpecificFolderPath + "/" + photoFileName)); } fupImageCurrent.SaveAs(Server.MapPath(adSpecificFolderPath + "/" + photoFileName)); //-- Close the file fupImageCurrent.FileContent.Close(); //-- Get Last Photo Id lastAdPhotoId = int.Parse(Common.GetMaxAdsPhotoId()); //-- Recreate Parameters, then Insert New Record using SqlDataSource object sqlAdPhotos.InsertParameters.Clear(); sqlAdPhotos.InsertParameters.Add("prmPhotoId", (lastAdPhotoId + 1).ToString()); sqlAdPhotos.InsertParameters.Add("prmCaption", ""); sqlAdPhotos.InsertParameters.Add("prmPath", Common.pathPhotosAds + "/" + _adsId + "/" + photoFileName); sqlAdPhotos.InsertParameters.Add("prmOrder", _order.ToString()); //-- Save to Audit Log //-- Insert Ad Mapping Photos Record sqlAdPhotos.Insert(); return((lastAdPhotoId + 1).ToString()); } catch (Exception ex) { return(""); } }
private bool PostSubmit() { //-- PostSubmit //-- Submit Ad Changes and Save into Table //-- Return Value: bool try { //-- Recreate Parameters, then Update Record using SqlDataSource object sqlAdsMain.UpdateParameters.Clear(); sqlAdsMain.UpdateParameters.Add("prmAdTypeId", ddlAdTypes.SelectedValue); sqlAdsMain.UpdateParameters.Add("prmSubCategoryId", ddlSubCategories.SelectedValue); sqlAdsMain.UpdateParameters.Add("prmConditionId", ddlConditions.SelectedValue); sqlAdsMain.UpdateParameters.Add("prmPrice", txtPrice.Text); sqlAdsMain.UpdateParameters.Add("prmTitle", txtTitle.Text); sqlAdsMain.UpdateParameters.Add("prmDescription", txtDescription.Text); if (chkNegotiable.Checked) { sqlAdsMain.UpdateParameters.Add("prmNegotiable", "1"); } else { sqlAdsMain.UpdateParameters.Add("prmNegotiable", "0"); } sqlAdsMain.UpdateParameters.Add("prmAdsId", adsId); //-- TEMP Only - Automatically set to Published if not Reserved or Sold if ((ddlStatus.SelectedValue != "4") && (ddlStatus.SelectedValue != "5")) { sqlAdsMain.UpdateParameters.Add("prmStatus", "2"); } else { sqlAdsMain.UpdateParameters.Add("prmStatus", ddlStatus.SelectedValue); } //-- Save to Audit Log //-- Save Ads Photos (currently maxed at 3) for (int i = 1; i <= Common.maxPhotos; i++) { //-- if a new Photo is uploaded, run SubmitPhoto function FileUpload fupImageCurrent = (FileUpload)PostForm.FindControl("fupAdImg" + i.ToString()); if (fupImageCurrent.HasFile) { PostSubmitPhotos(adsId, i); } //else // DeleteOldPhoto(adsId, i); } //-- Save Ads Details PostSubmitDetails(adsId); //-- Update main Ads Record sqlAdsMain.Update(); return(true); } catch (Exception ex) { return(false); } }