public void DeleteCalendar(List <ColumnInfo> _parameters) { try { using (TransactionScope scope = new TransactionScope()) { //delete first tatcaldar obj = GetSelectedObject <tatcaldar>(_parameters); List <tatclddtl> oldList = GetSelectedRecords <tatclddtl>(_parameters); for (int i = 0; i < oldList.Count; i++) { dal.DoDelete <tatclddtl>(oldList[i]); } //delete dal.DoDelete <tatcaldar>(obj); scope.Complete(); } } catch (UtilException ex) { throw ex; } catch (Exception ex) { throw new UtilException(ex.Message, ex); } }
public void InsertCalendar(tatcaldar obj, List <tatclddtl> list) { try { using (TransactionScope scope = new TransactionScope()) { //insert DoInsert <tatcaldar>(obj); for (int i = 0; i < list.Count; i++) { DoInsert <tatclddtl>(list[i]); } scope.Complete(); } } catch (UtilException ex) { throw ex; } catch (Exception ex) { throw new UtilException(ex.Message, ex); } }
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()); tatcaldar obj = JavaScriptConvert.DeserializeObject <tatcaldar>(ht["params"].ToString()); List <tatclddtl> listDtl = JavaScriptConvert.DeserializeObject <List <tatclddtl> >(ht["dtlparams"].ToString()); List <string> listDeleted = JavaScriptConvert.DeserializeObject <List <string> >(ht["dtldeletedline"].ToString()); atcaldarBll bll = new atcaldarBll(); bll.UpdateCalendar(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 UpdateCalendar(tatcaldar obj, List <tatclddtl> list, List <string> deleteddobj) { try { using (TransactionScope scope = new TransactionScope()) { //delete first for (int i = 0; i < deleteddobj.Count; i++) { List <ColumnInfo> parameters = new List <ColumnInfo>() { new ColumnInfo() { ColumnName = "clcd", ColumnValue = obj.clcd }, new ColumnInfo() { ColumnName = "cddt", ColumnValue = deleteddobj[i], ColumnType = "datetime" } }; DoMultiDelete <tatclddtl>(parameters); //List<tatclddtl> oldList = GetSelectedRecords<tatclddtl>(parameters); //for (int j = 0; j < oldList.Count; j++) //{ // dal.DoDelete<tatclddtl>(oldList[j]); //} } for (int i = 0; i < list.Count; i++) { List <ColumnInfo> parameters = new List <ColumnInfo>() { new ColumnInfo() { ColumnName = "clcd", ColumnValue = obj.clcd }, new ColumnInfo() { ColumnName = "cddt", ColumnValue = UtilDatetime.FormatDate1(list[i].cddt), ColumnType = "datetime" } }; DoMultiDelete <tatclddtl>(parameters); } List <ColumnInfo> cldParameters = new List <ColumnInfo>() { new ColumnInfo() { ColumnName = "clcd", ColumnValue = obj.clcd } }; //update DoUpdate <tatcaldar>(obj, cldParameters); for (int i = 0; i < list.Count; i++) { dal.DoInsert <tatclddtl>(list[i]); } scope.Complete(); } } catch (UtilException ex) { throw ex; } catch (Exception ex) { throw new UtilException(ex.Message, ex); } }