public JsonResult InsertWOAGMDetails(AGMDetails AGMDetails)
{
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 result = AGMDetails.InsertWOAGMDetails(AGMDetails, checkSession);
return Json(result);
}
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return Json("");
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
/// <summary>
/// Description : To Insert Work Order AGM Details.
/// Created By : Pavan
/// Created Date : 25 July 2014
/// Modified By : Shiva
/// Modified Date: 26 Aug 2014
/// </summary>
/// <returns></returns>
public static int InsertWOAGMDetails(AGMDetails AGMDetails, 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[37];
sqlParams[0] = new SqlParameter("@WOID", AGMDetails.WOIDForWoAGM);
sqlParams[1] = new SqlParameter("@DateofAGM", HelperClasses.ConvertDateFormat(AGMDetails.DateOfAGM));
sqlParams[2] = new SqlParameter("@TimeofAGM", AGMDetails.TimeOfAGM);
sqlParams[3] = new SqlParameter("@FinancialYearEnd", HelperClasses.ConvertDateFormat(AGMDetails.FinancialYearEnd));
sqlParams[4] = new SqlParameter("@DateofFinancialStatement", HelperClasses.ConvertDateFormat(AGMDetails.DateOfFinancialStatement));
sqlParams[5] = new SqlParameter("@IsAuditor", AGMDetails.IsAuditor);
sqlParams[6] = new SqlParameter("@Auditors", AGMDetails.Auditors);
sqlParams[7] = new SqlParameter("@ShareHoldingStructure", AGMDetails.ShareHoldingStructure);
sqlParams[8] = new SqlParameter("@IsDirectorsFeeAmount", AGMDetails.IsDirectorsFeeAmount);
sqlParams[9] = new SqlParameter("@DirectorFeeAmount", AGMDetails.DirectorFeeAmount);
sqlParams[10] = new SqlParameter("@DirectorCurrency", AGMDetails.DirectorCurrency);
sqlParams[11] = new SqlParameter("@IsRemunerationAmount", AGMDetails.IsRemunerationAmount);
sqlParams[12] = new SqlParameter("@RemunerationAmount", AGMDetails.RemunerationAmount);
sqlParams[13] = new SqlParameter("@RemunerationCurrency", AGMDetails.RemunerationCurrency);
sqlParams[14] = new SqlParameter("@MeetingNotice", Convert.ToInt32(AGMDetails.MeetingNotice));
sqlParams[15] = new SqlParameter("@MeetingNoticeSource", AGMDetails.MeetingNoticeSource);
sqlParams[16] = new SqlParameter("@MeetingMinutes", Convert.ToInt32(AGMDetails.MeetingMinutes));
sqlParams[17] = new SqlParameter("@MeetingMinutesSource", AGMDetails.MeetingMinutesSource);
sqlParams[18] = new SqlParameter("@DesignationofPersonSigningAGM", AGMDetails.DesignationofPersonSigningAGM);
sqlParams[19] = new SqlParameter("@S197Certificate", Convert.ToInt32(AGMDetails.S197Certificate));
sqlParams[20] = new SqlParameter("@S197CertificateSource", AGMDetails.S197CertificateSource);
sqlParams[21] = new SqlParameter("@IsS161toIssueShares", AGMDetails.IsS161toIssueShares);
sqlParams[22] = new SqlParameter("@S161NoticeofResolution", Convert.ToInt32(AGMDetails.S161NoticeofResolution));
sqlParams[23] = new SqlParameter("@S161NoticeofResolutionSource", AGMDetails.S161NoticeofResolutionSource);
sqlParams[24] = new SqlParameter("@DividentVoucher", Convert.ToInt32(AGMDetails.DividentVoucher));
sqlParams[25] = new SqlParameter("@DividentVoucherSource", AGMDetails.DividentVoucherSource);
sqlParams[26] = new SqlParameter("@IsDirectorsdueforRetirement", AGMDetails.IsDirectorsdueforRetirement);
sqlParams[27] = new SqlParameter("@IsDividend", AGMDetails.IsDividend);
sqlParams[28] = new SqlParameter("@CreatedBy", CreatedBy);
sqlParams[29] = new SqlParameter("@OtherMeetingMinutes", AGMDetails.OtherMeetingMinutes);
sqlParams[30] = new SqlParameter("@ROPlaceofAGM", AGMDetails.ROPlaceOfAGM);
sqlParams[31] = new SqlParameter("@IsApprovalFS", AGMDetails.ApprovalFS);
sqlParams[32] = new SqlParameter("@MeetingAddressLine1", AGMDetails.MeetingAddressLine1);
sqlParams[33] = new SqlParameter("@MeetingAddressLine2", AGMDetails.MeetingAddressLine2);
sqlParams[34] = new SqlParameter("@MeetingAddressLine3", AGMDetails.MeetingAddressLine3);
sqlParams[35] = new SqlParameter("@MeetingAddressCountry", AGMDetails.MeetingAddressCountry);
sqlParams[36] = new SqlParameter("@MeetingAddressPostalCode", AGMDetails.MeetingAddressPostalCode);
output = SqlHelper.ExecuteNonQuery(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "[SpInsertOrUpdateWOAGMDetails]", sqlParams);
return output;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return output;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
private AGMDetails FetchWOAGMDetails(AGMDetails AGMDetails, SafeDataReader dr)
{
AGMDetails.ID = dr.GetInt32("ID");
AGMDetails.WOIDForWoAGM = dr.GetString("WOID");
AGMDetails.ROPlaceOfAGM = dr.GetBoolean("ROPlaceofAGM");
AGMDetails.DateOfAGM = dr.GetDateTime("DateofAGM").ToString("dd/MM/yyyy") == "01/01/0001" ? "" : dr.GetDateTime("DateofAGM").ToString("dd/MM/yyyy");
AGMDetails.TimeOfAGM = dr.GetString("TimeofAGM");
AGMDetails.FinancialYearEnd = dr.GetDateTime("FinancialYearEnd").ToString("dd/MM/yyyy") == "01/01/0001" ? "" : dr.GetDateTime("FinancialYearEnd").ToString("dd/MM/yyyy");
AGMDetails.DateOfFinancialStatement = dr.GetDateTime("DateofFinancialStatement").ToString("dd/MM/yyyy") == "01/01/0001" ? "" : dr.GetDateTime("DateofFinancialStatement").ToString("dd/MM/yyyy");
AGMDetails.IsAuditor = dr.GetBoolean("IsAuditor");
AGMDetails.Auditors = dr.GetInt32("Auditors");
AGMDetails.ShareHoldingStructure = dr.GetInt32("ShareHoldingStructure");
AGMDetails.IsDirectorsFeeAmount = dr.GetBoolean("IsDirectorsFeeAmount");
AGMDetails.DirectorFeeAmount = dr.GetString("DirectorFeeAmount");
AGMDetails.DirectorCurrency = dr.GetInt32("DirectorCurrency");
AGMDetails.IsRemunerationAmount = dr.GetBoolean("IsRemunerationAmount");
AGMDetails.RemunerationAmount = dr.GetString("RemunerationAmount");
AGMDetails.RemunerationCurrency = dr.GetInt32("RemunerationCurrency");
AGMDetails.MeetingNotice = dr.GetString("MeetingNotice");
AGMDetails.MeetingNoticeSource = dr.GetString("MeetingNoticeSource");
AGMDetails.MeetingMinutes = dr.GetString("MeetingMinutes");
AGMDetails.MeetingMinutesSource = dr.GetString("MeetingMinutesSource");
AGMDetails.OtherMeetingMinutes = dr.GetString("OtherMeetingMinutes");
AGMDetails.DesignationofPersonSigningAGM = dr.GetString("DesignationofPersonSigningAGM");
AGMDetails.S197Certificate = dr.GetString("S197Certificate");
AGMDetails.S197CertificateSource = dr.GetString("S197CertificateSource");
AGMDetails.IsS161toIssueShares = dr.GetBoolean("IsS161toIssueShares");
AGMDetails.S161NoticeofResolution = dr.GetString("S161NoticeofResolution");
AGMDetails.S161NoticeofResolutionSource = dr.GetString("S161NoticeofResolutionSource");
AGMDetails.DividentVoucher = dr.GetString("DividentVoucher");
AGMDetails.DividentVoucherSource = dr.GetString("DividentVoucherSource");
AGMDetails.IsDirectorsdueforRetirement = dr.GetBoolean("IsDirectorsdueforRetirement");
AGMDetails.IsDividend = dr.GetBoolean("IsDividend");
AGMDetails.Dividendpershare = dr.GetString("Dividendpershare");
AGMDetails.DividendCurrency = dr.GetInt32("DividendCurrency");
AGMDetails.TotalNetAmountofDividend = dr.GetString("TotalNetAmountofDividend");
AGMDetails.TotalNoOfShares = dr.GetString("TotalNoOfShares");
AGMDetails.ApprovalFS = dr.GetBoolean("IsApprovalFS");
AGMDetails.MeetingAddressLine1 = dr.GetString("MeetingAddressLine1");
AGMDetails.MeetingAddressLine2 = dr.GetString("MeetingAddressLine2");
AGMDetails.MeetingAddressLine3 = dr.GetString("MeetingAddressLine3");
AGMDetails.MeetingAddressCountry = dr.GetInt32("MeetingAddressCountry");
AGMDetails.MeetingAddressPostalCode = dr.GetString("MeetingAddressPostalCode");
return AGMDetails;
}
/// <summary>
/// Created By : Pavan
/// Created Date : 30 July 2014
/// Modified By :
/// Modified Date:
/// Description : Get WOAGMDetails by WOID
/// </summary>
/// <returns></returns>
public static AGMDetails GetWOAGMDetailsByWOID(int WOID)
{
var Details = new AGMDetails();
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, "SpGetWOAGMDetailsByWOID", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
Details.FetchWOAGMDetails(Details, safe);
}
return Details;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return Details;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}