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