public int SaveApproverFromSAP(ApproverServiceModel model) { // return 1; var saveapproval = new List <tbl_LeaveApproval>(); var savedata = new tbl_LeaveApproval { EmployeeID = model.DETAILS.Select(x => x.EmployeeID).FirstOrDefault(), ApproverId = model.DETAILS.Select(x => x.PERNR_SUP).FirstOrDefault(), ApproverMobNo = model.DETAILS.Select(x => x.CELL_SUP).FirstOrDefault(), ApproverName = model.DETAILS.Select(x => x.CNAME_SUP).FirstOrDefault(), HODName = model.DETAILS.Select(x => x.CNAME_HOD).FirstOrDefault(), ApproverMailID = model.DETAILS.Select(x => x.EMAIL_SUP).FirstOrDefault(), HODID = model.DETAILS.Select(x => x.PERNR_HOD).FirstOrDefault(), HODMailID = model.DETAILS.Select(x => x.EMAILID_HOD).FirstOrDefault(), LeaveRequestId = Convert.ToInt32(model.DETAILS.Select(x => x.LeaveRequestID).FirstOrDefault()), }; saveapproval.Add(savedata); Tuple <string, int> result = _iLeaveRequestRepository.SaveApproverFromSAP(saveapproval); // Tuple<string, int> result = _igenerateotprepositary.SaveFromSAP(Mapper.Map<List<tbl_Employee>>(model)); var returndata = 0; if (result.Item2 == 0) { returndata = 1; } else { returndata = 0; } return(returndata); }
//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; // } //} public List <tbl_LeaveApproval> GetEmpLeaveDetails(string SchedulerType) { DALBase obj = new DALBase(_config); List <tbl_LeaveApproval> list = new List <tbl_LeaveApproval>(); DataSet ds = obj.GetEmpLeaveDetails(ConstantStoredProcedure.SP_BCL_GETEMPDETAILS_E, SchedulerType); DataTable dt = ds.Tables[0]; tbl_LeaveApproval objtblLeaveRequest = new tbl_LeaveApproval(); if (dt != null) { if (dt.Rows.Count > 0) { foreach (DataRow dtRow in dt.Rows) { objtblLeaveRequest = new tbl_LeaveApproval(); objtblLeaveRequest.EmployeeID = Convert.ToString(dtRow["EMPLOYEEID"]); objtblLeaveRequest.FromDate = Convert.ToDateTime(dtRow["FROMDATE"]); objtblLeaveRequest.FromDateString = objtblLeaveRequest.FromDate.ToString("dd/MM/yyyy"); objtblLeaveRequest.FromDateString = objtblLeaveRequest.FromDateString.Replace('-', '/'); objtblLeaveRequest.ToDate = Convert.ToDateTime(dtRow["TODATE"]); objtblLeaveRequest.ToDateString = objtblLeaveRequest.ToDate.ToString("dd/MM/yyyy"); objtblLeaveRequest.ToDateString = objtblLeaveRequest.ToDateString.Replace('-', '/'); objtblLeaveRequest.LeaveShift = Convert.ToString(dtRow["LEAVESHIFT"]); objtblLeaveRequest.LeaveCode = Convert.ToString(dtRow["LEAVECODE"]); objtblLeaveRequest.LeaveRequestId = Convert.ToInt32(dtRow["LEAVEREQUESTID"]); list.Add(objtblLeaveRequest); } } } return(list); }
//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 List <tbl_LeaveApproval> GetMulitpleEmployeeDetails(string strLeaveReqID) { try { DALBase obj = new DALBase(_config); List <tbl_LeaveApproval> listObj = new List <tbl_LeaveApproval>(); tbl_LeaveApproval objLeave = new tbl_LeaveApproval(); DataSet ds = obj.GetMulipleDataBYId(ConstantStoredProcedure.SP_BCL_GETEMPDETAILS_Muliple, strLeaveReqID); DataTable dt = ds.Tables[0]; if (dt != null) { if (dt.Rows.Count > 0) { foreach (DataRow dtRow in dt.Rows) { var objLeaverequestid = dtRow[0].ToString(); var objEmployeeID = dtRow[1].ToString(); objLeave = new tbl_LeaveApproval(); objLeave.LeaveRequestId = Convert.ToInt32(objLeaverequestid); objLeave.EmployeeID = objEmployeeID; objLeave.FromDate = Convert.ToDateTime(dtRow[2]); objLeave.FromDateString = objLeave.FromDate.ToString("dd/MM/yyyy"); objLeave.ToDate = Convert.ToDateTime(dtRow[3]); objLeave.ToDateString = objLeave.ToDate.ToString("dd/MM/yyyy"); objLeave.TotalLeaves = Convert.ToDouble(dtRow[4]); objLeave.LeaveShift = dtRow[5].ToString(); objLeave.LeaveCode = dtRow[6].ToString(); objLeave.OldStatus = dtRow[9].ToString(); objLeave.LeaveId = Convert.ToInt32(dtRow[10]); objLeave.empmobileno = Convert.ToString(dtRow[11]); objLeave.LeaveCategory = Convert.ToString(dtRow[12]); listObj.Add(objLeave); } } } return(listObj); } catch (Exception ex) { throw ex; } }
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); }