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