public JsonResult SaveWOEGMDetails(WOEGMAcquisitionDisposal EGMData) { 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 objEGMData = new WOEGMAcquisitionDisposal() { MeetingNotice = EGMData.MeetingNotice, MeetingNoticeSource = EGMData.MeetingNoticeSource, MeetingMinutes = EGMData.MeetingMinutes, MeetingMinutesSource = EGMData.MeetingMinutesSource, OthersMeetingMinutes = EGMData.OthersMeetingMinutes, Designation = EGMData.Designation, ShareHoldingStructure = EGMData.ShareHoldingStructure, ConsiderationCurrency = EGMData.ConsiderationCurrency, ConsiderationAmount = EGMData.ConsiderationAmount, NameVendor = EGMData.NameVendor, IsROPlaceOfMeeting = EGMData.IsROPlaceOfMeeting, MeetingAddressLine1 = EGMData.MeetingAddressLine1, MeetingAddressLine2 = EGMData.MeetingAddressLine2, MeetingAddressLine3 = EGMData.MeetingAddressLine3, MeetingAddressCountry = EGMData.MeetingAddressCountry, MeetingAddressPostalCode = EGMData.MeetingAddressPostalCode, PropertyAddressLine1 = EGMData.PropertyAddressLine1, PropertyAddressLine2 = EGMData.PropertyAddressLine2, PropertyAddressLine3 = EGMData.PropertyAddressLine3, PropertyAddressCountry = EGMData.PropertyAddressCountry, PropertyAddressPostalCode = EGMData.PropertyAddressPostalCode, SavedBy = checkSession, WOID = EGMData.WOID, TypeOfTransaction = EGMData.TypeOfTransaction }; checkSession = objEGMData.SaveWOEGMDetails(); return Json(checkSession); } } catch (Exception ex) { log.Error("Error: " + ex); return Json(""); } finally { log.Debug("End: " + methodBase.Name); } }
private WOEGMAcquisitionDisposal FetchCompanyDetailsByWOID(WOEGMAcquisitionDisposal GetDetails, SafeDataReader dr, bool IsFMGAddress) { if (IsFMGAddress) { string[] str = dr.GetString("AddressLine1").Split(';'); GetDetails.MeetingAddressLine1 = str[0]; GetDetails.MeetingAddressLine2 = str[1]; GetDetails.MeetingAddressLine3 = str[2]; GetDetails.MeetingAddressPostalCode = str[3]; } else { GetDetails.MeetingAddressLine1 = dr.GetString("AddressLine1"); GetDetails.MeetingAddressLine2 = dr.GetString("AddressLine2"); GetDetails.MeetingAddressLine3 = dr.GetString("AddressLine3"); GetDetails.MeetingAddressPostalCode = dr.GetString("AddressPostalCode"); } GetDetails.MeetingAddressCountry = dr.GetInt32("countryid"); GetDetails.MeetingAddressCountryName = dr.GetString("AddressCountry"); return GetDetails; }
private WOEGMAcquisitionDisposal FetchEGMByWOID(WOEGMAcquisitionDisposal GetDetails, SafeDataReader dr) { GetDetails.WOID = dr.GetInt32("WOID"); GetDetails.MeetingNotice = dr.GetString("MeetingNotice"); GetDetails.MeetingNoticeSource = dr.GetString("MeetingNoticeSource"); GetDetails.MeetingMinutes = dr.GetString("MeetingMinutes"); GetDetails.MeetingMinutesSource = dr.GetString("MeetingMinutesSource"); GetDetails.OthersMeetingMinutes = dr.GetString("OthersMeetingMinutes"); GetDetails.Designation = dr.GetString("Designation"); GetDetails.ShareHoldingStructure = dr.GetInt32("ShareHoldingStructure"); GetDetails.ConsiderationCurrency = dr.GetInt32("ConsiderationCurrency"); GetDetails.ConsiderationAmount = dr.GetString("ConsiderationAmount"); GetDetails.NameVendor = dr.GetString("NameVendor"); GetDetails.IsROPlaceOfMeeting = dr.GetBoolean("ISROPlaceOfMeeting"); GetDetails.MeetingAddressLine1 = dr.GetString("MeetingAddressLine1"); GetDetails.MeetingAddressLine2 = dr.GetString("MeetingAddressLine2"); GetDetails.MeetingAddressLine3 = dr.GetString("MeetingAddressLine3"); GetDetails.MeetingAddressCountry = dr.GetInt32("MeetingAddressCountry"); GetDetails.MeetingAddressPostalCode = dr.GetString("MeetingAddressPostalCode"); GetDetails.PropertyAddressLine1 = dr.GetString("PropertyAddressLine1"); GetDetails.PropertyAddressLine2 = dr.GetString("PropertyAddressLine2"); GetDetails.PropertyAddressLine3 = dr.GetString("PropertyAddressLine3"); GetDetails.PropertyAddressCountry = dr.GetInt32("PropertyAddressCountry"); GetDetails.PropertyAddressPostalCode = dr.GetString("PropertyAddressPostalCode"); return GetDetails; }
/// <summary> /// Description : To Get EGM Details by WOID. /// Created By : Shiva /// Created Date : 2nd Sep 2014 /// Modified By : /// Modified Date: /// </summary> /// <returns>EGM Details.</returns> public static WOEGMAcquisitionDisposal GetEGMDetailsByWOID(int WOID) { var WOEGMData = new WOEGMAcquisitionDisposal(); 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, "SPGetEGMDetailsByWOID", sqlParams); var safe = new SafeDataReader(reader); while (reader.Read()) { WOEGMData.FetchEGMByWOID(WOEGMData, safe); } return WOEGMData; } catch (Exception ex) { log.Error("Error: " + ex); return WOEGMData; } finally { log.Debug("End: " + methodBase.Name); } }