public static CSQLResult OrnamentsDetailSave(OrnamentsModel ornamentsModel, int ModifiedBy, int ModifiedSourceCode) { CSQLResult oResult = new CSQLResult(); try { CShared oDBShared = new CShared(); DataTable dtImage = new DataTable(); dtImage.Columns.Add("Id", typeof(int)); dtImage.Columns.Add("ImgPath", typeof(string)); ornamentsModel.OrnamentsImgPath.ForEach(element => { dtImage.Rows.Add(new Object[] { Convert.ToInt32(element.IndexOf(element)) + 1, element }); }); string spParameter = ornamentsModel.OrnamentID + "," + ornamentsModel.CategoryID + ", " + ornamentsModel.OrnamentPositionID + ", '" + ornamentsModel.Name + "','" + ornamentsModel.Description + "','" + ornamentsModel.Weight + "'," + ornamentsModel.Cost + "," + dtImage + "," + ModifiedBy + "," + ModifiedBy + "," + ModifiedSourceCode; DataSet dsOrnaments = oDBShared.getSPDataSet("uspOrnamentDetailSave", "@OrnamentID", ornamentsModel.OrnamentID, "@CategoryID", ornamentsModel.CategoryID, "@PositionID", ornamentsModel.OrnamentPositionID, "@Name", ornamentsModel.Name, "@Description", ornamentsModel.Description, "@Weight", ornamentsModel.Weight, "@Cost", ornamentsModel.Cost, "@LogoImgPath", dtImage, "@CreatedBy", ModifiedBy, "@ModifiedBy", ModifiedBy, "@ModifiedSourceCode", ModifiedSourceCode); using (DataTable dtOrnaments = dsOrnaments.Tables["Table"]) { if (dtOrnaments != null && dtOrnaments.Rows.Count > 0) { oResult.Success = Convert.ToBoolean(dtOrnaments.Rows[0]["IsSuccess"]); oResult.Exception = dtOrnaments.Rows[0]["ErrorSuccessMsg"].ToString(); if (oResult.Success) { // SET OTHER PARAMETER INFORMATION //oResult.OtherParameter = dtCompany.Rows[0]["OrgPrjID"].ToString(); } } } } catch (Exception ex) { //oResult.Success = false; //oResult.WasSuccessful = 0; //oResult.Exception = ex.Message; throw ex; } return(oResult); }
public ActionResult Edit(int id) { try { // USED IN POST METHOD ViewBag.IsSuccess = 0; ViewBag.Message = ""; fnSetProperties(); COrnaments ornaments = CFOrnaments.OrnamentsDetailGetById(id); OrnamentsModel objOrnamentsModel = new OrnamentsModel(ornaments); return(View(objOrnamentsModel)); } catch (Exception ex) { return(RedirectToAction("Index", "Error", new { Message = ex.Message, InnerException = ex.InnerException })); } }
public ActionResult Add(OrnamentsModel ornamentsModel) { try { #region # SAVE ORNAMENT IMAGE # string imgDBSavePath = string.Empty; string sfileName = ""; string sFilePath = ""; if (ornamentsModel.OrnamentsImgFile != null) { foreach (HttpPostedFileBase file in ornamentsModel.OrnamentsImgFile) { if (file.ContentLength > 0) { string sFileExt = System.IO.Path.GetExtension(file.FileName); sfileName = ornamentsModel.Name + "-" + DateTime.Now.Ticks + sFileExt; sfileName = sfileName.Replace(" ", String.Empty); imgDBSavePath = DirNameOrnamentImgSave + "/" + sfileName; string CombineServerMapPath = ServerMapPath + DirNameOrnamentImgSave; sFilePath = Server.MapPath(CombineServerMapPath); sFilePath = sFilePath.Replace("\\" + PathRemoveString.ToString(), ""); if (!Directory.Exists(sFilePath)) { DirectoryInfo di = Directory.CreateDirectory(sFilePath); } var path = Path.Combine(sFilePath, sfileName); //SAVE FILE ON DISK file.SaveAs(path); // SET Image PATH ornamentsModel.OrnamentsImgPath.Add(imgDBSavePath); } } } #endregion fnSetProperties(); CSQLResult oResult = CFOrnaments.OrnamentsDetailSave(ornamentsModel, ModifiedBy, LoginTypeCode); if (oResult.Success) { ViewBag.IsSuccess = 1; ViewBag.Message = oResult.Exception; } else { ViewBag.IsSuccess = 0; ViewBag.Message = oResult.Exception; } return(View(ornamentsModel)); } catch (Exception ex) { return(RedirectToAction("Index", "Error", new { Message = ex.Message, InnerException = ex.InnerException, StackTrace = ex.StackTrace })); } }