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