//Search text box public List <LeaveApprove> autoList(string SEARCHTEXT) { List <LeaveApprove> objlist = new List <LeaveApprove>(); IDbCommand cmd = null; IDbConnection con = null; IDataReader reader; using (con = DataFactory.CreateConnection()) { con.Open(); cmd = con.CreateCommand(); using (cmd = DataFactory.CreateCommand("Sp_ParameterWiseStateList", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(DataFactory.CreateParameter("@SearchText", SEARCHTEXT)); reader = cmd.ExecuteReader(); while (reader.Read()) { LeaveApprove obj = new LeaveApprove(); obj.stateName = Convert.ToString(reader["ParameterName"]); objlist.Add(obj); } return(objlist); } } }
public List <LeaveApprove> LeaveApprovelist(int PageNo, int RowPerPage, string SearchText, int leaveEmployeeID) { IDbConnection con = null; IDbCommand cmd = null; int TotalRecord = 0; LeaveApprove objLeaveApprove; List <LeaveApprove> objlist = new List <LeaveApprove>(); IDataReader reader; using (con = DataFactory.CreateConnection()) { con.Open(); cmd = con.CreateCommand(); using (cmd = DataFactory.CreateCommand("Sp_ApplyFormGrid1", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(DataFactory.CreateParameter("@PageNo", PageNo)); cmd.Parameters.Add(DataFactory.CreateParameter("@RowsPerPage", RowPerPage)); cmd.Parameters.Add(DataFactory.CreateParameter("@SearchText", SearchText)); cmd.Parameters.Add(DataFactory.CreateParameter("@Employeeid", leaveEmployeeID)); reader = cmd.ExecuteReader(); while (reader.Read()) { TotalRecord = Convert.ToInt32(reader["TotalRecords"]); } if (reader.NextResult()) { while (reader.Read()) { objLeaveApprove = new LeaveApprove(); objLeaveApprove.empCode = Convert.ToString(reader["empCode"]); objLeaveApprove.empName = Convert.ToString(reader["empName"]); objLeaveApprove.fromDate = Convert.ToString(reader["fromDate"]); objLeaveApprove.toDate = Convert.ToString(reader["toDate"]); objLeaveApprove.days = Convert.ToDecimal(reader["days"]); objLeaveApprove.leaveTpye = Convert.ToString(reader["LeaveType"]); objLeaveApprove.reason = Convert.ToString(reader["reason"]); objLeaveApprove.ID = Convert.ToInt32(reader["Applyleaveid"]); objLeaveApprove.leaveTpyeId = Convert.ToInt32(reader["leaveTypeid"]); objLeaveApprove.ApproveId = Convert.ToInt32(reader["ApproveID"]); objLeaveApprove.OfficialMailId = Convert.ToString(reader["OfficialMailId"]); objLeaveApprove.EmployeeId = Convert.ToInt32(reader["leaveEmployeeID"]); //objLeave.reason = Convert.ToString(reader["reason"]); objLeaveApprove.totalRecords = TotalRecord; objlist.Add(objLeaveApprove); } } reader.Close(); return(objlist); } } }
public List <LeaveApprove> Approval(int leaveEmployeeId, string fromdate, string todate, decimal days, int leavetypeid, int ApprovedId, string OfficialMailId, string empName, int EmployeeId) { //var conform = "Approved"; IDbConnection conn = null; IDbCommand cmd = null; IDataReader reader; int DBResult = 0; LeaveApprove objLeaveApproval; List <LeaveApprove> objlist = new List <LeaveApprove>(); //Int64 EmpolyeeId = 0; using (conn = DataFactory.CreateConnection()) { conn.Open(); cmd = conn.CreateCommand(); using (cmd = DataFactory.CreateCommand("Sp_CheckLeaveEligibility", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(DataFactory.CreateParameter("@LeaveEmpid", EmployeeId)); cmd.Parameters.Add(DataFactory.CreateParameter("@fromdate", fromdate)); cmd.Parameters.Add(DataFactory.CreateParameter("@toDate", todate)); cmd.Parameters.Add(DataFactory.CreateParameter("@LeaveTypId", leavetypeid)); cmd.Parameters.Add(DataFactory.CreateParameter("@Days", days)); // cmd.ExecuteNonQuery(); reader = cmd.ExecuteReader(); while (reader.Read()) { objLeaveApproval = new LeaveApprove(); DBResult = Convert.ToInt32(reader["result"]); } } reader.Close(); if (DBResult == 1) { using (cmd = DataFactory.CreateCommand("SP_LeaveFormUpdated", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(DataFactory.CreateParameter("@id", ApprovedId)); cmd.Parameters.Add(DataFactory.CreateParameter("@days", days)); //cmd.Parameters.Add(DataFactory.CreateParameter("@EmployeeID", leaveEmployeeId)); cmd.Parameters.Add(DataFactory.CreateParameter("@LeaveTypeId", leavetypeid)); cmd.Parameters.Add(DataFactory.CreateParameter("@EmployeeId", EmployeeId)); cmd.ExecuteNonQuery(); Acceptmail(OfficialMailId, empName, fromdate, todate, days); } } conn.Close(); return(objlist); } }
public List <LeaveApprove> FullListTable(int PageNo, int RowPerPage, string SearchText) { IDbConnection con = null; IDbCommand cmd = null; int TotalRecord = 0; LeaveApprove objLeaveApprove; List <LeaveApprove> objlist = new List <LeaveApprove>(); IDataReader reader; using (con = DataFactory.CreateConnection()) { con.Open(); cmd = con.CreateCommand(); using (cmd = DataFactory.CreateCommand("Sp_LeaveFullList", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(DataFactory.CreateParameter("@PageNo", PageNo)); cmd.Parameters.Add(DataFactory.CreateParameter("@RowsPerPage", RowPerPage)); cmd.Parameters.Add(DataFactory.CreateParameter("@SearchText", SearchText)); reader = cmd.ExecuteReader(); while (reader.Read()) { TotalRecord = Convert.ToInt32(reader["TotalRecords"]); } if (reader.NextResult()) { while (reader.Read()) { objLeaveApprove = new LeaveApprove(); objLeaveApprove.empCode = Convert.ToString(reader["EmployeeCode"]); objLeaveApprove.empName = Convert.ToString(reader["UserName"]); objLeaveApprove.fromDate = Convert.ToString(reader["LeavefromDate"]); objLeaveApprove.toDate = Convert.ToString(reader["LeavetoDate"]); objLeaveApprove.days = Convert.ToDecimal(reader["days"]); objLeaveApprove.leaveTpye = Convert.ToString(reader["LeaveType"]); objLeaveApprove.RemainingDays = Convert.ToDecimal(reader["RemainingDays"]); //objLeave.reason = Convert.ToString(reader["reason"]); objLeaveApprove.totalRecords = TotalRecord; objlist.Add(objLeaveApprove); } } reader.Close(); return(objlist); } } }