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