public TransactionStatus SaveCharge(tblChargeMain x, List <tblChargeDetails> addedCharges)
{
TransactionStatus stat = new TransactionStatus();
using (IDbConnection conn = new SqlConnection(GetConnstr()))
{
try
{
Guid Id = Guid.NewGuid();
var result = conn.ExecuteScalar("udp_SaveCharge", new
{
Id = Id,
DeptCode = x.DeptCode,
AddedBy = x.AddedBy,
DateAdded = DateTime.Now,
CaseNo = x.CaseNo
}, commandType: CommandType.StoredProcedure);
foreach (var a in addedCharges)
{
conn.Execute("insert into tblChargeDetails(FkIdtblChargeMain,ItemId,Description,Price,Qty)" +
"values(@FkIdtblChargeMain,@ItemId,@Description,@Price,@Qty)", new
{
FkIdtblChargeMain = Id,
ItemId = a.ItemId,
Description = a.Description,
Price = a.Price,
Qty = a.Qty
});
}
stat.status = 1;
stat.message = result.ToString();
stat.param = new
{
Id = Id
};
}
catch (Exception e)
{
stat.status = 0;
stat.message = e.Message;
}
}
return(stat);
}
public HttpResponseMessage SaveCharge([FromBody] dynamic data)
{
tblChargeMain x = new tblChargeMain();
x.CaseNo = data.CaseNo == null ? "" : data.CaseNo.Value;
x.DeptCode = data.DeptCode == null ? "" : data.DeptCode.Value;
x.AddedBy = "comlogik";
x.DateAdded = DateTime.Now;
List <tblChargeDetails> addedCharges = new List <tblChargeDetails>();
var charges = data.addedCharges;
foreach (var a in charges)
{
tblChargeDetails y = new tblChargeDetails();
y.Description = a.Description.ToString();
y.ItemId = a.ItemId.ToString();
y.Qty = Convert.ToInt32(a.Quantity.ToString());
y.Price = Convert.ToDecimal(a.Price.ToString());
addedCharges.Add(y);
}
TransactionStatus stat = repo.SaveCharge(x, addedCharges);
return(Request.CreateResponse(HttpStatusCode.OK, new
{
stat = stat.status,
message = stat.message,
param = stat.param
}));
}
