private WOTakeOver FetchTakeOverDetails(WOTakeOver WOTAKOData, SafeDataReader dr)
{
WOTAKOData.CompanyName = dr.GetString("CompanyName");
WOTAKOData.RegistrationNo = dr.GetString("RegistrationNo");
WOTAKOData.ClientID = dr.GetInt32("ClientID");
WOTAKOData.ClientSource = dr.GetString("ClientSource");
WOTAKOData.DateAccBeLaid = dr.GetString("DateAccBeLaid");
WOTAKOData.Currency = dr.GetInt32("Currency");
WOTAKOData.ClassOfShare = dr.GetInt32("ClassOfShare");
WOTAKOData.NewAllottedShares = dr.GetString("NewAllottedShares");
WOTAKOData.EachShare = dr.GetString("ConsiderationOfEachShare");
WOTAKOData.AmountPaidToEachShare = dr.GetString("AmountPaidToEachShare");
WOTAKOData.TotalConsideration = dr.GetString("TotalConsideration");
WOTAKOData.NoOfIssuedShares = dr.GetString("ResultantNoOfIssuedShares");
WOTAKOData.IssuedCapital = dr.GetString("IssuedCapital");
WOTAKOData.IsFMRegisteredAddress = dr.GetBoolean("IsFMRegisteredAddress");
WOTAKOData.AddressLine1 = dr.GetString("AddressLine1");
WOTAKOData.AddressLine2 = dr.GetString("AddressLine2");
WOTAKOData.AddressLine3 = dr.GetString("AddressLine3");
WOTAKOData.AddressCountry = dr.GetInt32("AddressCountry");
WOTAKOData.AddressPostalCode = dr.GetString("AddressPostalCode");
WOTAKOData.OutGoingAuditor = dr.GetString("OutGoingAuditor");
WOTAKOData.Auditor = dr.GetString("Auditor");
WOTAKOData.MeetingNotice = dr.GetString("MeetingNotice");
WOTAKOData.MeetingMinutes = dr.GetString("MeetingMinutes");
WOTAKOData.Designation = dr.GetString("Designation");
WOTAKOData.NoticeResolution = dr.GetString("NoticeResolution");
WOTAKOData.F24F25ID = dr.GetString("F24F25ID");
WOTAKOData.ShareHoldingStructure = dr.GetInt32("ShareHoldingStructure");
WOTAKOData.ResultantPaidupCapital = dr.GetString("ResultantPaidupCapital");
return WOTAKOData;
}
public JsonResult SaveWOTakeOverDetailsByWOID(WOTakeOver TakeOverData)
{
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 CompanyDetails = new WOTakeOver()
{
WOID = TakeOverData.WOID,
CompanyName = TakeOverData.CompanyName,
RegistrationNo = TakeOverData.RegistrationNo,
DateAccBeLaid = TakeOverData.DateAccBeLaid,
// AllotmentShares = TakeOverData.AllotmentShares,
Currency = TakeOverData.Currency,
ClassOfShare = TakeOverData.ClassOfShare,
NewAllottedShares = TakeOverData.NewAllottedShares,
EachShare = TakeOverData.EachShare,
AmountPaidToEachShare = TakeOverData.AmountPaidToEachShare,
TotalConsideration = TakeOverData.TotalConsideration,
NoOfIssuedShares = TakeOverData.NoOfIssuedShares,
IssuedCapital = TakeOverData.IssuedCapital,
ResultantPaidupCapital = TakeOverData.ResultantPaidupCapital,
IsFMRegisteredAddress = TakeOverData.IsFMRegisteredAddress,
AddressLine1 = TakeOverData.AddressLine1,
AddressLine2 = TakeOverData.AddressLine2,
AddressLine3 = TakeOverData.AddressLine3,
AddressCountry = TakeOverData.AddressCountry,
AddressPostalCode = TakeOverData.AddressPostalCode,
Auditor = TakeOverData.Auditor,
OutGoingAuditor = TakeOverData.OutGoingAuditor,
MeetingNotice = TakeOverData.MeetingNotice,
MeetingMinutes = TakeOverData.MeetingMinutes,
Designation = TakeOverData.Designation,
NoticeResolution = TakeOverData.NoticeResolution,
F24F25ID = TakeOverData.F24F25ID,
ShareHoldingStructure = TakeOverData.ShareHoldingStructure,
SavedBy = checkSession
};
checkSession = CompanyDetails.SaveWOTakeOverDetails();
return Json(checkSession);
}
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return Json("");
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
/// <summary>
/// Description : To Get TakeOver Details by WOID.
/// Created By : Sudheer
/// Created Date : 20th Oct 2014
/// Modified By :
/// Modified Date:
/// </summary>
/// <returns>ECE Details.</returns>
public static WOTakeOver GetWOTakeOverDetailsByWOID(int WOID)
{
var WOTAKOData = new WOTakeOver();
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, "SPGetWOTakeOverDetailsByWOID", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
WOTAKOData.FetchTakeOverDetails(WOTAKOData, safe);
}
return WOTAKOData;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return WOTAKOData;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}