/// <summary> /// Line Item Input Validation /// </summary> /// <param name="input"></param> /// <returns></returns> public IDPProxyResponse ValidationLineItem(LineItem input) { IDPProxyResponse message = null; Regex junk_Chars = new Regex(@"[\\\~!@#$%^*()_+{}|""?`;',/[\]]+"); //Line Item Validation if (string.IsNullOrEmpty(input.dataSource) | junk_Chars.IsMatch(input.dataSource)) { message = new IDPProxyResponse(Constant.RESPONSE_FAILURE, Constant.ERR_VALIDATION + Constant.dataSource); } else if (!(input.dataSource.Equals(Constant.PAS) | input.dataSource.Equals(Constant.SIS) | input.dataSource.Equals(Constant.HDES) | input.dataSource.Equals(Constant.ADES) | input.dataSource.Equals(Constant.HUON) | input.dataSource.Equals(Constant.PUPSYS) | input.dataSource.Equals(Constant.HLSYS))) { message = new IDPProxyResponse(Constant.RESPONSE_FAILURE, Constant.ERR_VALIDATION + Constant.dataSource); } else if (string.IsNullOrEmpty(input.writingCompany) | junk_Chars.IsMatch(input.writingCompany)) { message = new IDPProxyResponse(Constant.RESPONSE_FAILURE, Constant.ERR_VALIDATION + Constant.writingCompany); } else if (!(input.writingCompany.Equals(Constant.writingcompany_CSIIB) | (input.writingCompany.Equals(Constant.writingcompany_4WUIC)) | (input.writingCompany.Equals(Constant.writingcompany_1MWIC)))) { message = new IDPProxyResponse(Constant.RESPONSE_FAILURE, Constant.ERR_VALIDATION + Constant.writingCompany); } else if (string.IsNullOrEmpty(input.productCode) | junk_Chars.IsMatch(input.productCode)) { message = new IDPProxyResponse(Constant.RESPONSE_FAILURE, Constant.ERR_VALIDATION + Constant.productCode); } else if (!(input.productCode.Equals(Constant.ProductCode_PA) | input.productCode.Equals(Constant.ProductCode_HO) | input.productCode.Equals(Constant.ProductCode_HL) | input.productCode.Equals(Constant.ProductCode_PU) | input.productCode.Equals(Constant.ProductCode_DF) | input.productCode.Equals(Constant.ProductCode_MC) | input.productCode.Equals(Constant.ProductCode_WC) | input.productCode.Equals(Constant.ProductCode_IM))) { message = new IDPProxyResponse(Constant.RESPONSE_FAILURE, Constant.ERR_VALIDATION + Constant.productCode); } else if (!string.IsNullOrEmpty(input.policyPrefix)) { if (junk_Chars.IsMatch(input.policyPrefix)) { message = new IDPProxyResponse(Constant.RESPONSE_FAILURE, Constant.ERR_VALIDATION + Constant.policyPrefix); } } else if (string.IsNullOrEmpty(input.policyNumber) | junk_Chars.IsMatch(input.policyNumber)) { message = new IDPProxyResponse(Constant.RESPONSE_FAILURE, Constant.ERR_VALIDATION + Constant.policyNumber); } else if (!string.IsNullOrEmpty(input.policyState)) { if (junk_Chars.IsMatch(input.policyState)) { message = new IDPProxyResponse(Constant.RESPONSE_FAILURE, Constant.ERR_VALIDATION + Constant.policyState); } } else if (string.IsNullOrEmpty(input.Amount.ToString()) | junk_Chars.IsMatch(input.Amount.ToString())) { message = new IDPProxyResponse(Constant.RESPONSE_FAILURE, Constant.ERR_VALIDATION + Constant.Amount); } else if (!string.IsNullOrEmpty(input.revenueType)) { if (junk_Chars.IsMatch(input.revenueType)) { message = new IDPProxyResponse(Constant.RESPONSE_FAILURE, Constant.ERR_VALIDATION + Constant.revenueType); } } else { message = new IDPProxyResponse(Constant.RESPONSE_SUCCESS, ""); } return(message); }
/// <summary> /// Method to insert the items based on line items /// </summary> /// <param name="input"></param> /// <param name="paymentid"></param> /// <param name="checknumber"></param> /// <param name="paymentMethod"></param> /// <returns></returns> public string InsertItem(LineItem input, string paymentid, string checknumber, string paymentMethod, int lineItemCount) { try { using (SqlConnection conn = new SqlConnection(connstring)) { if (input.revenueType == null) { input.revenueType = string.Empty; } if (input.policyState == null) { input.policyState = string.Empty; } if (input.policyPrefix == null) { input.policyPrefix = string.Empty; } if (checknumber == null) { checknumber = string.Empty; } conn.Open(); SqlCommand comm = new SqlCommand(); comm.Connection = conn; comm.CommandType = System.Data.CommandType.StoredProcedure; comm.CommandText = Constant.SP_INSERT_ITEM; comm.Parameters.AddWithValue("@PaymentId", paymentid); comm.Parameters.AddWithValue("@LineItemNo", lineItemCount); comm.Parameters.AddWithValue("@productCode", input.productCode); comm.Parameters.AddWithValue("@Amount", input.Amount); comm.Parameters.AddWithValue("@lastName", ""); comm.Parameters.AddWithValue("@firstName", ""); comm.Parameters.AddWithValue("@policyNumber", input.policyNumber); comm.Parameters.AddWithValue("@revenueType", input.revenueType); comm.Parameters.AddWithValue("@policyState", input.policyState); comm.Parameters.AddWithValue("@policyPrefix", input.policyPrefix); comm.Parameters.AddWithValue("@companyID", input.writingCompany); comm.Parameters.AddWithValue("@checkNumber", checknumber); //MAIG - CH2 - BEGIN - Added the below code to support the newly added mailing Zip parameter comm.Parameters.AddWithValue("@mailingZip", ""); //MAIG - CH2 - END - Added the below code to support the newly added mailing Zip parameter comm.Parameters.AddWithValue("@paymentTypeID", paymentMethod); string result = (comm.ExecuteNonQuery()).ToString(); return(result); } } catch (FaultException ex) { log.WriteLog(ex.Message.ToString()); } catch (CommunicationException exp) { log.WriteLog(exp.Message.ToString()); } catch (Exception e) { string Error = e.Message.ToString() + e.StackTrace.ToString(); log.WriteLog(Error.ToString()); return(Error); } return(string.Empty); }