public JsonResult InsertWOINCORPDetails(InCorpDetails incorpdetails) { int checkSession = UserLogin.AuthenticateRequest(); if (checkSession == 0) { return Json(checkSession); } else { try { incorpdetails.FinancialYearEnd = (incorpdetails.FinancialYearEnd != null ? HelperClasses.ConvertDateFormatDDMM(incorpdetails.FinancialYearEnd) : ""); incorpdetails.FirstFinancialYearEnd = (incorpdetails.FirstFinancialYearEnd != null ? Convert.ToDateTime(incorpdetails.FirstFinancialYearEnd).ToString("MM/dd/yyyy") : ""); int createdBy = Convert.ToInt32(Session["UserID"]); int result = InCorpDetails.InsertWOInCorpDetails(incorpdetails, createdBy); return Json(result); } catch (Exception ex) { if (ex.Message.IndexOf("The DateTime represented by the string is not supported in calendar System.Globalization.GregorianCalendar") > -1 || ex.Message.IndexOf("String was not recognized as a valid DateTime.") > -1) return Json(-2); else return Json(-1); } } }
/// <summary> /// Description : To Insert Work Order INCorpDetails. /// Created By : Sudheer /// Created Date : 30 July 2014 /// Modified By : /// Modified Date: /// </summary> /// <returns></returns> public static int InsertWOInCorpDetails(InCorpDetails WOInCorpDetails, 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[35]; sqlParams[0] = new SqlParameter("@WOID", WOInCorpDetails.WOID); sqlParams[1] = new SqlParameter("@CompanyName", WOInCorpDetails.CompanyName); sqlParams[2] = new SqlParameter("@ClientNo", WOInCorpDetails.ClientNo); if (WOInCorpDetails.IncropDate == null) sqlParams[3] = new SqlParameter("@IncropDate", DBNull.Value); else sqlParams[3] = new SqlParameter("@IncropDate", HelperClasses.ConvertDateFormat(WOInCorpDetails.IncropDate)); sqlParams[4] = new SqlParameter("@RegistrationNo", WOInCorpDetails.RegistrationNo); sqlParams[5] = new SqlParameter("@TypeofCompany", WOInCorpDetails.TypeofCompany); sqlParams[6] = new SqlParameter("@FMGasRegisteredAddress", WOInCorpDetails.FMGasRegisteredAddress); sqlParams[7] = new SqlParameter("@AddressLine1", WOInCorpDetails.AddressLine1); sqlParams[8] = new SqlParameter("@AddressLine2", WOInCorpDetails.AddressLine2); sqlParams[9] = new SqlParameter("@AddressLine3", WOInCorpDetails.AddressLine3); sqlParams[10] = new SqlParameter("@Country", WOInCorpDetails.Country); sqlParams[11] = new SqlParameter("@PostalCode", WOInCorpDetails.PostalCode); if (WOInCorpDetails.FinancialYearEnd == "") sqlParams[12] = new SqlParameter("@FinancialYearEnd", DBNull.Value); else sqlParams[12] = new SqlParameter("@FinancialYearEnd", WOInCorpDetails.FinancialYearEnd); if (WOInCorpDetails.FirstFinancialYearEnd == "") sqlParams[13] = new SqlParameter("@FirstFinancialYearEnd", DBNull.Value); else sqlParams[13] = new SqlParameter("@FirstFinancialYearEnd", WOInCorpDetails.FirstFinancialYearEnd); sqlParams[14] = new SqlParameter("@Currency", WOInCorpDetails.Currency); sqlParams[15] = new SqlParameter("@ClassofShare", WOInCorpDetails.ClassofShare); sqlParams[16] = new SqlParameter("@PaidupCapital", WOInCorpDetails.PaidupCapital); sqlParams[17] = new SqlParameter("@AmountPaidupperShare", WOInCorpDetails.AmountPaidupperShare); sqlParams[18] = new SqlParameter("@ActivityOne", WOInCorpDetails.ActivityOne); sqlParams[19] = new SqlParameter("@ActivityOneDescription", WOInCorpDetails.ActivityOneDescription); sqlParams[20] = new SqlParameter("@ActivityTwo", WOInCorpDetails.ActivityTwo); sqlParams[21] = new SqlParameter("@ActivityTwoDescription", WOInCorpDetails.ActivityTwoDescription); sqlParams[22] = new SqlParameter("@CreatedBy", CreatedBy); sqlParams[29] = new SqlParameter("@AmountGuaranteedByEachMember", WOInCorpDetails.AmountGuaranteedByEachMember); sqlParams[30] = new SqlParameter("@GuaranteedAmountCurrency", WOInCorpDetails.GuaranteedAmountCurrency); sqlParams[31] = new SqlParameter("@FMGClient ", WOInCorpDetails.FMGClient); sqlParams[32] = new SqlParameter("@ClientType", WOInCorpDetails.ClientType); sqlParams[33] = new SqlParameter("@IncorporationCountry", WOInCorpDetails.IncorporationCountry); sqlParams[34] = new SqlParameter("@CompanyStatus", WOInCorpDetails.CompanyStatus); output = SqlHelper.ExecuteNonQuery(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "[SpInsertOrUpdateWOIncorpDetails]", sqlParams); return output; } catch (Exception ex) { log.Error("Error: " + ex); return output; } finally { log.Debug("End: " + methodBase.Name); } }
private InCorpDetails FetchWOInCorp(InCorpDetails WOIncorpData, SafeDataReader dr) { WOIncorpData.WOID = dr.GetInt32("WOID"); WOIncorpData.CompanyName = dr.GetString("CompanyName"); WOIncorpData.ClientNo = dr.GetString("ClientNo"); WOIncorpData.ClientID = dr.GetInt32("ClientID"); WOIncorpData.ClientSource = dr.GetString("ClientSource"); WOIncorpData.IncropDate = dr.GetDateTime("IncropDate").ToString("dd/MM/yyyy") == "01/01/0001" ? "" : dr.GetDateTime("IncropDate").ToString("dd/MM/yyyy"); WOIncorpData.RegistrationNo = dr.GetString("RegistrationNo"); WOIncorpData.TypeofCompany = dr.GetString("TypeofCompany"); WOIncorpData.FMGasRegisteredAddress = dr.GetBoolean("FMGasRegisteredAddress"); WOIncorpData.AddressLine1 = dr.GetString("AddressLine1"); WOIncorpData.AddressLine2 = dr.GetString("AddressLine2"); WOIncorpData.AddressLine3 = dr.GetString("AddressLine3"); WOIncorpData.Country = dr.GetString("Country"); WOIncorpData.PostalCode = dr.GetString("PostalCode"); WOIncorpData.FinancialYearEnd = dr.GetDateTime("FinancialYearEnd").ToString("dd MMMM"); //== "01 January" ? "" : dr.GetDateTime("FinancialYearEnd").ToString("dd MMMM"); WOIncorpData.FirstFinancialYearEnd = dr.GetDateTime("FirstFinancialYearEnd").ToString("dd MMMM yyyy") == "01 January 0001" ? "" : dr.GetDateTime("FirstFinancialYearEnd").ToString("dd MMMM yyyy"); WOIncorpData.Currency = dr.GetString("Currency"); WOIncorpData.ClassofShare = dr.GetString("ClassofShare"); WOIncorpData.PaidupCapital = dr.GetDecimal("PaidupCapital"); WOIncorpData.AmountPaidupperShare = dr.GetDecimal("AmountPaidupperShare"); WOIncorpData.ActivityOne = dr.GetString("ActivityOne"); WOIncorpData.ActivityOneDescription = dr.GetString("ActivityOneDescription"); WOIncorpData.ActivityTwo = dr.GetString("ActivityTwo"); WOIncorpData.ActivityTwoDescription = dr.GetString("ActivityTwoDescription"); WOIncorpData.AmountGuaranteedByEachMember = dr.GetDecimal("AmountGuaranteedByEachMember"); WOIncorpData.GuaranteedAmountCurrency = dr.GetString("GuaranteedAmountCurrency"); WOIncorpData.FMGClient = dr.GetBoolean("FMGClient"); WOIncorpData.ClientType = dr.GetInt32("ClientType"); WOIncorpData.IncorporationCountry = dr.GetInt32("IncorporationCountry"); WOIncorpData.CompanyStatus = dr.GetInt32("CompanyStatus"); return WOIncorpData; }
/// <summary> /// Description : To Get Work Order INCorpDetails. /// Created By : Sudheer /// Created Date : 30 July 2014 /// Modified By : /// Modified Date: /// </summary> /// <returns></returns> public static InCorpDetails GetWOIncorpDetails(string WOID) { var WOIncorpData = new InCorpDetails(); 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, "[SpGetWOIncorpDetails]", sqlParams); var safe = new SafeDataReader(reader); while (reader.Read()) { WOIncorpData.FetchWOInCorp(WOIncorpData, safe); } //safe.NextResult(); //while (reader.Read()) //{ // WOIncorpData.CompanyName = Convert.ToString(safe["CompanyName"]); // WOIncorpData.RegistrationNo = Convert.ToString(safe["RegistrationNo"]); //} return WOIncorpData; } catch (Exception ex) { log.Error("Error: " + ex); return WOIncorpData; } finally { log.Debug("End: " + methodBase.Name); } }