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