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