public void EditDiscount(std_discount mst)
{
try
{
using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
string query = @"UPDATE std_discount
SET
acc_id = @acc_id,
percent = @percent,
bl_exempt = @bl_exempt,
bl_apr = @bl_apr,
bl_may = @bl_may,
bl_jun = @bl_jun,
bl_jul = @bl_jul,
bl_aug = @bl_aug,
bl_sep = @bl_sep,
bl_oct = @bl_oct,
bl_nov = @bl_nov,
bl_dec = @bl_dec,
bl_jan = @bl_jan,
bl_feb = @bl_feb,
bl_mar = @bl_mar,
remark = @std_remarks
WHERE
sr_num = @sr_num AND acc_id = @acc_id
AND session = (SELECT
session
FROM
mst_session
WHERE
session_finalize = 'Y'
AND session_active = 'Y')";
con.Execute(query, mst);
var p = new DynamicParameters();
p.Add("@sr_num", mst.sr_num);
p.Add("@ac_id", mst.acc_id);
con.Execute("stdMiddiscount", p, commandType: System.Data.CommandType.StoredProcedure);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void AddFees(std_discount std)
{
try
{
using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
mst_sessionMain sess = new mst_sessionMain();
string query = @"INSERT INTO std_discount
(session
,sr_num
,acc_id
,percent
,bl_exempt
,bl_apr
,bl_may
,bl_jun
,bl_jul
,bl_aug
,bl_sep
,bl_oct
,bl_nov
,bl_dec
,bl_jan
,bl_feb
,bl_mar
,remark)
VALUES
(@session
,@sr_num
,@acc_id
,@percent
,@bl_exempt
,@bl_apr
,@bl_may
,@bl_jun
,@bl_jul
,@bl_aug
,@bl_sep
,@bl_oct
,@bl_nov
,@bl_dec
,@bl_jan
,@bl_feb
,@bl_mar
,@std_remarks)";
std.session = sess.findActive_finalSession();
con.Execute(query, new
{
std.session,
std.sr_num,
std.acc_id,
std.percent,
std.bl_exempt,
std.bl_apr,
std.bl_may,
std.bl_jun,
std.bl_jul,
std.bl_aug,
std.bl_sep,
std.bl_oct,
std.bl_nov,
std.bl_dec,
std.bl_jan,
std.bl_feb,
std.bl_mar,
std.std_remarks
});
var p = new DynamicParameters();
p.Add("@sr_num", std.sr_num);
p.Add("@ac_id", std.acc_id);
con.Execute("stdMiddiscount", p, commandType: System.Data.CommandType.StoredProcedure);
}
}
catch
{
throw;
}
}