public JsonResult GetWOCessionofficersPossionDetailsByCessId(int CessID) { System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); System.Reflection.MethodBase methodBase = stackFrame.GetMethod(); log.Debug("Start: " + methodBase.Name); try { var result = new CessionofficersInfo(); int checkSession = UserLogin.AuthenticateRequest(); if (checkSession == 0) { return Json(checkSession); } else { result = Cessionofficers.GetWOCessionofficersPossionDetails(CessID); } return Json(result.DirectorsList); } catch (Exception ex) { log.Error("Error: " + ex); return Json(""); } finally { log.Debug("End: " + methodBase.Name); } }
/// <summary> /// Description : Get Directors Details from database. /// Created By : Sudheer /// Created Date : 20 Nov 2014 /// Modified By : /// Modified Date: /// </summary> /// <returns></returns> public static CessionofficersInfo GetCessationDirectors(int WOID, int DirectorID, string DirectorSource, int NatureAppoint) { var data = new CessionofficersInfo(); System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); System.Reflection.MethodBase methodBase = stackFrame.GetMethod(); log.Debug("Start: " + methodBase.Name); try { SqlParameter[] sqlParams = new SqlParameter[4]; sqlParams[0] = new SqlParameter("@WOID", WOID); sqlParams[1] = new SqlParameter("@DirctorID", DirectorID); sqlParams[2] = new SqlParameter("@DirectorSource", DirectorSource); sqlParams[3] = new SqlParameter("@NatureofOppintment", NatureAppoint); var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "[SpGetDirectorDetailsforCessationOfficer]", sqlParams); var safe = new SafeDataReader(reader); while (reader.Read()) { var directors = new Cessionofficers(); directors.CessationDirectors(directors, safe); data.DirectorsList.Add(directors); } return data; } catch (Exception ex) { log.Error("Error: " + ex); return data; } finally { log.Debug("End: " + methodBase.Name); } }
/// <summary> /// Created By : Sudheer /// Created Date : 21 Nov 2014 /// Modified By : /// Modified Date: /// Description : Get Cessionofficers Details by WOID /// </summary> /// <returns></returns> public static CessionofficersInfo GetWOCessionofficersPossionDetails(int CessId) { var GetWOCessionData = new CessionofficersInfo(); System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); System.Reflection.MethodBase methodBase = stackFrame.GetMethod(); log.Debug("Start: " + methodBase.Name); try { SqlParameter[] sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@CessId", CessId); var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SpGetCessionofficersPossionDetails", sqlParams); var safe = new SafeDataReader(reader); while (reader.Read()) { var Details = new Cessionofficers(); Details.FetchPositionDetails(Details, safe); GetWOCessionData.DirectorsList.Add(Details); } return GetWOCessionData; } catch (Exception ex) { log.Error("Error: " + ex); return GetWOCessionData; } finally { log.Debug("End: " + methodBase.Name); } }
/// <summary> /// Created By : Sudheer /// Created Date : 21 Nov 2014 /// Modified By : /// Modified Date: /// Description : Get Cessionofficers Details by WOID /// </summary> /// <returns></returns> public static int DeleteCessationOfficerDetails(int ID) { int Rerurn = -1; var GetWOCessionData = new CessionofficersInfo(); System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); System.Reflection.MethodBase methodBase = stackFrame.GetMethod(); log.Debug("Start: " + methodBase.Name); try { SqlParameter[] sqlParams = new SqlParameter[2]; sqlParams[0] = new SqlParameter("@ID", ID); sqlParams[1] = new SqlParameter("@Output", 0); sqlParams[1].Direction = ParameterDirection.Output; SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "[SPDeleteCessationOfficerDetailsByID]", sqlParams); Rerurn = Convert.ToInt16(sqlParams[1].Value); return Rerurn; } catch (Exception ex) { log.Error("Error: " + ex); return Rerurn; } finally { log.Debug("End: " + methodBase.Name); } }