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);
}
