public static void DeleteStdSpecialPay(clsStdSpecialPay pay)
{
String connectionString = DataManager.OraConnString();
string query = " delete from std_special_pay where serial_no='" + pay.SerialNo + "'";
DataManager.ExecuteNonQuery(connectionString, query);
}
public static void UpdateStdSpecialPay(clsStdSpecialPay pay)
{
String connectionString = DataManager.OraConnString();
string query = " update std_special_pay set pay_amt= '" + pay.PayAmt + "', from_dt=convert(datetime, '" + pay.FromDt + "',103), to_dt= convert(datetime,'" + pay.ToDt + "',103) " +
" where serial_no='" + pay.SerialNo + "'";
DataManager.ExecuteNonQuery(connectionString, query);
}
public static void CreateStdSpecialPay(clsStdSpecialPay pay)
{
String connectionString = DataManager.OraConnString();
string query = " insert into std_special_pay(student_id, class_id, class_year, pay_id, pay_amt, from_dt, to_dt,serial_no) values (" +
" '" + pay.StudentId + "', '" + pay.ClassId + "', '" + pay.ClassYear + "', " +
" '" + pay.PayId + "','" + pay.PayAmt + "',convert(datetime,'" + pay.FromDt + "',103),convert(datetime,'" + pay.ToDt + "',103),'" + pay.SerialNo + "')";
DataManager.ExecuteNonQuery(connectionString, query);
}
