public void InsertReport(trpexrpdf obj, List <trpexrpdd> list)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
//insert
DoInsert <trpexrpdf>(obj);
for (int i = 0; i < list.Count; i++)
{
DoInsert <trpexrpdd>(list[i]);
}
scope.Complete();
}
}
catch (UtilException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new UtilException(ex.Message, ex);
}
}
public void loadReportDef()
{
string record = this.Request["record"]; //rpcd
rpexrpdpBll bll = new rpexrpdpBll();
trpexrpdf def = bll.GetSelectedObject <trpexrpdf>(new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "rpcd", ColumnValue = record
}
});
List <trpexrpdd> lstDtl = bll.GetSelectedRecords <trpexrpdd>(new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "rpcd", ColumnValue = record
},
new ColumnInfo()
{
ColumnName = "isqr", ColumnValue = "Y"
}
});
string message = "{status:'success',msg:'" + responseJson(def, lstDtl).Replace("'", "\\'") + "'}";
Response.Write(message);
}
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());
trpexrpdf obj = JavaScriptConvert.DeserializeObject <trpexrpdf>(ht["params"].ToString());
List <trpexrpdd> listDtl = JavaScriptConvert.DeserializeObject <List <trpexrpdd> >(ht["dtlparams"].ToString());
rpexrpdfBll bll = new rpexrpdfBll();
bll.InsertReport(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);
}
private string responseJson(trpexrpdf def, List <trpexrpdd> lstDtl)
{
StringBuilder json = new StringBuilder();
string columnCfg = columnsJson(lstDtl);
json.Append("{")
.Append("columns:").Append(columnCfg).Append(",")
.Append("rpcd:\"").Append(def.rpcd).Append("\"").Append("")
.Append("}");
return(json.ToString());
}
public void UpdateReport(trpexrpdf obj, List <trpexrpdd> list)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
//delete first
List <ColumnInfo> parameters = new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "rpcd", ColumnValue = obj.rpcd
}
};
//DoMultiDelete<tatrosdtl>(parameters);
List <trpexrpdd> oldList = GetSelectedRecords <trpexrpdd>(parameters);
for (int i = 0; i < oldList.Count; i++)
{
DoDelete <trpexrpdd>(oldList[i]);
}
//update
DoUpdate <trpexrpdf>(obj, parameters);
for (int i = 0; i < list.Count; i++)
{
DoInsert <trpexrpdd>(list[i]);
}
scope.Complete();
}
}
catch (UtilException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new UtilException(ex.Message, ex);
}
}
public void DeleteReport(List <ColumnInfo> _parameters)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
trpexrpdf obj = GetSelectedObject <trpexrpdf>(_parameters);
DoMultiDelete <trpexrpdd>(_parameters);
DoDelete <trpexrpdf>(obj);
scope.Complete();
}
}
catch (UtilException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new UtilException(ex.Message, ex);
}
}
private void LoadData(string rpcd, List <ColumnInfo> lstParameters)
{
BaseBll bll = new BaseBll();
trpexrpdf def = bll.GetSelectedObject <trpexrpdf>(new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "rpcd", ColumnValue = rpcd
}
});
List <trpexrpdd> lstDtl = bll.GetSelectedRecords <trpexrpdd>(new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "rpcd", ColumnValue = rpcd
}
});
rpexrpdpBll rpbll = new rpexrpdpBll();
DataSet ds = null;
switch (def.rpty)
{
case "Personnel":
ds = rpbll.GetPersonalData(rpcd, lstDtl, lstParameters);
break;
case "Payroll":
ds = rpbll.GetPayrollData(rpcd, lstDtl, lstParameters);
break;
case "PayrollBankAlloc":
ds = rpbll.GetPayrollBankAllocData(rpcd, lstDtl, lstParameters);
break;
}
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
//Title
this.GridView1.Caption = "<B>" + def.rptt + "</B>";
this.GridView1.DataSource = ds;
this.GridView1.DataBind();
//Merge Column
MergeGridView mergeGV = new MergeGridView();
for (int i = 0; i < lstDtl.Count; i++)
{
if (lstDtl[i].isme == "Y")
{
mergeGV.Merge(this.GridView1, i);
}
}
//Summary
var q = (from p in lstDtl
where p.issu == "Y"
select p).ToList();
for (int i = 0; i < q.Count; i++)
{
//GridViewSummary sum = new GridViewSummary(q[i].itnm, SummaryOperation.Sum);
}
}
else
{
}
}
