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());
tprpubrst obj = JavaScriptConvert.DeserializeObject <tprpubrst>(ht["params"].ToString());
List <tprprsdtl> listDtl = JavaScriptConvert.DeserializeObject <List <tprprsdtl> >(ht["dtlparams"].ToString());
prpubrstBll bll = new prpubrstBll();
bll.UpdatePubRuleSet(obj, listDtl);
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 InsertPubRuleSet(tprpubrst obj, List <tprprsdtl> list)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
//insert
DoInsert <tprpubrst>(obj);
for (int i = 0; i < list.Count; i++)
{
string rlcd = UtilDatetime.FormatTime4(DateTime.Now);
if (list[i].vtyp == "Sum")
{
list[i].rlcd = rlcd;
}
DoInsert <tprprsdtl>(list[i]);
if (list[i].vtyp == "Sum")
{
string[] arr = list[i].valu.Split(',');
for (int j = 0; j < arr.Length; j++)
{
tprrstsit sit = new tprrstsit();
sit.itcd = arr[j].Substring(1, arr[j].Length - 2);
sit.lmtm = list[i].lmtm;
sit.lmur = list[i].lmur;
sit.rlcd = rlcd;
DoInsert <tprrstsit>(sit);
}
}
}
scope.Complete();
}
}
catch (UtilException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new UtilException(ex.Message, ex);
}
}
public void UpdatePubRuleSet(tprpubrst obj, List <tprprsdtl> list)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
//delete first
List <ColumnInfo> parameters = new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "rscd", ColumnValue = obj.rscd
}
};
List <tprprsdtl> lstDtl = GetSelectedRecords <tprprsdtl>(parameters);
for (int i = 0; i < lstDtl.Count; i++)
{
if (lstDtl[i].vtyp == "Sum")
{
//delete rel item
List <ColumnInfo> relparams = new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "rlcd", ColumnValue = lstDtl[i].rlcd
}
};
DoMultiDelete <tprrstsit>(relparams);
}
DoDelete <tprprsdtl>(lstDtl[i]);
}
//update
dal.DoUpdate <tprpubrst>(obj);
for (int i = 0; i < list.Count; i++)
{
string rlcd = UtilDatetime.FormatTime4(DateTime.Now);
if (list[i].vtyp == "Sum")
{
list[i].rlcd = rlcd;
}
dal.DoInsert <tprprsdtl>(list[i]);
if (list[i].vtyp == "Sum")
{
string[] arr = list[i].valu.Split(',');
for (int j = 0; j < arr.Length; j++)
{
tprrstsit sit = new tprrstsit();
sit.itcd = arr[j].Substring(1, arr[j].Length - 2);
sit.lmtm = list[i].lmtm;
sit.lmur = list[i].lmur;
sit.rlcd = rlcd;
DoInsert <tprrstsit>(sit);
}
}
}
scope.Complete();
}
}
catch (UtilException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new UtilException(ex.Message, ex);
}
}
