public int Insert(Services.BillConsumption.BillConsumptionAddViewModel model, ref string ErrorMsg)
{
int ID = 0;
db = new SqlConnection(ConfigurationManager.ConnectionStrings["cnConsumption"].ConnectionString);
decimal BillAmount = model.BillHeader.Consumption * model.BillHeader.Rate;
string sql = " INSERT INTO tblBillConsumption(ContractNo,InvoiceNo,CurrentReadingPeriodFrom,CurrentReadingPeriodTo," +
" CurrentReadingDate,CurrentReading,Consumption,Rate,ServiceCharges,BillAmount,PaidAmount) " +
" VALUES (@ContractNo,@InvoiceNo,@CurrentReadingPeriodFrom,@CurrentReadingPeriodTo," +
" @CurrentReadingDate,@CurrentReading,@Consumption,@Rate,@ServiceCharges,@BillAmount,@PaidAmount)" +
" Select Cast(SCOPE_IDENTITY() AS int)";
try
{
ID = db.Query <int>(sql, new
{
model.CustomerDetail.ContractNo,
model.BillHeader.InvoiceNo,
model.BillHeader.CurrentReadingPeriodFrom,
model.BillHeader.CurrentReadingPeriodTo,
model.BillHeader.CurrentReadingDate,
model.BillHeader.CurrentReading,
model.BillHeader.Consumption,
model.BillHeader.Rate,
model.BillHeader.ServiceCharges,
BillAmount,
model.BillHeader.PaidAmount,
}).SingleOrDefault();
}
catch (Exception e)
{
if (e.Message.IndexOf("IX_tblItem-Name") > 0)
{
ErrorMsg = "Item Already Exist....";
}
else
{
ErrorMsg = e.Message;
}
db.Close();
return(0);
}
return(ID);
}
public int Insert(Services.BillConsumption.BillConsumptionAddViewModel model, ref string ErrorMsg)
{
IRepository = new BillConsumptionRepository();
return(IRepository.Insert(model, ref ErrorMsg));
}
