public string ValidateMifareID(string Mifareid, string datafrom) { DALBase obj = new DALBase(_config); List <Tuple <String, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >(); obj.TupleForOracleParameter(LstTupParameters, "P_DATAFROM", OracleDbType.NVarchar2, 20, datafrom, ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "P_MifareID", OracleDbType.NVarchar2, 20, Mifareid.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "P_RETURNVALUE", OracleDbType.Int32, 20, null, ParameterDirection.Output); obj.TupleForOracleParameter(LstTupParameters, "P_Empdetails", OracleDbType.RefCursor, 20, null, ParameterDirection.Output); DataSet ds = obj.GetDatafromDatabase("BCL_VALIDATEMIFAREID", LstTupParameters); var RetunVal = Convert.ToInt32(Convert.ToString(obj.cmd.Parameters["p_returnvalue"].Value)); string empid = ""; if (RetunVal == 0) { DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { empid = Convert.ToString(dt.Rows[0]["EMPID"]); } } if (RetunVal == 2 || RetunVal == 1) { empid = RetunVal.ToString(); } return(empid); }
public tbl_OTPG Getotp(string employeeid, string fromdata) { DALBase obj = new DALBase(_config); List <Tuple <String, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >(); tbl_OTPG listObj = new tbl_OTPG(); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EMPID, OracleDbType.Varchar2, 20, employeeid.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_OTP, OracleDbType.RefCursor, 20, null, ParameterDirection.Output); obj.TupleForOracleParameter(LstTupParameters, "P_DATAFROM", OracleDbType.NVarchar2, 20, fromdata, ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "P_RETURNMSG", OracleDbType.NVarchar2, 20, null, ParameterDirection.Output); DataSet ds = obj.GetDatafromDatabase("BCL_TEST_GETOTP", LstTupParameters); string RetunMsg = (obj.cmd.Parameters["P_RETURNMSG"].Value.ToString()); if (RetunMsg == "Reset" || RetunMsg == "null" || RetunMsg == "NotExist") { DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { listObj.OTP = Convert.ToInt32(dt.Rows[0][0]); listObj.OTPEndtime = Convert.ToDateTime(dt.Rows[0][1]); listObj.DateOfBirth = Convert.ToDateTime(dt.Rows[0][2]); listObj.ReturnMsg = RetunMsg; } } else { listObj.ReturnMsg = RetunMsg; } return(listObj); }
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 Tuple <string, int> SaveOTP(List <tbl_OTPG> tbl_Otps) { try { DALBase obj = new DALBase(_config); List <Tuple <string, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >(); foreach (var l in tbl_Otps) { obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EMPID, OracleDbType.NVarchar2, 50, l.EmployeeID.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_OTP, OracleDbType.Int32, 100, l.OTP.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "P_MESSAGE", OracleDbType.NVarchar2, 100, null, ParameterDirection.Output); obj.TupleForOracleParameter(LstTupParameters, "P_RETURNVALUE", OracleDbType.Int32, 1, null, ParameterDirection.Output); obj.TupleForOracleParameter(LstTupParameters, "v_IsPreviousPass", OracleDbType.Int32, 1, null, ParameterDirection.Output); } Tuple <string, int> Retunstr = obj.savedata(ConstantStoredProcedure.SP_SaveOTPGEN, LstTupParameters); // var statusoftrans = 0; // Tuple<string, int> returndata = new Tuple<string, int>("Success", 0); return(Retunstr); } catch (Exception ex) { Tuple <string, int> returndata = new Tuple <string, int>("Failed", 1); return(returndata); throw; } }
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 string GetMappingData(string LeaveCode) //{ // DALBase obj = new DALBase(_config); // // int ApproverId = tblapprover.ApproverId; // 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("BCL_MAPPINGDATAFORAPPROVAL", 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][0].ToString(); // } // } // } // else // { // //string error = "1"; // //listObj.Add(error); // } // return Qtytype; //} public List <tbl_LeaveApproval> GetLeaveApprovals(string ApproverId) { DALBase obj = new DALBase(_config); // int ApproverId = tblapprover.ApproverId; List <tbl_LeaveApproval> listObj = new List <tbl_LeaveApproval>(); List <Tuple <String, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >(); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_APPROVERID, OracleDbType.NVarchar2, 20, ApproverId.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "P_RETURNDATA", OracleDbType.RefCursor, 20, null, ParameterDirection.Output); obj.TupleForOracleParameter(LstTupParameters, "P_RETURNVALUE", OracleDbType.Int32, 1, null, ParameterDirection.Output); //DataSet ds = obj.GetDatafromDatabase(ConstantStoredProcedure.SP_BCL_GetLeaveForApproval, LstTupParameters); DataSet ds = obj.GetDatafromDatabase("BCL_TEST_GETLEAVEFORAPPROVAL", LstTupParameters); var ReturnVal = Convert.ToInt32((decimal)(OracleDecimal)(obj.cmd.Parameters["P_RETURNVALUE"].Value)); if (ReturnVal == 0) { DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { var tblleaveapproval = new tbl_LeaveApproval(); tblleaveapproval.LeaveRequestId = Convert.ToInt32(dt.Rows[i][0]); tblleaveapproval.LeaveId = Convert.ToInt32(dt.Rows[i][1]); tblleaveapproval.LeaveCode = dt.Rows[i][2].ToString(); tblleaveapproval.FromDate = Convert.ToDateTime(dt.Rows[i][3]); tblleaveapproval.FromDateString = tblleaveapproval.FromDate.ToString("dd/MM/yyyy"); tblleaveapproval.ToDate = Convert.ToDateTime(dt.Rows[i][4]); tblleaveapproval.ToDateString = tblleaveapproval.ToDate.ToString("dd/MM/yyyy"); tblleaveapproval.LeaveShift = dt.Rows[i][5].ToString(); tblleaveapproval.Remarks = dt.Rows[i][6].ToString(); tblleaveapproval.Status = dt.Rows[i][7].ToString(); tblleaveapproval.TotalLeaves = Convert.ToDouble(dt.Rows[i][8]); tblleaveapproval.LeaveAppliedDate = Convert.ToDateTime(dt.Rows[i][9]); tblleaveapproval.LeaveAppliedDateString = tblleaveapproval.LeaveAppliedDate.ToString("dd/MM/yyyy"); tblleaveapproval.EmployeeID = Convert.ToString(dt.Rows[i][10]); tblleaveapproval.EmployeeName = dt.Rows[i][11].ToString(); tblleaveapproval.LeaveCategory = dt.Rows[i][12].ToString(); if (dt.Rows[i][13].ToString() != null) { tblleaveapproval.FileName = dt.Rows[i][13].ToString(); } //tblleaveapproval.FromData = dt.Rows[i][19].ToString(); listObj.Add(tblleaveapproval); } } } else if (ReturnVal == 1 || ReturnVal == 2) { var tbleaveappr = new tbl_LeaveApproval(); tbleaveappr.ReturnValue = ReturnVal; listObj.Add(tbleaveappr); } return(listObj); }
public Tuple <string, int> SaveApproverFromSAP(List <tbl_LeaveApproval> Approverdata) { try { DALBase obj = new DALBase(_config); List <Tuple <string, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >(); foreach (var l in Approverdata) { if (l.ApproverMailID == null) { l.ApproverMailID = "EmailID not Updated"; } obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_APPROVERID, OracleDbType.NVarchar2, 50, l.ApproverId.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_APPROVERNAME, OracleDbType.NVarchar2, 1000, l.ApproverName.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EMAILID, OracleDbType.NVarchar2, 100, l.ApproverMailID, ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_PHONENO, OracleDbType.Varchar2, 100, l.ApproverMobNo, ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "P_HODID", OracleDbType.Varchar2, 100, l.HODID, ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "P_HODName", OracleDbType.Varchar2, 100, l.HODName, ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "P_HODMailID", OracleDbType.Varchar2, 100, l.HODMailID, ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "P_MESSAGE", OracleDbType.NVarchar2, 100, null, ParameterDirection.Output); obj.TupleForOracleParameter(LstTupParameters, "P_RETURNVALUE", OracleDbType.Int32, 1, null, ParameterDirection.Output); } Tuple <string, int> Returnstr = obj.savedata("BCL_SaveApproverMaster", LstTupParameters); return(Returnstr); } catch (Exception ex) { Tuple <string, int> returndata = new Tuple <string, int>("Failed", 1); return(returndata); throw; } }
public List <tbl_Leavewithdrawal> GetLeavesforWithdrawal(string EmployeeId) { try { DALBase obj = new DALBase(_config); List <tbl_Leavewithdrawal> listObj = new List <tbl_Leavewithdrawal>(); List <Tuple <String, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >(); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EMPLOYEEID, OracleDbType.NVarchar2, 20, EmployeeId.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "P_RETURNDATA", OracleDbType.RefCursor, 20, null, ParameterDirection.Output); obj.TupleForOracleParameter(LstTupParameters, "P_RETURNVALUE", OracleDbType.Int32, 1, null, ParameterDirection.Output); DataSet ds = obj.GetDatafromDatabase("BCL_TEST_GETLEAVEFORWITHDRAWAL", LstTupParameters); var ReturnVal = Convert.ToInt32((decimal)(OracleDecimal)(obj.cmd.Parameters["P_RETURNVALUE"].Value)); if (ReturnVal == 0) { DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { var tblleavewithdrawal = new tbl_Leavewithdrawal(); tblleavewithdrawal.LeaveRequestId = Convert.ToInt32(dt.Rows[i]["LEAVEREQUESTID"]); tblleavewithdrawal.LeaveId = Convert.ToInt32(dt.Rows[i]["LEAVEID"]); tblleavewithdrawal.LeaveCode = Convert.ToString(dt.Rows[i]["LEAVECODE"]); tblleavewithdrawal.FromDate = Convert.ToDateTime(dt.Rows[i]["FROMDATE"]); tblleavewithdrawal.FromDateString = tblleavewithdrawal.FromDate.ToString("dd/MM/yyyy").Replace('-', '/'); tblleavewithdrawal.ToDate = Convert.ToDateTime(dt.Rows[i]["TODATE"]); tblleavewithdrawal.ToDateString = tblleavewithdrawal.ToDate.ToString("dd/MM/yyyy").Replace('-', '/'); tblleavewithdrawal.LeaveShift = Convert.ToString(dt.Rows[i]["LEAVESHIFT"]); tblleavewithdrawal.ApproverName = Convert.ToString(dt.Rows[i]["APPROVERNAME"]); tblleavewithdrawal.ApproverId = Convert.ToString(dt.Rows[i]["APPROVERID"]); tblleavewithdrawal.Status = Convert.ToString(dt.Rows[i]["STATUS"]); tblleavewithdrawal.TotalLeaves = Convert.ToDouble(dt.Rows[i]["TOTALAPPLIEDLEAVE"]); tblleavewithdrawal.LeaveAppliedDate = Convert.ToDateTime(dt.Rows[i]["LEAVEAPPLIEDDATE"]); tblleavewithdrawal.LeaveAppliedDateString = tblleavewithdrawal.LeaveAppliedDate.ToString("dd/MM/yyyy").Replace('-', '/');; tblleavewithdrawal.EmployeeID = Convert.ToString(dt.Rows[i]["EMPLOYEEID"]); tblleavewithdrawal.EmployeeName = Convert.ToString(dt.Rows[i]["EMPLOYEENAME"]); tblleavewithdrawal.LeaveCategory = Convert.ToString(dt.Rows[i]["LEAVECATEGORY"]); tblleavewithdrawal.UploadFileName = Convert.ToString(dt.Rows[i]["FILENAME"]); listObj.Add(tblleavewithdrawal); } } } else if (ReturnVal == 1 || ReturnVal == 2) { var tbleavewithdrawal = new tbl_Leavewithdrawal(); tbleavewithdrawal.ReturnValue = ReturnVal; listObj.Add(tbleavewithdrawal); } return(listObj); } catch (Exception ex) { throw ex; } }
public List <tbl_LeaveHistory> GetLeaveHistory(string empid, string year) { try { DALBase obj = new DALBase(_config); List <tbl_LeaveHistory> objList = new List <tbl_LeaveHistory>(); 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, "P_LeaveHistory", OracleDbType.RefCursor, 20, null, ParameterDirection.Output); obj.TupleForOracleParameter(lstTupParameters, "P_Year", OracleDbType.NVarchar2, 20, year, ParameterDirection.Input); DataSet ds = obj.GetDatafromDatabase("BCL_TEST2_GETLEAVEHISTORY", lstTupParameters); DataTable dt = ds.Tables[0]; if (dt != null) { if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { var objTblLeaveHistory = new tbl_LeaveHistory(); objTblLeaveHistory.LeaveCategory = Convert.ToString(dt.Rows[i]["LEAVECATEGORY"]); objTblLeaveHistory.LeaveAppliedDate = Convert.ToDateTime(dt.Rows[i]["LEAVEAPPLIEDDATE"]).ToString("dd/MM/yyyy").Replace('-', '/'); objTblLeaveHistory.FromDate = Convert.ToDateTime(dt.Rows[i]["FROMDATE"]).ToString("dd/MM/yyyy").Replace('-', '/');; objTblLeaveHistory.ToDate = Convert.ToDateTime(dt.Rows[i]["TODATE"]).ToString("dd/MM/yyyy").Replace('-', '/');; objTblLeaveHistory.TotalLeaves = Convert.ToDouble(dt.Rows[i]["TOTALAPPLIEDLEAVE"]); objTblLeaveHistory.ApproverName = Convert.ToString(dt.Rows[i]["APPROVERNAME"]); objTblLeaveHistory.Status = Convert.ToString(dt.Rows[i]["STATUS"]); if (Convert.ToString(dt.Rows[i]["LEAVESHIFT"]) == "F") { objTblLeaveHistory.LeaveType = "First Half"; } else if (Convert.ToString(dt.Rows[i]["LEAVESHIFT"]) == "S") { objTblLeaveHistory.LeaveType = "Second Half"; } else { objTblLeaveHistory.LeaveType = "Full Day"; } objTblLeaveHistory.Indicator = dt.Rows[i]["SAPSUCCESSFLAG"].ToString(); objTblLeaveHistory.ErrorMsg = dt.Rows[i]["ERRORMSG"].ToString(); objTblLeaveHistory.LeaveCode = dt.Rows[i]["Leavecode"].ToString(); objList.Add(objTblLeaveHistory); } } } return(objList); } catch (Exception ex) { throw ex; } }
public Tuple <string, int> SaveWithdrawalLeaveRequest(tbl_Leavewithdrawal tblLeaveWithdrawal) { try { Tuple <string, int> returnStr = new Tuple <string, int>("Failed", 1); List <Tuple <string, OracleDbType, int, object, ParameterDirection> > Lsttuples = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >(); DALBase obj = new DALBase(_config); Lsttuples = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >(); obj.TupleForOracleParameter(Lsttuples, ConstantsVariables.P_LEAVEREQUESTID, OracleDbType.NVarchar2, 20, tblLeaveWithdrawal.LeaveRequestId.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(Lsttuples, ConstantsVariables.P_STATUS, OracleDbType.NVarchar2, 1000, tblLeaveWithdrawal.Status, ParameterDirection.Input); obj.TupleForOracleParameter(Lsttuples, ConstantsVariables.P_EMPLOYEEID, OracleDbType.NVarchar2, 500, tblLeaveWithdrawal.EmployeeID.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(Lsttuples, ConstantsVariables.P_TOTALAPPLIEDLEAVE, OracleDbType.Double, 20, tblLeaveWithdrawal.TotalLeaves.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(Lsttuples, "P_MESSAGE", OracleDbType.NVarchar2, 100, null, ParameterDirection.Output); obj.TupleForOracleParameter(Lsttuples, "P_RETURNVALUE", OracleDbType.Int32, 1, null, ParameterDirection.Output); obj.TupleForOracleParameter(Lsttuples, "P_ErrorMsg", OracleDbType.NVarchar2, 1000, Convert.ToString(tblLeaveWithdrawal.ErrorMsg), ParameterDirection.Input); obj.TupleForOracleParameter(Lsttuples, "P_Indicator", OracleDbType.NVarchar2, 20, Convert.ToString(tblLeaveWithdrawal.Indicator), ParameterDirection.Input); returnStr = obj.savedata("BCL_TEST_SAVELEAVEWITHDRAWAL", Lsttuples); return(returnStr); } catch (Exception ex) { Tuple <string, int> returnData = new Tuple <string, int>("Failed", 0); return(returnData); throw ex; } }
public void LeaveHistoryExcel(string empid) { DALBase obj = new DALBase(_config); 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, ParameterDirection.Input); obj.DeleteUser(ConstantStoredProcedure.SP_BCL_GETLEAVEHISTORYExcel, empid); }
public void DeleteUser(string userid) { 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_USERID, OracleDbType.NVarchar2, 20, Convert.ToString(userid), ParameterDirection.Input); obj.DeleteUser(ConstantStoredProcedure.SP_BCL_Delete_ConcurrentLogin, userid); }
public tbl_OTPG GetDOBForKIOSK(string employeeid) { DALBase obj = new DALBase(_config); List <Tuple <String, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >(); tbl_OTPG listObj = new tbl_OTPG(); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EMPID, OracleDbType.Varchar2, 20, employeeid.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "P_Empdetails", OracleDbType.RefCursor, 20, null, ParameterDirection.Output); DataSet ds = obj.GetDatafromDatabase(ConstantStoredProcedure.SP_BCL_GETDOBFORKIOSK, LstTupParameters); DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { DateTime dob = Convert.ToDateTime(dt.Rows[0]["DATEOFBIRTH"]); listObj.DateOfBirth = dob; } return(listObj); }
public Tuple <string, int> InsertEmpId(string Empid) { try { DALBase obj = new DALBase(_config); List <Tuple <string, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >(); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EMPID, OracleDbType.NVarchar2, 50, Empid.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "P_MESSAGE", OracleDbType.NVarchar2, 100, null, ParameterDirection.Output); obj.TupleForOracleParameter(LstTupParameters, "P_RETURNVALUE", OracleDbType.Int32, 1, null, ParameterDirection.Output); Tuple <string, int> Returnstr = obj.savedata(ConstantStoredProcedure.SP_BCL_InsertApproverID, LstTupParameters); return(Returnstr); } catch (Exception ex) { Tuple <string, int> returndata = new Tuple <string, int>("Failed", 1); return(returndata); throw; } }
//For Report public List <tbl_LeaveHistory> GetEmployeeReport(string empid, string fromdate, string todate) { try { DALBase obj = new DALBase(_config); List <tbl_LeaveHistory> objList = new List <tbl_LeaveHistory>(); 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_FROMDATE, OracleDbType.NVarchar2, 20, fromdate.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(lstTupParameters, ConstantsVariables.P_TODATE, OracleDbType.NVarchar2, 20, todate.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(lstTupParameters, "P_LeaveHistory", OracleDbType.RefCursor, 20, null, ParameterDirection.Output); DataSet ds = obj.GetEmployeeReport(ConstantStoredProcedure.SP_BCL_EMPLOYEEREPORT, lstTupParameters); DataTable dt = ds.Tables[0]; if (dt != null) { if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { var objTblLeaveHistory = new tbl_LeaveHistory(); objTblLeaveHistory.LeaveCategory = Convert.ToString(dt.Rows[i]["LEAVECATEGORY"]); objTblLeaveHistory.LeaveAppliedDate = Convert.ToDateTime(dt.Rows[i]["LEAVEAPPLIEDDATE"]).ToString("dd/MM/yyyy"); objTblLeaveHistory.FromDate = Convert.ToDateTime(dt.Rows[i]["FROMDATE"]).ToString("dd/MM/yyyy"); objTblLeaveHistory.ToDate = Convert.ToDateTime(dt.Rows[i]["TODATE"]).ToString("dd/MM/yyyy"); objTblLeaveHistory.TotalLeaves = Convert.ToDouble(dt.Rows[i]["TOTALAPPLIEDLEAVE"]); objTblLeaveHistory.ApproverName = Convert.ToString(dt.Rows[i]["APPROVERNAME"]); objTblLeaveHistory.Status = Convert.ToString(dt.Rows[i]["STATUS"]); objTblLeaveHistory.LeaveType = Convert.ToString(dt.Rows[i]["LEAVESHIFT"]); objTblLeaveHistory.Indicator = dt.Rows[i]["SAPSUCCESSFLAG"].ToString(); objTblLeaveHistory.ErrorMsg = dt.Rows[i]["ERRORMSG"].ToString(); objList.Add(objTblLeaveHistory); } } } return(objList); } catch (Exception ex) { throw ex; } }
public Tuple <string, int> SaveNewUser(List <tbl_User> tbl_USERs) { try { DALBase obj = new DALBase(_config); List <Tuple <string, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >(); foreach (var l in tbl_USERs) { obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EMPID, OracleDbType.NVarchar2, 50, l.EmployeeID.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_USERID, OracleDbType.NVarchar2, 50, l.UserID.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_PASSWORD, OracleDbType.Varchar2, 100, l.Password.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_ISACTIVE, OracleDbType.Int32, 100, 1.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "P_MESSAGE", OracleDbType.NVarchar2, 100, null, ParameterDirection.Output); obj.TupleForOracleParameter(LstTupParameters, "P_RETURNVALUE", OracleDbType.Int32, 1, null, ParameterDirection.Output); // TupleForOracleParameter(LstTupParameters, "v_IsPreviousPass", OracleDbType.Int32, 1, null, ParameterDirection.Output); } Tuple <string, int> Returnstr = obj.savedata(ConstantStoredProcedure.SP_SAVEUSER, LstTupParameters); return(Returnstr); } catch (Exception ex) { Tuple <string, int> returndata = new Tuple <string, int>("Failed", 1); return(returndata); throw; } }
public List <tbl_LeaveApproval> GetApprovalDetails(string ApproverId) { DALBase obj = new DALBase(_config); // int ApproverId = tblapprover.ApproverId; List <tbl_LeaveApproval> listObj = new List <tbl_LeaveApproval>(); List <Tuple <String, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >(); // obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EMPID, OracleDbType.Varchar2, 20, ApproverId.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EMPID, OracleDbType.NVarchar2, 20, ApproverId.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EmpDetails, OracleDbType.RefCursor, 1, null, ParameterDirection.Output); DataSet ds = obj.GetDatafromDatabase(ConstantStoredProcedure.SP_GETAPPROVERDETAILS, LstTupParameters); DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { var tblleaveapproval = new tbl_LeaveApproval(); tblleaveapproval.ApproverMailID = dt.Rows[i][0].ToString(); tblleaveapproval.ApproverMobNo = dt.Rows[i][1].ToString(); tblleaveapproval.HODMailID = dt.Rows[i][2].ToString(); tblleaveapproval.HODMobNo = dt.Rows[i][3].ToString(); if (dt.Rows[i][4].ToString() != null || dt.Rows[i][4].ToString() != "") { //tblleaveapproval.deptID = dt.Rows[i][3].ToString(); } //tblleaveapproval.FromDateString = tblleaveapproval.FromDate.ToString("dd/MM/yyyy"); tblleaveapproval.DeptID = dt.Rows[i][5].ToString(); listObj.Add(tblleaveapproval); } } //else //{ // var tbleaveappr = new tbl_LeaveApproval(); // tbleaveappr.ReturnValue = 0; // listObj.Add(tbleaveappr); //} return(listObj); }
public List <tbl_LeaveDashboard> GetDashboardLeaveList(string empid) { try { DALBase obj = new DALBase(_config); List <tbl_LeaveDashboard> listobj = new List <tbl_LeaveDashboard>(); 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, "P_DashboardDetails", OracleDbType.RefCursor, 20, null, ParameterDirection.Output); DataSet ds = obj.GetDatafromDatabase(ConstantStoredProcedure.SP_BCL_DashboardDetails, LstTupParameters); DataTable dt = ds.Tables[0]; if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dtRow in dt.Rows) { var objLeave = new tbl_LeaveDashboard(); var objLeaveCat = dtRow["LEAVECATEGORY"].ToString(); var objQuota = dtRow["QUOTA"].ToString(); var objApprovedLeave = dtRow["Approved"].ToString(); var objPendingLeave = dtRow["Pending"].ToString(); var objEndDate = dtRow["ENDDATE"].ToString(); objLeave.LeaveCategory = objLeaveCat; objLeave.Quota = Convert.ToDouble(objQuota); objLeave.ApprovedLeave = objApprovedLeave; objLeave.PendingLeave = Convert.ToDouble(objPendingLeave); objLeave.EndDate = objEndDate; objLeave.EndDate = Convert.ToDateTime(objEndDate).ToString("dd/MM/yyyy"); listobj.Add(objLeave); } } return(listobj); } catch (Exception) { throw; } }
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); }
public List <tbl_User> Authenticate(List <tbl_User> tbl_USERs) { DALBase obj = new DALBase(_config); List <Tuple <String, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >(); List <tbl_User> listObj = new List <tbl_User>(); foreach (var l in tbl_USERs) { obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_USERID, OracleDbType.NVarchar2, 50, l.UserID.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_ISACTIVE, OracleDbType.Int32, 50, 1.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_PASSWORD, OracleDbType.Varchar2, 100, l.Password, ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "P_MESSAGE", OracleDbType.NVarchar2, 100, null, ParameterDirection.Output); obj.TupleForOracleParameter(LstTupParameters, "P_RETURNVALUE", OracleDbType.Int32, 1, null, ParameterDirection.Output); obj.TupleForOracleParameter(LstTupParameters, "P_EMPDETAILS", OracleDbType.RefCursor, 20, null, ParameterDirection.Output); } //DataSet ds = obj.GetDatafromDatabase(ConstantStoredProcedure.SP_AUTHENTICATEUSER, LstTupParameters); DataSet ds = obj.GetDatafromDatabase("BCL_TEST_AUTHENTICATIONUSER", LstTupParameters); var RetunVal = Convert.ToInt32((decimal)(OracleDecimal)(obj.cmd.Parameters["P_RETURNVALUE"].Value)); var RetunValMessg = Convert.ToString((OracleString)(obj.cmd.Parameters["P_MESSAGE"].Value)); if (RetunVal == 0) { DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { foreach (var item in dt.Rows) { var tbuser = new tbl_User(); tbuser.EmployeeID = Convert.ToString(dt.Rows[0][0]); tbuser.EmployeeName = dt.Rows[0][1].ToString(); tbuser.EmpEmail = Convert.ToString(dt.Rows[0][2]); tbuser.DateOfBirth = Convert.ToDateTime(dt.Rows[0][3]); tbuser.PersonalArea = Convert.ToString(dt.Rows[0][4]); tbuser.PersonalSubArea = dt.Rows[0][5].ToString(); tbuser.MobileNo = Convert.ToString(dt.Rows[0][6]); tbuser.ReturnValue = RetunVal; tbuser.Category = dt.Rows[0][7].ToString(); listObj.Add(tbuser); } } } else if (RetunVal == 1 || RetunVal == 2 || RetunVal == 3 || RetunVal == 4) { var tbuser = new tbl_User(); tbuser.ReturnValue = RetunVal; tbuser.ReturnValMessg = Convert.ToString(RetunValMessg); listObj.Add(tbuser); } return(listObj); }
public List <tbl_LeaveQuota> GetLeaveQuota(string objEmpID) { try { DALBase obj = new DALBase(_config); List <tbl_LeaveQuota> listObj = new List <tbl_LeaveQuota>(); List <Tuple <String, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >(); TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EMPLOYEEID, OracleDbType.NVarchar2, 50, objEmpID.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "P_QuotaDetails", OracleDbType.RefCursor, 20, null, ParameterDirection.Output); DataSet ds = obj.GetDatafromDatabase(ConstantStoredProcedure.SP_BCL_GETLeaveQuotaDetails, LstTupParameters); DataTable dt = ds.Tables[0]; if (dt != null) { if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { var objtblLeaveQuota = new tbl_LeaveQuota(); objtblLeaveQuota.LeaveCategory = Convert.ToString(dt.Rows[i]["LEAVECATEGORY"]); objtblLeaveQuota.BalanceLeave = Convert.ToInt32(dt.Rows[i]["BALANCELEAVE"]); objtblLeaveQuota.Quota = Convert.ToInt32(dt.Rows[i]["QUOTA"]); objtblLeaveQuota.FromDate = Convert.ToDateTime(dt.Rows[i]["STARTDATE"]).ToString("dd/MM/yyyy"); objtblLeaveQuota.ToDate = Convert.ToDateTime(dt.Rows[i]["ENDDATE"]).ToString("dd/MM/yyyy"); objtblLeaveQuota.ApproverName = dt.Rows[i]["APPROVERNAME"].ToString(); objtblLeaveQuota.TotalLeaves = Convert.ToInt32(dt.Rows[i]["TOTALLEAVES"]); listObj.Add(objtblLeaveQuota); } } } return(listObj); } catch (Exception) { throw; } }
public Tuple <string, int> SaveFromSAP(List <tbl_Employee> tbl_User) { try { DALBase obj = new DALBase(_config); List <Tuple <string, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >(); foreach (var l in tbl_User) { if (l.EmployeeMail == null || l.EmployeeMail == "") { l.EmployeeMail = "EmailID not Updated"; } obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EMPID, OracleDbType.NVarchar2, 50, l.EmployeeID.ToString(), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EMPNAME, OracleDbType.NVarchar2, 50, l.EmployeeName.ToString(), ParameterDirection.Input); string DOB = l.DateOfBirth; obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_DATEOFBIRTH, OracleDbType.NVarchar2, 100, DOB, ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_PA, OracleDbType.Varchar2, 100, l.PersonalArea, ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_PSA, OracleDbType.Varchar2, 100, l.PersonalSubArea, ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_PHONENO, OracleDbType.Varchar2, 100, l.MobileNo, ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "CostCenter", OracleDbType.Varchar2, 100, l.CostCenter, ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "CardID", OracleDbType.Varchar2, 100, l.CardID, ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "P_MESSAGE", OracleDbType.NVarchar2, 100, null, ParameterDirection.Output); obj.TupleForOracleParameter(LstTupParameters, "P_RETURNVALUE", OracleDbType.Int32, 1, null, ParameterDirection.Output); obj.TupleForOracleParameter(LstTupParameters, "P_EMAIL", OracleDbType.Varchar2, 500, l.EmployeeMail, ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_APPROVERID, OracleDbType.Varchar2, 500, Convert.ToString(l.ApproverId), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_APPROVERNAME, OracleDbType.Varchar2, 500, Convert.ToString(l.ApproverName), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "P_EMPSUBGROUP", OracleDbType.Varchar2, 500, l.EmpSubGroup, ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "P_EMPGROUP", OracleDbType.Varchar2, 500, l.EmpGroup, ParameterDirection.Input); } Tuple <string, int> Returnstr = obj.savedata("SaveEMPMaster", LstTupParameters); return(Returnstr); } catch (Exception ex) { Tuple <string, int> returndata = new Tuple <string, int>("Failed", 1); return(returndata); throw; } }
public Tuple <string, int> SaveFromSAP(List <tbl_LeaveQuotaSAP> tbl_User) { try { DALBase obj = new DALBase(_config); List <Tuple <string, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >(); foreach (var l in tbl_User) { obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EMPID, OracleDbType.NVarchar2, 50, Convert.ToString(l.EMPLOYEEID), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_LEAVEID, OracleDbType.NVarchar2, 50, Convert.ToString(l.LEAVECODE), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_LEAVECATEGORY, OracleDbType.NVarchar2, 1000, Convert.ToString(l.LEAVECATEGORY), ParameterDirection.Input); string startdate = Convert.ToDateTime(l.STARTDATE).ToString("dd/MM/yyyy"); string endate = Convert.ToDateTime(l.ENDDATE).ToString("dd/MM/yyyy"); obj.TupleForOracleParameter(LstTupParameters, "P_STARTDATE", OracleDbType.NVarchar2, 120, Convert.ToString(startdate), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "P_ENDDATE", OracleDbType.NVarchar2, 120, Convert.ToString(endate), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "P_QUOTA", OracleDbType.Double, 100, l.QUOTA, ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_BALANCELEAVE, OracleDbType.Double, 100, l.BALANCELEAVE, ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_APPROVERID, OracleDbType.NVarchar2, 50, Convert.ToString(l.APPROVERID), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_APPROVERNAME, OracleDbType.NVarchar2, 50, Convert.ToString(l.APPROVERNAME), ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_TOTALLEAVE, OracleDbType.Double, 50, l.CARRYFRWD, ParameterDirection.Input); obj.TupleForOracleParameter(LstTupParameters, "P_RETURNVALUE", OracleDbType.Int32, 1, null, ParameterDirection.Output); } Tuple <string, int> Returnstr = obj.savedataFSAP("BCL_SAVELEAVEQUOTASAP", LstTupParameters); return(Returnstr); } catch (Exception ex) { Tuple <string, int> returndata = new Tuple <string, int>("Failed", 1); return(returndata); throw; } }