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