public JsonResult delete_IPBill_Correction(int serid, long billno, ARIPBillDelParams IPB)
{
IPBillCorrectionDB _DB = new IPBillCorrectionDB();
if (_DB.delete_ipbill_corrections(OperatorId, serid, billno, IPB))
{
return(Json(new { rcode = 0, rmsg = _DB.retmsg }));
}
else
{
return(Json(new { rcode = _DB.ret, rmsg = _DB.retmsg }));
}
}
/* Delete IP Bill Item */
public bool delete_ipbill_corrections(int opeid, int serid, long billno, ARIPBillDelParams IPB)
{
try
{
//spoken language
DataTable dtIPBILL = new DataTable();
dtIPBILL.Columns.AddRange(new[] {
new DataColumn("ItemId", typeof(long)),
new DataColumn("SLNo", typeof(long)),
new DataColumn("CanRe", typeof(int))
});
System.IO.StringWriter dt = new System.IO.StringWriter();
if (IPB.dellistparams != null && IPB.dellistparams.Count > 0)
{
var items = IPB.dellistparams.Select(i => new ARIPBillDelItemList
{
ItemId = i.ItemId,
SLNo = i.SLNo,
CanRe = i.CanRe
}).ToList();
foreach (var item in items)
{
DataRow newRow = dtIPBILL.NewRow();
newRow["ItemId"] = item.ItemId;
newRow["SLNo"] = item.SLNo;
newRow["CanRe"] = item.CanRe;
dtIPBILL.Rows.Add(newRow);
}
dtIPBILL.TableName = "DTXMLDATA";
dtIPBILL.WriteXml(dt);
}
DB.param = new SqlParameter[] {
new SqlParameter("@serid", serid),
new SqlParameter("@billno", billno),
new SqlParameter("@opeid", opeid),
new SqlParameter("@XMLDATA", dt == null ? (object)DBNull.Value : dt.ToString()),
};
//DB.param[75].Direction = ParameterDirection.Output;
DB.ExecuteSPAndReturnDataTable("ARIPBILLING.delete_ipbill_item");
// this.QResult = DB.param[75].Value.ToString();
//this.ErrorMessage = DB.param[7].Value.ToString();
// if (!string.IsNullOrEmpty(DB.param[7].Value.ToString()))
// return false;
ret = 0;
retmsg = "Item Successfully Deleted!";
return(true);
}
catch (Exception ex)
{
ret = -1;
retmsg = ex.Message;
eLOG.LogError(ex);
return(false);
throw new ApplicationException("Error Message:</b> <br /> " + ex.Message + "<br /><br /><b>Stack Trace:</b><br /> " + ex.StackTrace);
}
}
