/// <summary>
/// Saves disbursement too database
/// </summary>
/// <param name="disbursement"></param>0
/// <returns>number of roles affected</returns>
public async Task <int> SaveAsync(Schedule_Dtl schedule)
{
using (Cmd.Connection = Conn)
{
Cmd.CommandType = CommandType.Text;
Cmd.CommandText = "Insert Into Schedule_Dtl (SL_NO, Cust_Code,EMI_Date,Total_Amount,Prn_Amount,Int_Amount,Balance,EMI_St_Date)" +
"Values(@SL_NO,@Cust_Code,@EMI_Date,@Total_Amount,@Prn_Amount,@Int_Amount,@Balance,@EMI_St_Date)";
Cmd.Parameters.AddWithValue("@SL_NO", schedule.SL_NO);
Cmd.Parameters.AddWithValue("@Cust_Code", schedule.Cust_Code);
Cmd.Parameters.AddWithValue("@EMI_Date", schedule.EMI_Date);
Cmd.Parameters.AddWithValue("@Total_Amount", schedule.Total_Amount);
Cmd.Parameters.AddWithValue("@Prn_Amount", schedule.Prn_Amount);
Cmd.Parameters.AddWithValue("@Int_Amount", schedule.Int_Amount);
Cmd.Parameters.AddWithValue("@Balance", schedule.Balance);
Cmd.Parameters.AddWithValue("@EMI_St_Date", schedule.EMS_St_Date);
await Conn.OpenAsync();
return(await Cmd.ExecuteNonQueryAsync());
}
}
/// <summary>
/// prapare the Schedule data and pass to repository method to save to db
/// </summary>
/// <param name="scheduleObj"></param>
/// <returns>the number of rows affected</returns>
public async Task <int> Save(IList <ScheduleResponse> scheduleObj)
{
var i = 0;
foreach (var obj in scheduleObj)
{
var schedule = new Schedule_Dtl
{
Cust_Code = obj.Cust_Code,
EMI_Date = obj.EMI_Date,
Total_Amount = obj.Total_Amount,
Prn_Amount = obj.Prn_Amount,
Balance = obj.Balance,
Int_Amount = obj.Int_Amount,
EMS_St_Date = obj.EMS_St_Date,
SL_NO = obj.SL_NO
};
i += await _scheduleRepository.SaveAsync(schedule);
}
return(i);
}
