public List <tbl_DeptLeaveRequest> GetBalanceForSingleEmp(string employeeid, string leaveid) { try { DALBase obj = new DALBase(_config); List <tbl_DeptLeaveRequest> listObj = new List <tbl_DeptLeaveRequest>(); DataSet dt = obj.GetBalanceByEmpIdDept(ConstantStoredProcedure.SP_BCLDB_sp_GetLeaveBalance, employeeid, leaveid); DataTable Dt1 = dt.Tables[0]; if (Dt1.Rows.Count > 0) { int balanceLeave = Convert.ToInt32(Dt1.Rows[0][0]); foreach (var item in Dt1.Rows) { var getBalance = new tbl_DeptLeaveRequest(); getBalance.BalanceLeave = balanceLeave; listObj.Add(getBalance); } } return(listObj); } catch (Exception ex) { throw ex; } }
public List <tbl_DeptLeaveRequest> GetLeaveRequest(string PA, string PSA, string DeptMasterID) { try { DALBase obj = new DALBase(_config); List <tbl_DeptLeaveRequest> listObj = new List <tbl_DeptLeaveRequest>(); DataSet ds = obj.GetLeaveRequestBYIdForDept(ConstantStoredProcedure.SP_GetLeaveRequestMasterDept, PA, PSA, DeptMasterID); DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { foreach (DataRow dtRow in dt.Rows) { var LeaveID = dtRow["LEAVEID"].ToString(); var Descr = dtRow["Description"].ToString(); var objLeave = new tbl_DeptLeaveRequest(); objLeave.LeaveCode = LeaveID; objLeave.LeaveCategory = Descr; listObj.Add(objLeave); } } return(listObj); } catch (Exception ex) { throw ex; } }
public List <tbl_DeptLeaveRequest> GetAutoCompleteList(string search) { try { DALBase obj = new DALBase(_config); List <tbl_DeptLeaveRequest> listObj = new List <tbl_DeptLeaveRequest>(); DataSet ds = obj.GetAutoCompleteList(ConstantStoredProcedure.SP_BCL_GETEMPLOYEENAMEDEPT, search); DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { foreach (DataRow dtRow in dt.Rows) { string[] vals = dtRow["EmpNameId"].ToString().Split('_'); var EmpID = Convert.ToString(vals[0]); var EmpName = Convert.ToString(vals[1]); var objAutoId = new tbl_DeptLeaveRequest(); objAutoId.EmployeeID = EmpID; objAutoId.EmployeeName = EmpName; listObj.Add(objAutoId); } } return(listObj); } catch (Exception ex) { throw ex; } }
public Tuple <string, int> SaveLeaveRequest(tbl_DeptLeaveRequest objleave_request) { try { DALBase obj = new DALBase(_config); List <Tuple <string, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >(); TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_LEAVEID, OracleDbType.Int32, 50, objleave_request.LeavelistId.ToString(), ParameterDirection.Input); TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_FROMDATE, OracleDbType.NVarchar2, 120, Convert.ToString(objleave_request.FromDate), ParameterDirection.Input); TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_TODATE, OracleDbType.NVarchar2, 120, Convert.ToString(objleave_request.ToDate), ParameterDirection.Input); TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_LEAVESHIFT, OracleDbType.NVarchar2, 50, objleave_request.LeaveShift.ToString(), ParameterDirection.Input); //TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_ABSENCEHOUR, OracleDbType.Double, 50, objleave_request.AbsenceCEHour.ToString(), ParameterDirection.Input); TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_APPROVERNAME, OracleDbType.NVarchar2, 1000, objleave_request.ApproverName.ToString(), ParameterDirection.Input); TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_APPROVERID, OracleDbType.NVarchar2, 50, objleave_request.ApproverId.ToString(), ParameterDirection.Input); TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_REMARKS, OracleDbType.NVarchar2, 100, objleave_request.Remarks.ToString(), ParameterDirection.Input); //TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_BALANCELEAVE, OracleDbType.Double, 100, objleave_request.BalanceLeave.ToString(), ParameterDirection.Input); TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_TOTALAPPLIEDLEAVE, OracleDbType.Double, 100, objleave_request.TotalAppliedLeave.ToString(), ParameterDirection.Input); TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EMPLOYEEID, OracleDbType.NVarchar2, 50, objleave_request.EmployeeID.ToString(), ParameterDirection.Input); TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EMPLOYEENAME, OracleDbType.NVarchar2, 1000, objleave_request.EmployeeName.ToString(), ParameterDirection.Input); TupleForOracleParameter(LstTupParameters, "P_MESSAGE", OracleDbType.NVarchar2, 100, null, ParameterDirection.Output); TupleForOracleParameter(LstTupParameters, "P_RETURNVALUE", OracleDbType.Int32, 1, null, ParameterDirection.Output); TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_PA, OracleDbType.NVarchar2, 50, objleave_request.PA.ToString(), ParameterDirection.Input); TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_PSA, OracleDbType.NVarchar2, 50, objleave_request.PSA.ToString(), ParameterDirection.Input); if (objleave_request.UploadFileName == null) { TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_FILENAME, OracleDbType.NVarchar2, 50, null, ParameterDirection.Input); } else { TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_FILENAME, OracleDbType.NVarchar2, 50, objleave_request.UploadFileName.ToString(), ParameterDirection.Input); } TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_CreatedBy, OracleDbType.NVarchar2, 50, objleave_request.CreatedBy.ToString(), ParameterDirection.Input); TupleForOracleParameter(LstTupParameters, "P_AdminID", OracleDbType.NVarchar2, 50, objleave_request.AdminID.ToString(), ParameterDirection.Input); Tuple <string, int> Retunstr = obj.savedata("BCL_TEST_SAVEDEPTLEAVEREQUEST", LstTupParameters); return(Retunstr); } catch (Exception ex) { Tuple <string, int> returndata = new Tuple <string, int>("Failed", 1); return(returndata); throw; } }
public List <tbl_DeptLeaveRequest> GetLeaveDetailsForChange(int objLeaverequestId) { try { DALBase obj = new DALBase(_config); List <tbl_DeptLeaveRequest> objList = new List <tbl_DeptLeaveRequest>(); DataSet ds = obj.GetEmpDetails(ConstantStoredProcedure.SP_BCL_GETLEAVEFORCHNAGE_DEPT, objLeaverequestId); DataTable dt = ds.Tables[0]; if (dt != null) { if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { var objtblLeaveRequest = new tbl_DeptLeaveRequest(); objtblLeaveRequest.LeaveRequestId = Convert.ToString(dt.Rows[i]["LEAVEREQUESTID"]); objtblLeaveRequest.LeaveId = Convert.ToInt32(dt.Rows[i]["LEAVEID"]); objtblLeaveRequest.LeaveCategory = Convert.ToString(dt.Rows[i]["LEAVECATEGORY"]); objtblLeaveRequest.FromDate = Convert.ToDateTime(dt.Rows[i]["FROMDATE"]).ToString("dd/MM/yyyy"); objtblLeaveRequest.ToDate = Convert.ToDateTime(dt.Rows[i]["TODATE"]).ToString("dd/MM/yyyy"); objtblLeaveRequest.LeaveShift = Convert.ToString(dt.Rows[i]["LEAVESHIFT"]); objtblLeaveRequest.ApproverId = Convert.ToString(dt.Rows[i]["APPROVERID"]); objtblLeaveRequest.ApproverName = Convert.ToString(dt.Rows[i]["APPROVERNAME"]); objtblLeaveRequest.AbsenceCEHour = Convert.ToDouble(dt.Rows[i]["ABSENCEHOUR"]); objtblLeaveRequest.Remarks = Convert.ToString(dt.Rows[i]["REMARKS"]); objtblLeaveRequest.EmployeeID = Convert.ToString(dt.Rows[i]["EMPLOYEEID"]); objtblLeaveRequest.PA = Convert.ToString(dt.Rows[i]["PA"]); objtblLeaveRequest.PSA = Convert.ToString(dt.Rows[i]["PSA"]); objtblLeaveRequest.EmployeeName = Convert.ToString(dt.Rows[i]["EMPLOYEENAME"]); objList.Add(objtblLeaveRequest); } } } return(objList); } catch (Exception ex) { throw ex; } }
public tbl_DeptLeaveRequest GetEmpDetails(string EmpID) { DALBase obj = new DALBase(_config); List <tbl_DeptLeaveRequest> listObj = new List <tbl_DeptLeaveRequest>(); List <Tuple <String, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >(); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EMPID, OracleDbType.NVarchar2, 20, EmpID.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EmpDetails, OracleDbType.RefCursor, 20, null, ParameterDirection.Output); DataSet ds = obj.GetDatafromDatabase(ConstantStoredProcedure.SP_BCL_GETEMPDETAILS, LstTupParameters); tbl_DeptLeaveRequest tblempdetails = new tbl_DeptLeaveRequest(); DataTable dt = ds.Tables[0]; if (dt != null && dt.Rows.Count > 0) { tblempdetails.EmployeeName = Convert.ToString(dt.Rows[0]["EMPNAME"]); tblempdetails.Grade = Convert.ToString(dt.Rows[0]["CostCenter"]); tblempdetails.PA = Convert.ToString(dt.Rows[0]["PA"]); tblempdetails.PSA = Convert.ToString(dt.Rows[0]["PSA"]); tblempdetails.ApproverId = Convert.ToString(dt.Rows[0]["ApproverIDName"]); tblempdetails.empPhoneNo = Convert.ToString(dt.Rows[0]["PHONENO"]); listObj.Add(tblempdetails); } return(tblempdetails); }