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 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 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 Tuple <string, int> UpdateLeaveRequest(tbl_LeaveRequest 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_EMPLOYEEID, OracleDbType.NVarchar2, 50, objleave_request.EmployeeID.ToString(), ParameterDirection.Input);
TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_LEAVEREQUESTID, OracleDbType.NVarchar2, 50, objleave_request.LeaveRequestID.ToString(), ParameterDirection.Input);
TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_APPROVERNAME, OracleDbType.NVarchar2, 100, objleave_request.ApproverName.ToString(), ParameterDirection.Input);
TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_APPROVERID, OracleDbType.NVarchar2, 50, objleave_request.ApproverId.ToString(), ParameterDirection.Input);
TupleForOracleParameter(LstTupParameters, "P_MESSAGE", OracleDbType.NVarchar2, 100, null, ParameterDirection.Output);
TupleForOracleParameter(LstTupParameters, "P_RETURNVALUE", OracleDbType.Int32, 1, null, ParameterDirection.Output);
Tuple <string, int> Retunstr = obj.savedata(ConstantStoredProcedure.SP_BCL_UPDATELEAVEREQUEST, LstTupParameters);
return(Retunstr);
}
catch (Exception ex)
{
Tuple <string, int> returndata = new Tuple <string, int>("Failed", 1);
return(returndata);
throw;
}
}
public Tuple <string, int> SaveLeaveRequest(tbl_LeaveRequest objleave_request)
{
DALBase obj = new DALBase(_config);
objleave_request.LeaveAppliedDate = Convert.ToDateTime(DateTime.Now.Date).ToString("dd/MM/yyyy");
objleave_request.StatusUpdate = Convert.ToDateTime(DateTime.Now.Date).ToString("dd/MM/yyyy");
List <Tuple <string, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >();
TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_LEAVEID, OracleDbType.Int32, 50, Convert.ToString(objleave_request.LeavelistId), 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_LEAVETYPE, OracleDbType.NVarchar2, 50, Convert.ToString(objleave_request.LeaveShift), ParameterDirection.Input);
TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_APPROVERID, OracleDbType.NVarchar2, 50, Convert.ToString(objleave_request.ApproverId), ParameterDirection.Input);
TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_APPROVERNAME, OracleDbType.NVarchar2, 50, Convert.ToString(objleave_request.ApproverName), ParameterDirection.Input);
TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_REMARKS, OracleDbType.NVarchar2, 100, Convert.ToString(objleave_request.Remarks), ParameterDirection.Input);
TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_TOTALAPPLIEDLEAVE, OracleDbType.Double, 100, Convert.ToString(objleave_request.TotalAppliedLeave), ParameterDirection.Input);
TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_LEAVEAPPLIEDDATE, OracleDbType.NVarchar2, 120, Convert.ToString(objleave_request.LeaveAppliedDate), ParameterDirection.Input);
TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EMPLOYEEID, OracleDbType.NVarchar2, 50, Convert.ToString(objleave_request.EmployeeID), ParameterDirection.Input);
TupleForOracleParameter(LstTupParameters, "P_MESSAGE", OracleDbType.NVarchar2, 100, null, ParameterDirection.Output);
TupleForOracleParameter(LstTupParameters, "P_RETURNVALUE", OracleDbType.Int32, 1, null, ParameterDirection.Output);
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, Convert.ToString(objleave_request.UploadFileName), ParameterDirection.Input);
}
TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EMPLOYEENAME, OracleDbType.NVarchar2, 50, Convert.ToString(objleave_request.EmployeeName), ParameterDirection.Input);
// Tuple<string, int> Retunstr = obj.savedata(ConstantStoredProcedure.SP_BCL_SAVELEAVEREQUEST, LstTupParameters);
Tuple <string, int> Retunstr = obj.savedata("BCL_SAVELEAVEREQUEST", LstTupParameters);
return(Retunstr);
}
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 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 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;
}
}
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, l.EMPLOYEEID.ToString(), ParameterDirection.Input);
obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_LEAVEID, OracleDbType.NVarchar2, 50, l.LEAVECODE.ToString(), ParameterDirection.Input);
obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_LEAVECATEGORY, OracleDbType.NVarchar2, 1000, l.LEAVECATEGORY.ToString(), 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, startdate, ParameterDirection.Input);
obj.TupleForOracleParameter(LstTupParameters, "P_ENDDATE", OracleDbType.NVarchar2, 120, 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);
//string name = "vc1.ttl";
obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_APPROVERID, OracleDbType.NVarchar2, 50, l.APPROVERID, ParameterDirection.Input);
obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_APPROVERNAME, OracleDbType.NVarchar2, 50, l.APPROVERNAME, ParameterDirection.Input);
obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_TOTALLEAVE, OracleDbType.Double, 50, l.CARRYFRWD, 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_SAVELEAVEQUOTASAP", LstTupParameters);
return(Returnstr);
}
catch (Exception ex)
{
Tuple <string, int> returndata = new Tuple <string, int>("Failed", 1);
return(returndata);
throw;
}
}
