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