public void DeleteFormula(List <ColumnInfo> _parameters)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
tprfmular obj = GetSelectedObject <tprfmular>(_parameters);
DoMultiDelete <tprfmudtl>(_parameters);
//delete
dal.DoDelete <tprfmular>(obj);
scope.Complete();
}
}
catch (UtilException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new UtilException(ex.Message, ex);
}
}
public void InsertFormula(tprfmular obj, List <tprfmudtl> list)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
//insert
DoInsert <tprfmular>(obj);
for (int i = 0; i < list.Count; i++)
{
DoInsert <tprfmudtl>(list[i]);
}
scope.Complete();
}
}
catch (UtilException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new UtilException(ex.Message, ex);
}
}
public void getNew()
{
string message = "{}";
try
{
string record = this.Request["record"];
Hashtable ht = JavaScriptConvert.DeserializeObject <Hashtable>(record);
List <ColumnInfo> parameters = JavaScriptConvert.DeserializeObject <List <ColumnInfo> >(ht["keycolumns"].ToString());
tprfmular obj = JavaScriptConvert.DeserializeObject <tprfmular>(ht["params"].ToString());
List <tprfmudtl> listDtl = JavaScriptConvert.DeserializeObject <List <tprfmudtl> >(ht["dtlparams"].ToString());
prfmularBll bll = new prfmularBll();
bll.InsertFormula(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 UpdateFormula(tprfmular obj, List <tprfmudtl> list)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
//delete first
List <ColumnInfo> parameters = new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "frcd", ColumnValue = obj.frcd
}
};
DoMultiDelete <tprfmudtl>(parameters);
//update
dal.DoUpdate <tprfmular>(obj);
for (int i = 0; i < list.Count; i++)
{
dal.DoInsert <tprfmudtl>(list[i]);
}
scope.Complete();
}
}
catch (UtilException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new UtilException(ex.Message, ex);
}
}
