public List <tbl_LeaveRequest> GetLeaveRequest(string PA, string PSA, string Category) { try { DALBase obj = new DALBase(_config); List <tbl_LeaveRequest> listObj = new List <tbl_LeaveRequest>(); tbl_LeaveRequest objLeave = new tbl_LeaveRequest(); DataSet ds = obj.GetLeaveRequestBYId("BCL_TEST_GETLEAVEMASTER", PA, PSA, Category); DataTable dt = ds.Tables[0]; if (dt != null) { objLeave.LeaveCode = ""; objLeave.LeaveCategory = "--Please Select--"; listObj.Add(objLeave); if (dt.Rows.Count > 0) { foreach (DataRow dtRow in dt.Rows) { string LeaveID = dtRow["LEAVEID"].ToString() + "~" + dtRow["Qttype"].ToString() + "~" + dtRow["LEAVECODE"].ToString(); string Descr = dtRow["Description"].ToString(); objLeave = new tbl_LeaveRequest(); objLeave.LeaveCode = LeaveID; objLeave.LeaveCategory = Descr; listObj.Add(objLeave); } } } return(listObj); } catch (Exception ex) { throw ex; } }
public string GetLeaveCode(string LeaveID) { DALBase obj = new DALBase(_config); List <tbl_LeaveRequest> listObj = new List <tbl_LeaveRequest>(); List <Tuple <String, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >(); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_LEAVEID, OracleDbType.NVarchar2, 20, Convert.ToString(LeaveID), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "LeaveCode", OracleDbType.RefCursor, 20, null, ParameterDirection.Output); obj.TupleForOracleParameter(LstTupParameters, "P_RETURNVALUE", OracleDbType.Int32, 20, null, ParameterDirection.Output); DataSet ds = obj.GetDatafromDatabase(ConstantStoredProcedure.SP_BCL_GETLEAVECODE, LstTupParameters); var ReturnVal = Convert.ToInt32((decimal)(OracleDecimal)(obj.cmd.Parameters["P_RETURNVALUE"].Value)); string LeaveCode = ""; if (ReturnVal == 0) { DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { var tblleavereq = new tbl_LeaveRequest(); LeaveCode = dt.Rows[i]["LEAVECODE"].ToString(); } } } else { //string error = "1"; //listObj.Add(error); } return(LeaveCode); }
public Tuple <string, int> UpdateLeaveRequest(tbl_LeaveRequest 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_EMPLOYEEID, OracleDbType.NVarchar2, 50, objleave_request.EmployeeID.ToString(), ParameterDirection.Input); TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_LEAVEREQUESTID, OracleDbType.NVarchar2, 50, objleave_request.LeaveRequestID.ToString(), ParameterDirection.Input); TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_APPROVERNAME, OracleDbType.NVarchar2, 100, objleave_request.ApproverName.ToString(), ParameterDirection.Input); TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_APPROVERID, OracleDbType.NVarchar2, 50, objleave_request.ApproverId.ToString(), ParameterDirection.Input); TupleForOracleParameter(LstTupParameters, "P_MESSAGE", OracleDbType.NVarchar2, 100, null, ParameterDirection.Output); TupleForOracleParameter(LstTupParameters, "P_RETURNVALUE", OracleDbType.Int32, 1, null, ParameterDirection.Output); Tuple <string, int> Retunstr = obj.savedata(ConstantStoredProcedure.SP_BCL_UPDATELEAVEREQUEST, LstTupParameters); return(Retunstr); } catch (Exception ex) { Tuple <string, int> returndata = new Tuple <string, int>("Failed", 1); return(returndata); throw; } }
public Tuple <string, int> SaveLeaveRequest(tbl_LeaveRequest objleave_request) { DALBase obj = new DALBase(_config); objleave_request.LeaveAppliedDate = Convert.ToDateTime(DateTime.Now.Date).ToString("dd/MM/yyyy"); objleave_request.StatusUpdate = Convert.ToDateTime(DateTime.Now.Date).ToString("dd/MM/yyyy"); List <Tuple <string, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >(); TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_LEAVEID, OracleDbType.Int32, 50, Convert.ToString(objleave_request.LeavelistId), 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_LEAVETYPE, OracleDbType.NVarchar2, 50, Convert.ToString(objleave_request.LeaveShift), ParameterDirection.Input); TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_APPROVERID, OracleDbType.NVarchar2, 50, Convert.ToString(objleave_request.ApproverId), ParameterDirection.Input); TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_APPROVERNAME, OracleDbType.NVarchar2, 50, Convert.ToString(objleave_request.ApproverName), ParameterDirection.Input); TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_REMARKS, OracleDbType.NVarchar2, 100, Convert.ToString(objleave_request.Remarks), ParameterDirection.Input); TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_TOTALAPPLIEDLEAVE, OracleDbType.Double, 100, Convert.ToString(objleave_request.TotalAppliedLeave), ParameterDirection.Input); TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_LEAVEAPPLIEDDATE, OracleDbType.NVarchar2, 120, Convert.ToString(objleave_request.LeaveAppliedDate), ParameterDirection.Input); TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EMPLOYEEID, OracleDbType.NVarchar2, 50, Convert.ToString(objleave_request.EmployeeID), ParameterDirection.Input); TupleForOracleParameter(LstTupParameters, "P_MESSAGE", OracleDbType.NVarchar2, 100, null, ParameterDirection.Output); TupleForOracleParameter(LstTupParameters, "P_RETURNVALUE", OracleDbType.Int32, 1, null, ParameterDirection.Output); 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, Convert.ToString(objleave_request.UploadFileName), ParameterDirection.Input); } TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EMPLOYEENAME, OracleDbType.NVarchar2, 50, Convert.ToString(objleave_request.EmployeeName), ParameterDirection.Input); // Tuple<string, int> Retunstr = obj.savedata(ConstantStoredProcedure.SP_BCL_SAVELEAVEREQUEST, LstTupParameters); Tuple <string, int> Retunstr = obj.savedata("BCL_SAVELEAVEREQUEST", LstTupParameters); return(Retunstr); }
public string GetMappingData(string LeaveCode) { DALBase obj = new DALBase(_config); List <tbl_LeaveRequest> listObj = new List <tbl_LeaveRequest>(); List <Tuple <String, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >(); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_LEAVEID, OracleDbType.NVarchar2, 20, LeaveCode, ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "P_QtyType", OracleDbType.RefCursor, 20, null, ParameterDirection.Output); obj.TupleForOracleParameter(LstTupParameters, "P_RETURNVALUE", OracleDbType.Int32, 20, null, ParameterDirection.Output); DataSet ds = obj.GetDatafromDatabase(ConstantStoredProcedure.SPBCL_MAPPINGDATA, LstTupParameters); var ReturnVal = Convert.ToInt32((decimal)(OracleDecimal)(obj.cmd.Parameters["P_RETURNVALUE"].Value)); string Qtytype = ""; if (ReturnVal == 0) { DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { var tblleavereq = new tbl_LeaveRequest(); Qtytype = dt.Rows[i]["QTTYPE"].ToString(); } } } return(Qtytype); }
public List <tbl_LeaveRequest> GetLeaveDetailsForChange(int objLeaverequestId) { try { DALBase obj = new DALBase(_config); List <tbl_LeaveRequest> objList = new List <tbl_LeaveRequest>(); DataSet ds = obj.GetEmpDetails(ConstantStoredProcedure.SP_BCL_GETLEAVEDETAILSFORCHNAGE, 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_LeaveRequest(); 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][8]); objtblLeaveRequest.Remarks = Convert.ToString(dt.Rows[i]["REMARKS"]); objList.Add(objtblLeaveRequest); } } } return(objList); } catch (Exception ex) { throw ex; } }