public void AddOt(RequestItem requestitem)
{
using (var db = DBConnection.CreateConnection())
{
db.Open();
var sql = "dbo.ADD_OVERTIME";
var cmd = new SqlCommand(sql, db);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@EMP_ID", requestitem.EMP_ID));
cmd.Parameters.Add(new SqlParameter("@OT_DATE", requestitem.DATE));
cmd.Parameters.Add(new SqlParameter("@PROJECT", requestitem.PROJECT));
cmd.Parameters.Add(new SqlParameter("@REASON", requestitem.REASON));
cmd.Parameters.Add(new SqlParameter("@STATUS", requestitem.STATUS));
cmd.Parameters.Add(new SqlParameter("@TIME_FROM", requestitem.TIME_FROM));
cmd.Parameters.Add(new SqlParameter("@TIME_TO", requestitem.TIME_TO));
cmd.ExecuteNonQuery();
db.Close();
}
}
public void Addleave(RequestItem leaveitem)
{
using (var db = DBConnection.CreateConnection())
{
db.Open();
var sql = "dbo.ADD_LEAVE";
var cmd = new SqlCommand(sql, db);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@EMP_ID", leaveitem.EMP_ID));
cmd.Parameters.Add(new SqlParameter("@LEAVE_DATE", leaveitem.DATE));
cmd.Parameters.Add(new SqlParameter("@TYPE", leaveitem.TYPE));
cmd.Parameters.Add(new SqlParameter("@REASON", leaveitem.REASON));
cmd.Parameters.Add(new SqlParameter("@STATUS", leaveitem.STATUS));
cmd.Parameters.Add(new SqlParameter("@LEAVE_START", leaveitem.LEAVE_START));
cmd.Parameters.Add(new SqlParameter("@LEAVE_END", leaveitem.LEAVE_END));
cmd.ExecuteNonQuery();
db.Close();
}
}
