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); }