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