/// <summary> /// Description : To Get WO EGM Change Of Name Details. /// Created By : Shiva /// Created Date : 4th Sep 2014 /// Modified By : /// Modified Date: /// </summary> /// <returns>EGM Change Of Name Deatils.</returns> public static object GetWOEGMChangeOfNameDetailsByWOID(int WOID) { var GetWOEGMChangeOfName = new WOEGMChangeOfName(); 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("@WOID", WOID); var reader = SqlHelper.ExecuteReader(CSS2.Models.ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SPGetWOEGMChangeOfNameDetailsByWOID", sqlParams); var safe = new SafeDataReader(reader); while (reader.Read()) { GetWOEGMChangeOfName.FetchEGMChangeOfNameDetailsByWOID(GetWOEGMChangeOfName, safe); } return GetWOEGMChangeOfName; } catch (Exception ex) { log.Error("Error: " + ex); return GetWOEGMChangeOfName; } finally { log.Debug("End: " + methodBase.Name); } }
private WOEGMChangeOfName FetchEGMChangeOfNameDetailsByWOID(WOEGMChangeOfName WOEGMChangeOfName, SafeDataReader dr) { WOEGMChangeOfName.WOID = dr.GetInt32("WOID"); WOEGMChangeOfName.NewName = dr.GetString("NewName"); WOEGMChangeOfName.ShareHoldingStructure = dr.GetInt32("ShareHoldingStructure"); WOEGMChangeOfName.IsROPlaceOfMeeting = dr.GetBoolean("IsROPlaceOfMeeting"); WOEGMChangeOfName.MAddressLine1 = dr.GetString("MeetingAddressLine1"); WOEGMChangeOfName.MAddressLine2 = dr.GetString("MeetingAddressLine2"); WOEGMChangeOfName.MAddressLine3 = dr.GetString("MeetingAddressLine3"); WOEGMChangeOfName.MAddressCountry = dr.GetInt32("MAddressCountry"); WOEGMChangeOfName.MAddressPostalCode = dr.GetString("MPostalCode"); WOEGMChangeOfName.MeetingMinutesSource = dr.GetString("MeetingMinutesSource"); WOEGMChangeOfName.MeetingNoticeSource = dr.GetString("MeetingNoticeSource"); WOEGMChangeOfName.MeetingNotice = dr.GetInt32("MeetingNotice"); WOEGMChangeOfName.MeetingMinutes = dr.GetInt32("MeetingMinutes"); WOEGMChangeOfName.OthersMeetingMinutes = dr.GetString("OthersMeetingMinutes"); WOEGMChangeOfName.Designation = dr.GetString("Designation"); WOEGMChangeOfName.NoticeResolutionSource = dr.GetString("NoticeResolutionSource"); WOEGMChangeOfName.NoticeResolution = dr.GetInt32("NoticeResolution"); return WOEGMChangeOfName; }
public JsonResult SaveWOEGMChangeOfNameDetailsByWOID(WOEGMChangeOfName EGMChangeOfName) { System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); System.Reflection.MethodBase methodBase = stackFrame.GetMethod(); log.Debug("Start: " + methodBase.Name); try { int checkSession = UserLogin.AuthenticateRequest(); if (checkSession == 0) { return Json(checkSession); } else { var EGMChangeOfNameDetails = new WOEGMChangeOfName() { WOID = EGMChangeOfName.WOID, NewName = EGMChangeOfName.NewName, IsROPlaceOfMeeting = EGMChangeOfName.IsROPlaceOfMeeting, MAddressLine1 = EGMChangeOfName.MAddressLine1, MAddressLine2 = EGMChangeOfName.MAddressLine2, MAddressLine3 = EGMChangeOfName.MAddressLine3, MAddressCountry = EGMChangeOfName.MAddressCountry, MAddressPostalCode = EGMChangeOfName.MAddressPostalCode, MeetingNoticeSource = EGMChangeOfName.MeetingNoticeSource, MeetingNotice = EGMChangeOfName.MeetingNotice, MeetingMinutesSource = EGMChangeOfName.MeetingMinutesSource, MeetingMinutes = EGMChangeOfName.MeetingMinutes, OthersMeetingMinutes = EGMChangeOfName.OthersMeetingMinutes, Designation = EGMChangeOfName.Designation, NoticeResolutionSource = EGMChangeOfName.NoticeResolutionSource, NoticeResolution = EGMChangeOfName.NoticeResolution, ShareHoldingStructure = EGMChangeOfName.ShareHoldingStructure, SavedBy = checkSession }; checkSession = EGMChangeOfNameDetails.SaveWOEGMChangeOfNameDetailsByWOID(); return Json(checkSession); } } catch (Exception ex) { log.Error("Error: " + ex); return Json(""); } finally { log.Debug("End: " + methodBase.Name); } }