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 }));
}
}
