public void RetrieveHRPending()
{
using (var db = DBConnection.CreateConnection())
{
db.Open();
var sql = "dbo.GET_HR_PENDING";
var cmd = new SqlCommand(sql, db);
cmd.CommandType = CommandType.StoredProcedure;
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
return;
}
while (reader.Read())
{
var item = new PendingItem();
item.PENDING_ID = (int)reader["PENDING_ID"];
item.EMPID = (int)reader["EMP_ID"];
item.PENDING_NAME = (string)reader["FIRST_NAME"];
item.PENDING_TYPE = (string)reader["PENDING_TYPE"];
item.PENDING_REASON = (string)reader["PENDING_REASON"];
item.PENDING_STATUS = (string)reader["PENDING_STATUS"];
item.PENDING_DATE = (string)reader["PENDING_DATE"];
item.PENDING_POSITION = (string)reader["PENDING_POSITION"];
StaticHRList.HRlist.Add(item);
}
}
}
public void GetPending(int empid)
{
using (var db = DBConnection.CreateConnection())
{
db.Open();
var sql = "dbo.GET_PENDING";
var cmd = new SqlCommand(sql, db);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("EMP_ID", empid));
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
return;
}
while (reader.Read())
{
var item = new PendingItem();
item.PENDING_ID = (int)reader["PENDING_ID"];
item.PENDING_NAME = (string)reader["FIRST_NAME"];
item.PENDING_TYPE = (string)reader["PENDING_TYPE"];
item.PENDING_REASON = (string)reader["PENDING_REASON"];
item.PENDING_STATUS = (string)reader["PENDING_STATUS"];
item.PENDING_DATE = (string)reader["PENDING_DATE"];
item.PENDING_POSITION = (string)reader["PENDING_POSITION"];
item.APPROVED_BY = (string)reader["APPROVED_BY"];
StaticPendingList.staticPendingList.Add(item);
}
db.Close();
}
}
public void SpecificPendingOT(int id, string type)
{
using (var db = DBConnection.CreateConnection())
{
db.Open();
var sql = "dbo.GET_SPECIFIC_PENDING";
var cmd = new SqlCommand(sql, db);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@PENDING_ID", id));
cmd.Parameters.Add(new SqlParameter("@PENDING_TYPE", type));
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
return;
}
while (reader.Read())
{
var item = new PendingItem();
item.PENDING_ID = (int)reader["PENDING_ID"];
item.PENDING_NAME = (string)reader["FIRST_NAME"];
item.PENDING_TYPE = (string)reader["PENDING_TYPE"];
item.PENDING_STATUS = (string)reader["PENDING_STATUS"];
item.PENDING_DATE = (string)reader["PENDING_DATE"];
item.PENDING_POSITION = (string)reader["PENDING_POSITION"];
item.PENDING_OT_FROM = (string)reader["PENDING_OT_FROM"];
item.PENDING_OT_TO = (string)reader["PENDING_OT_TO"];
item.PENDING_OT_REASON = (string)reader["PENDING_REASON"];
StaticApprovalItem.staticApprovalModalItem = item;
}
db.Close();
}
}
public void RetrieveApproved(int id, string sendto)
{
using (var db = DBConnection.CreateConnection())
{
db.Open();
var sql = "dbo.GET_HEAD_APPROVED";
var cmd = new SqlCommand(sql, db);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@EMP_ID", id));
cmd.Parameters.Add(new SqlParameter("@SEND_TO", sendto));
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
return;
}
while (reader.Read())
{
var item = new PendingItem();
item.PENDING_ID = (int)reader["PENDING_ID"];
item.EMPID = (int)reader["EMP_ID"];
item.PENDING_NAME = (string)reader["FIRST_NAME"];
item.PENDING_TYPE = (string)reader["PENDING_TYPE"];
item.PENDING_REASON = (string)reader["PENDING_REASON"];
item.PENDING_STATUS = (string)reader["PENDING_STATUS"];
item.PENDING_DATE = (string)reader["PENDING_DATE"];
item.PENDING_POSITION = (string)reader["PENDING_POSITION"];
StaticApprovalList.staticApprovalList.Add(item);
}
db.Close();
}
}
public void AddPendingOT(PendingItem item, string reason)
{
using (var db = DBConnection.CreateConnection())
{
db.Open();
var sql = "dbo.ADD_PENDING_OT";
var cmd = new SqlCommand(sql, db);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@EMP_ID", item.EMPID));
cmd.Parameters.Add(new SqlParameter("@PENDING_TYPE", item.PENDING_TYPE));
cmd.Parameters.Add(new SqlParameter("@PENDING_REASON", reason));
cmd.Parameters.Add(new SqlParameter("@PENDING_STATUS", item.PENDING_STATUS));
cmd.Parameters.Add(new SqlParameter("@PENDING_DATE", item.PENDING_DATE));
cmd.Parameters.Add(new SqlParameter("@PENDING_POSITION", item.PENDING_POSITION));
cmd.Parameters.Add(new SqlParameter("@PENDING_TIME", item.PENDING_TIME));
cmd.Parameters.Add(new SqlParameter("@PENDING_OT_FROM", item.PENDING_OT_FROM));
cmd.Parameters.Add(new SqlParameter("@PENDING_OT_TO", item.PENDING_OT_TO));
cmd.Parameters.Add(new SqlParameter("@SEND_TO", item.SEND_TO));
cmd.Parameters.Add(new SqlParameter("@APPROVED_BY", item.APPROVED_BY));
cmd.ExecuteNonQuery();
db.Close();
}
}
