private static string GetLeaveLevelSP(LeaveMode mode, string action)
{
string sp = "";
if (mode == LeaveMode.Request)
{
if (action == "A")
{
sp = "SP_ADD_LEAVE_REQUEST_DETAIL";
}
else if (action == "E")
{
sp = "SP_EDIT_LEAVE_TIPPANI_DETAIL";
}
else if (action == "D")
{
sp = "sp_del_tippani_detail";
}
}
else if (mode == LeaveMode.Recommend)
{
sp = "SP_UP_LEAVE_TIPPANI_DETAIL_REC";
}
else if (mode == LeaveMode.Approve)
{
sp = "SP_UP_LEAVE_TIPPANI_DETAIL_APP";
}
return(sp);
}
public static DataTable GetLeaveTippaniDetail(int orgID, int tippaniID, int tippaniProcessID, LeaveMode mode)
{
string SP = "sp_GET_LEAVE_TIPPANI_DETAIL";
string status = null;
if (mode == LeaveMode.Approve)
{
status = "Y";
}
List <OracleParameter> paramArray = new List <OracleParameter>();
paramArray.Add(Utilities.GetOraParam("p_org_id", orgID, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("p_tipani_id", tippaniID, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_LEAVE_MODE,", null, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("p_rc", null, OracleDbType.RefCursor, ParameterDirection.InputOutput));
try
{
return(SqlHelper.ExecuteDataset(CommandType.StoredProcedure, SP, Module.OAS, paramArray.ToArray()).Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <ATTGeneralTippaniSummary> GetLeaveTippaniDetail(int orgID, int tippaniID, int tippaniProcessID, LeaveMode mode)
{
List <ATTGeneralTippaniSummary> lst = new List <ATTGeneralTippaniSummary>();
try
{
DataTable tbl = DLLGeneralTippaniDetail.GetLeaveTippaniDetail(orgID, tippaniID, tippaniProcessID, mode);
foreach (DataRow row in tbl.Rows)
{
ATTGeneralTippaniSummary tippani = new ATTGeneralTippaniSummary();
tippani.OrgID = int.Parse(row["org_id"].ToString());
tippani.TippaniID = int.Parse(row["tippani_id"].ToString());
tippani.EmpID = double.Parse(row["Emp_ID"].ToString());
tippani.OrgName = row["org_name"].ToString();
tippani.DesName = row["des_name"].ToString();
tippani.EmpName = row["p_name"].ToString();
tippani.ApplicationDate = row["APPL_DATE"].ToString();
tippani.LeaveType = row["LEAVE_TYPE_NAME"].ToString();
tippani.LeaveTypeID = int.Parse(row["LEAVE_TYPE_ID"].ToString());
tippani.ReqFromDate = row["REQ_FROM_DATE"].ToString();
tippani.ReqToDate = row["REQ_TO_DATE"].ToString();
tippani.ReqNoOfDays = row["REQ_NO_OF_DAYS"].ToString() == "" ? 0 : int.Parse(row["REQ_NO_OF_DAYS"].ToString());
tippani.ReqReason = row["REQ_REASON"].ToString();
tippani.RecBy = row["REC_BY"].ToString() == "" ? 0 : double.Parse(row["REC_BY"].ToString());
tippani.RecDate = row["REC_DATE"].ToString();
tippani.RecFromDate = row["REC_FROM_DATE"].ToString();
tippani.RecToDate = row["REC_TO_DATE"].ToString();
tippani.RecNoOfDays = row["REC_NO_OF_DAYS"].ToString() == "" ? 0 : int.Parse(row["REC_NO_OF_DAYS"].ToString());
tippani.RecYesNo = row["REC_YES_NO"].ToString();
tippani.RecReason = row["REC_REASON"].ToString();
tippani.AppBy = row["APP_BY"].ToString() == "" ? 0 : double.Parse(row["APP_BY"].ToString());
tippani.AppDate = row["APP_DATE"].ToString();
tippani.AppFromDate = row["APP_FROM_DATE"].ToString();
tippani.AppToDate = row["APP_TO_DATE"].ToString();
tippani.AppNoOfDays = row["APP_NO_OF_DAYS"].ToString() == "" ? 0 : int.Parse(row["APP_NO_OF_DAYS"].ToString());
tippani.AppYesNo = row["APP_YES_NO"].ToString();
tippani.AppReason = row["APP_REASON"].ToString();
tippani.LeaveFY = row["LEAVE_FY"].ToString();
tippani.LeavePeriodUnit = row["LEAVE_PERIOD_UNIT"].ToString();
tippani.Action = "N";
lst.Add(tippani);
}
tbl.Dispose();
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
