public void getEdit() { string message = "{}"; try { string record = this.Request["record"]; Hashtable ht = JavaScriptConvert.DeserializeObject <Hashtable>(record); List <ColumnInfo> parameters = JavaScriptConvert.DeserializeObject <List <ColumnInfo> >(ht["keycolumns"].ToString()); tbsrating obj = JavaScriptConvert.DeserializeObject <tbsrating>(ht["params"].ToString()); List <tbsratdtl> listDtl = JavaScriptConvert.DeserializeObject <List <tbsratdtl> >(ht["dtlparams"].ToString()); List <string> listDeleted = JavaScriptConvert.DeserializeObject <List <string> >(ht["dtldeletedline"].ToString()); bsratingBll bll = new bsratingBll(); bll.UpdateRating(obj, listDtl, listDeleted); message = "{status:'success',msg:'" + HRMSRes.Public_Message_EditWell + "'}"; } catch (Exception ex) { message = "{status:'failure',msg:'" + ExceptionPaser.Parse(HRMSRes.Public_Message_EditBad, ex, true) + "'}"; } Response.Write(message); }
public void CreateRating(tbsrating obj, List <tbsratdtl> listDtl) { try { using (TransactionScope scope = new TransactionScope()) { DoInsert <tbsrating>(obj); for (int i = 0; i < listDtl.Count; i++) { DoInsert <tbsratdtl>(listDtl[i]); } scope.Complete(); } } catch (Exception ex) { throw ex; } }
public void UpdateRating(tbsrating obj, List <tbsratdtl> listDtl, List <string> lstDeleted) { try { using (TransactionScope scope = new TransactionScope()) { List <ColumnInfo> lstParameters = new List <ColumnInfo>() { new ColumnInfo() { ColumnName = "racd", ColumnValue = obj.racd } }; DoUpdate <tbsrating>(obj, lstParameters); //deleted for (int i = 0; i < lstDeleted.Count; i++) { List <ColumnInfo> _parameters = new List <ColumnInfo>() { new ColumnInfo() { ColumnName = "racd", ColumnValue = obj.racd }, new ColumnInfo() { ColumnName = "rtcd", ColumnValue = lstDeleted[i] } }; new BaseBll().DoDelete <tbsratdtl>(_parameters); } //updated & inserted for (int i = 0; i < listDtl.Count; i++) { List <ColumnInfo> _parameters = new List <ColumnInfo>() { new ColumnInfo() { ColumnName = "racd", ColumnValue = obj.racd }, new ColumnInfo() { ColumnName = "rtcd", ColumnValue = listDtl[i].rtcd } }; List <tbsratdtl> lstObj = GetSelectedRecords <tbsratdtl>(_parameters); if (lstObj.Count > 0) { DoUpdate <tbsratdtl>(listDtl[i], _parameters); } else { DoInsert <tbsratdtl>(listDtl[i]); } } scope.Complete(); } } catch (Exception ex) { throw ex; } }