public JsonResult InsertWOAllotmentDetails(AllotmentDetails allotmentDetails)
{
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
{
int createdBy = Convert.ToInt32(Session["UserID"]);
int result = AllotmentDetails.InsertWOAllotmentDetails(allotmentDetails, createdBy);
return Json(result);
}
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return Json("");
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
private AllotmentDetails FetchWOAllot(AllotmentDetails WOAllotData, SafeDataReader dr)
{
WOAllotData.WOID = dr.GetInt32("WOID");
WOAllotData.ReturnOfAllotmentOfShares = dr.GetInt32("ReturnOfAllotmentOfShares");
WOAllotData.Currency = dr.GetInt32("Currency");
WOAllotData.ClassOfShare = dr.GetInt32("ClassOfShare");
WOAllotData.NumberOfNewSharesToBeAllotted = dr.GetString("NumberOfNewSharesToBeAllotted");
WOAllotData.ConsiderationOfEachShare = dr.GetString("ConsiderationOfEachShare");
WOAllotData.AmountToBeTreatedAsPaidOnEachShare = dr.GetString("AmountToBeTreatedAsPaidOnEachShare");
WOAllotData.TotalConsideration = dr.GetString("TotalConsideration");
WOAllotData.ResultantTotalNoOfIssuedShares = dr.GetString("ResultantTotalNoOfIssuedShares");
WOAllotData.ResultantIssuedCapital = dr.GetString("ResultantIssuedCapital");
WOAllotData.ResultantPaidUpCapital = dr.GetString("ResultantPaidUpCapital");
WOAllotData.MeetingNotice = dr.GetInt32("MeetingNotice");
WOAllotData.MeetingNoticeSource = dr.GetString("MeetingNoticeSource");
WOAllotData.MeetingMinutes = dr.GetInt32("MeetingMinutes");
WOAllotData.MeetingMinutesSource = dr.GetString("MeetingMinutesSource");
WOAllotData.OtherMeetingMinutes = dr.GetString("OtherMeetingMinutes");
WOAllotData.Designation = dr.GetString("DesignationOfThePersonSigningTheAllotment");
WOAllotData.NoticeOfResolution = dr.GetInt32("NoticeOfResolution");
WOAllotData.NoticeOfResolutionSource = dr.GetString("NoticeOfResolutionSource");
WOAllotData.F24F25 = dr.GetInt32("F24F25");
WOAllotData.F24F25Source = dr.GetString("F24F25Source");
WOAllotData.ShareholdingStructure = dr.GetInt32("ShareholdingStructure");
WOAllotData.IsROPlaceOfMeeting = dr.GetBoolean("IsROPlaceOfMeeting");
WOAllotData.MAddressLine1 = dr.GetString("MeetingAddressLine1");
WOAllotData.MAddressLine2 = dr.GetString("MeetingAddressLine2");
WOAllotData.MAddressLine3 = dr.GetString("MeetingAddressLine3");
WOAllotData.MAddressCountry = dr.GetInt32("MAddressCountry");
WOAllotData.MAddressPostalCode = dr.GetString("MPostalCode");
return WOAllotData;
}
/// <summary>
/// Description : To Get Work Order INCorpDetails.
/// Created By : Sudheer
/// Created Date : 30 July 2014
/// Modified By :
/// Modified Date:
/// </summary>
/// <returns></returns>
public static AllotmentDetails GetWOAllotmentDetails(string WOID)
{
var WOAllotData = new AllotmentDetails();
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(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "[SpGetWOAllotmentDetails]", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
WOAllotData.FetchWOAllot(WOAllotData, safe);
}
return WOAllotData;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return WOAllotData;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
/// <summary>
/// Description : To Insert Work Order WOAllotmentDetails.
/// Created By : Sudheer
/// Created Date : 4th Aug 2014
/// Modified By :
/// Modified Date:
/// </summary>
/// <returns></returns>
public static int InsertWOAllotmentDetails(AllotmentDetails WOAlloatDetails, int CreatedBy)
{
int output = -2;
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
try
{
SqlParameter[] sqlParams = new SqlParameter[29];
sqlParams[0] = new SqlParameter("@CreatedBy", CreatedBy);
sqlParams[1] = new SqlParameter("@WOID", WOAlloatDetails.WOID);
sqlParams[2] = new SqlParameter("@ReturnOfAllotmentOfShares", WOAlloatDetails.ReturnOfAllotmentOfShares);
sqlParams[3] = new SqlParameter("@Currency", WOAlloatDetails.Currency);
sqlParams[4] = new SqlParameter("@ClassOfShare", WOAlloatDetails.ClassOfShare);
sqlParams[5] = new SqlParameter("@NumberOfNewSharesToBeAllotted", WOAlloatDetails.NumberOfNewSharesToBeAllotted);
sqlParams[6] = new SqlParameter("@ConsiderationOfEachShare", WOAlloatDetails.ConsiderationOfEachShare);
sqlParams[7] = new SqlParameter("@AmountToBeTreatedAsPaidOnEachShare", WOAlloatDetails.AmountToBeTreatedAsPaidOnEachShare);
sqlParams[8] = new SqlParameter("@TotalConsideration", WOAlloatDetails.TotalConsideration);
sqlParams[9] = new SqlParameter("@ResultantTotalNoOfIssuedShares", WOAlloatDetails.ResultantTotalNoOfIssuedShares);
sqlParams[10] = new SqlParameter("@ResultantIssuedCapital", WOAlloatDetails.ResultantIssuedCapital);
sqlParams[11] = new SqlParameter("@ResultantPaidUpCapital", WOAlloatDetails.ResultantPaidUpCapital);
sqlParams[12] = new SqlParameter("@MeetingNotice", WOAlloatDetails.MeetingNotice);
sqlParams[13] = new SqlParameter("@MeetingNoticeSource", WOAlloatDetails.MeetingNoticeSource);
sqlParams[14] = new SqlParameter("@MeetingMinutes", WOAlloatDetails.MeetingMinutes);
sqlParams[15] = new SqlParameter("@MeetingMinutesSource", WOAlloatDetails.MeetingMinutesSource);
sqlParams[16] = new SqlParameter("@DesignationOfThePersonSigningTheAGM", WOAlloatDetails.Designation);
sqlParams[17] = new SqlParameter("@NoticeOfResolution", WOAlloatDetails.NoticeOfResolution);
sqlParams[18] = new SqlParameter("@NoticeOfResolutionSource", WOAlloatDetails.NoticeOfResolutionSource);
sqlParams[19] = new SqlParameter("@F24F25", WOAlloatDetails.F24F25);
sqlParams[20] = new SqlParameter("@F24F25Source", WOAlloatDetails.F24F25Source);
sqlParams[21] = new SqlParameter("@ShareholdingStructure", WOAlloatDetails.ShareholdingStructure);
sqlParams[22] = new SqlParameter("@OtherMeetingMinutes", WOAlloatDetails.OtherMeetingMinutes);
sqlParams[23] = new SqlParameter("@IsROPlaceOfMeeting", WOAlloatDetails.IsROPlaceOfMeeting);
sqlParams[24] = new SqlParameter("@MeetingAddressLine1", WOAlloatDetails.MAddressLine1);
sqlParams[25] = new SqlParameter("@MeetingAddressLine2", WOAlloatDetails.MAddressLine2);
sqlParams[26] = new SqlParameter("@MeetingAddressLine3", WOAlloatDetails.MAddressLine3);
sqlParams[27] = new SqlParameter("@MAddressCountry", WOAlloatDetails.MAddressCountry);
sqlParams[28] = new SqlParameter("@MPostalCode", WOAlloatDetails.MAddressPostalCode);
output = SqlHelper.ExecuteNonQuery(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SpInsertOrUpdateWOAllotmentDetails", sqlParams);
return output;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return output;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
/// <summary>
/// Description : To Save All WOInterimDividend Details.
/// Created By : Shiva
/// Created Date : 22 Aug 2014
/// Modified By :
/// Modified Date:
/// </summary>
/// <returns>WOInterimDividend Saved status.</returns>
public int SaveWoInterimDividendDetails()
{
int SavedStatus = -2;
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
try
{
var WOAllotData = new AllotmentDetails();
SqlParameter[] sqlParams = new SqlParameter[8];
sqlParams[0] = new SqlParameter("@WOID", this.WOID);
sqlParams[1] = new SqlParameter("@FinancialPeriod", HelperClasses.ConvertDateFormat(this.FinancialPeriod));
//sqlParams[2] = new SqlParameter("@ClassOfShare", DBNull.Value);
// sqlParams[3] = new SqlParameter("@DividendPerShare", this.DividendPerShare);
// sqlParams[5] = new SqlParameter("@TotalAmount", this.TotalAmount);
sqlParams[2] = new SqlParameter("@DateOfDeclaration", HelperClasses.ConvertDateFormat(this.DateOfDeclaration));
sqlParams[3] = new SqlParameter("@DateOfPayment", HelperClasses.ConvertDateFormat(this.DateOfPayment));
sqlParams[4] = new SqlParameter("@DividendDirector", this.DividendDirector);
sqlParams[5] = new SqlParameter("@DividendSource", this.DividendSource);
sqlParams[6] = new SqlParameter("@SavedBy", this.SavedBy);
// sqlParams[11] = new SqlParameter("@TotalShares", this.TotalShares);
SavedStatus = SqlHelper.ExecuteNonQuery(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SpSaveWOInterimDividendDetails", sqlParams);
return SavedStatus;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return SavedStatus;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
