public List <Project.Entity.Leads> getNewLeads(long PIN, long User_ID, string UserRole) { objResponse Response = new objResponse(); List <Project.Entity.Leads> Leads = new List <Project.Entity.Leads>(); try { SqlParameter[] sqlParameter = new SqlParameter[3]; sqlParameter[0] = new SqlParameter("@PIN", SqlDbType.BigInt, 10); sqlParameter[0].Value = PIN; sqlParameter[1] = new SqlParameter("@User_ID", SqlDbType.BigInt, 10); sqlParameter[1].Value = User_ID; sqlParameter[2] = new SqlParameter("@UserRole", SqlDbType.NVarChar, 20); sqlParameter[2].Value = UserRole; DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_GetNewLeads", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA); if (Response.ResponseData.Tables[0].Rows.Count > 0) { Response.ErrorCode = 0; foreach (DataRow dr in Response.ResponseData.Tables[0].Rows) { Project.Entity.Leads objLead = new Project.Entity.Leads(); objLead.Lead_ID_Auto_PK = Convert.ToInt64(dr["Lead_ID_Auto_PK"]); objLead.Name = Convert.ToString(dr["Name"]); objLead.Date = Convert.ToDateTime(dr["Date"]); if (dr["FutureFollowUp"].ToString() != "") { objLead.FollowUpDate = Convert.ToDateTime(dr["FutureFollowUp"]); } objLead.Email = Convert.ToString(dr["Email"]); objLead.SkypeNo = Convert.ToString(dr["SkypeNo"]); // objLead.HasAttachment = Convert.ToBoolean(dr["HasAttachment"]); objLead.Status = Convert.ToString(dr["Status"]); objLead.PIN = Convert.ToInt64(dr["PIN"]); objLead.AssignTo = dr["AssignTo"].ToString(); objLead.AssignToName = dr["AssignToUser"].ToString(); objLead.CreatedBy = dr["CreatedBy"].ToString(); Leads.Add(objLead); } } else { Response.ErrorCode = 2001; Response.ErrorMessage = "There is an Error. Please Try After some time."; } } catch (Exception ex) { Response.ErrorCode = 3001; Response.ErrorMessage = ex.Message.ToString(); BAL.Common.LogManager.LogError("getLead", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace)); } return(Leads); }
public objResponse ImportLead(Project.Entity.Leads objLead, string LogedUser, long PIN) { objResponse Response = new objResponse(); try { SqlParameter[] sqlParameter = new SqlParameter[23]; sqlParameter[0] = new SqlParameter("@Date", SqlDbType.Date, 50); sqlParameter[0].Value = DateTime.Now; sqlParameter[1] = new SqlParameter("@Name", SqlDbType.NVarChar, 80); sqlParameter[1].Value = objLead.Name; sqlParameter[2] = new SqlParameter("@CompanyName", SqlDbType.NVarChar, 80); sqlParameter[2].Value = objLead.CompanyName; sqlParameter[3] = new SqlParameter("@Email", SqlDbType.NVarChar, 50); sqlParameter[3].Value = objLead.Email; sqlParameter[4] = new SqlParameter("@Contact", SqlDbType.NVarChar, 13); sqlParameter[4].Value = objLead.ContactNo; sqlParameter[5] = new SqlParameter("@Skype", SqlDbType.NVarChar, 13); sqlParameter[5].Value = objLead.SkypeNo; sqlParameter[6] = new SqlParameter("@Category", SqlDbType.NVarChar, 30); sqlParameter[6].Value = objLead.Category_ID; sqlParameter[7] = new SqlParameter("@Zipcode", SqlDbType.NVarChar, 8); sqlParameter[7].Value = objLead.ZipCode; sqlParameter[8] = new SqlParameter("@Requirment", SqlDbType.NVarChar, 4000); sqlParameter[8].Value = objLead.Requirement; sqlParameter[9] = new SqlParameter("@CreatedBy", SqlDbType.NVarChar, 60); sqlParameter[9].Value = LogedUser; sqlParameter[10] = new SqlParameter("@CreatedDate", SqlDbType.DateTime, 50); sqlParameter[10].Value = DateTime.Now; sqlParameter[11] = new SqlParameter("@Status", SqlDbType.NVarChar, 20); sqlParameter[11].Value = "Working"; sqlParameter[12] = new SqlParameter("@Remarks", SqlDbType.NVarChar, 4000); sqlParameter[12].Value = objLead.Remarks; sqlParameter[13] = new SqlParameter("@AddressLine1", SqlDbType.NVarChar, 100); sqlParameter[13].Value = objLead.AddressLine1; sqlParameter[14] = new SqlParameter("@AddressLine2", SqlDbType.NVarChar, 100); sqlParameter[14].Value = objLead.AddressLine2; sqlParameter[15] = new SqlParameter("@State", SqlDbType.NVarChar, 80); sqlParameter[15].Value = objLead.State; sqlParameter[16] = new SqlParameter("@Country", SqlDbType.NVarChar, 80); sqlParameter[16].Value = objLead.Country; sqlParameter[17] = new SqlParameter("@FollowUpDate", SqlDbType.Date, 80); sqlParameter[17].Value = objLead.FollowUpDate; sqlParameter[18] = new SqlParameter("@Altername_Email", SqlDbType.NVarChar, 60); sqlParameter[18].Value = objLead.Alternate_Email; sqlParameter[19] = new SqlParameter("@Source", SqlDbType.NVarChar, 40); sqlParameter[19].Value = objLead.Source; sqlParameter[20] = new SqlParameter("@Model", SqlDbType.NVarChar, 50); sqlParameter[20].Value = objLead.Model; sqlParameter[21] = new SqlParameter("@City", SqlDbType.NVarChar, 50); sqlParameter[21].Value = objLead.City; sqlParameter[22] = new SqlParameter("@PIN", SqlDbType.BigInt, 10); sqlParameter[22].Value = PIN; DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_AddLead", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA); if (Response.ResponseData.Tables[0].Rows.Count > 0) { Response.ErrorCode = 0; Response.ErrorMessage = Response.ResponseData.Tables[0].Rows[0][0].ToString(); } else { Response.ErrorCode = 2001; Response.ErrorMessage = "There is an Error. Please Try After some time."; } } catch (Exception ex) { Response.ErrorCode = 3001; Response.ErrorMessage = ex.Message.ToString(); BAL.Common.LogManager.LogError("ImportLead", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace)); } return(Response); }
public objResponse UpdateLead(Project.Entity.Leads objLead, long LogedUser) { objResponse Response = new objResponse(); try { SqlParameter[] sqlParameter = new SqlParameter[17]; sqlParameter[0] = new SqlParameter("@Name", SqlDbType.NVarChar, 80); sqlParameter[0].Value = objLead.Name; sqlParameter[1] = new SqlParameter("@CompanyName", SqlDbType.NVarChar, 80); sqlParameter[1].Value = objLead.CompanyName; sqlParameter[2] = new SqlParameter("@Email", SqlDbType.NVarChar, 50); sqlParameter[2].Value = objLead.Email; sqlParameter[3] = new SqlParameter("@Contact", SqlDbType.NVarChar, 13); sqlParameter[3].Value = objLead.ContactNo; sqlParameter[4] = new SqlParameter("@Skype", SqlDbType.NVarChar, 13); sqlParameter[4].Value = objLead.SkypeNo; sqlParameter[5] = new SqlParameter("@Zipcode", SqlDbType.NVarChar, 8); sqlParameter[5].Value = objLead.ZipCode; sqlParameter[6] = new SqlParameter("@CreatedBy", SqlDbType.BigInt, 10); sqlParameter[6].Value = LogedUser; sqlParameter[7] = new SqlParameter("@CreatedDate", SqlDbType.DateTime, 50); sqlParameter[7].Value = DateTime.Now; sqlParameter[8] = new SqlParameter("@AddressLine1", SqlDbType.NVarChar, 100); sqlParameter[8].Value = objLead.AddressLine1; sqlParameter[9] = new SqlParameter("@AddressLine2", SqlDbType.NVarChar, 100); sqlParameter[9].Value = objLead.AddressLine2; sqlParameter[10] = new SqlParameter("@State", SqlDbType.NVarChar, 80); sqlParameter[10].Value = objLead.State; sqlParameter[11] = new SqlParameter("@Country", SqlDbType.NVarChar, 80); sqlParameter[11].Value = objLead.Country; sqlParameter[12] = new SqlParameter("@Altername_Email", SqlDbType.NVarChar, 60); sqlParameter[12].Value = objLead.Alternate_Email; sqlParameter[13] = new SqlParameter("@Source", SqlDbType.NVarChar, 40); sqlParameter[13].Value = objLead.Source; sqlParameter[14] = new SqlParameter("@City", SqlDbType.NVarChar, 50); sqlParameter[14].Value = objLead.City; sqlParameter[15] = new SqlParameter("@Lead_ID_PK", SqlDbType.BigInt, 50); sqlParameter[15].Value = objLead.Lead_ID_Auto_PK; sqlParameter[16] = new SqlParameter("@JobDescription", SqlDbType.NVarChar, 100); sqlParameter[16].Value = objLead.JobDescription; DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_UpdateLead", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA); if (Response.ResponseData.Tables[0].Rows.Count > 0) { Response.ErrorCode = 0; Response.ErrorMessage = Response.ResponseData.Tables[0].Rows[0][0].ToString(); } else { Response.ErrorCode = 2001; Response.ErrorMessage = "There is an Error. Please Try After some time."; } } catch (Exception ex) { Response.ErrorCode = 3001; Response.ErrorMessage = ex.Message.ToString(); BAL.Common.LogManager.LogError("UpdateLead", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace)); } return(Response); }
public objResponse editLeadStep1(Project.Entity.Leads objLeads) { objResponse Response = new objResponse(); try { SqlParameter[] sqlParameter = new SqlParameter[33]; sqlParameter[0] = new SqlParameter("@DBA", SqlDbType.NVarChar, 100); sqlParameter[0].Value = objLeads.DBA; sqlParameter[1] = new SqlParameter("@ContName", SqlDbType.NVarChar, 100); sqlParameter[1].Value = objLeads.ContName; sqlParameter[2] = new SqlParameter("@bPhone", SqlDbType.NVarChar, 13); sqlParameter[2].Value = objLeads.bPhone; sqlParameter[3] = new SqlParameter("@Email", SqlDbType.NVarChar, 100); sqlParameter[3].Value = objLeads.Email; sqlParameter[4] = new SqlParameter("@website", SqlDbType.NVarChar, 100); sqlParameter[4].Value = objLeads.website; sqlParameter[5] = new SqlParameter("@currProcessing", SqlDbType.NVarChar, 20); sqlParameter[5].Value = objLeads.currProcessing; sqlParameter[6] = new SqlParameter("@EstMontVolume", SqlDbType.NVarChar, 50); sqlParameter[6].Value = objLeads.EstMontVolume; sqlParameter[7] = new SqlParameter("@MerAppUsername", SqlDbType.NVarChar, 100); sqlParameter[7].Value = objLeads.MerAppUsername; sqlParameter[8] = new SqlParameter("@MerAppPassword", SqlDbType.NVarChar, 10); sqlParameter[8].Value = objLeads.MerAppPassword; sqlParameter[9] = new SqlParameter("@LBusiName", SqlDbType.NVarChar, 10); sqlParameter[9].Value = objLeads.LBusiName; sqlParameter[10] = new SqlParameter("@OwnershipType", SqlDbType.NVarChar, 100); sqlParameter[10].Value = objLeads.OwnershipType; sqlParameter[11] = new SqlParameter("@YrInBusiness", SqlDbType.NVarChar, 10); sqlParameter[11].Value = objLeads.YrInBusiness; sqlParameter[12] = new SqlParameter("@MtInBusiness", SqlDbType.NVarChar, 10); sqlParameter[12].Value = objLeads.MtInBusiness; sqlParameter[13] = new SqlParameter("@BDescription", SqlDbType.NVarChar, 500); sqlParameter[13].Value = objLeads.BDescription; sqlParameter[14] = new SqlParameter("@LAddress1", SqlDbType.NVarChar, 100); sqlParameter[14].Value = objLeads.LAddress1; sqlParameter[15] = new SqlParameter("@LAddress2", SqlDbType.NVarChar, 100); sqlParameter[15].Value = objLeads.LAddress2; sqlParameter[16] = new SqlParameter("@city", SqlDbType.NVarChar, 100); sqlParameter[16].Value = objLeads.city; sqlParameter[17] = new SqlParameter("@state", SqlDbType.NVarChar, 100); sqlParameter[17].Value = objLeads.state; sqlParameter[18] = new SqlParameter("@zip", SqlDbType.NVarChar, 10); sqlParameter[18].Value = objLeads.zip; sqlParameter[19] = new SqlParameter("@LPhoneNo", SqlDbType.NVarChar, 13); sqlParameter[19].Value = objLeads.LPhoneNo; sqlParameter[20] = new SqlParameter("@LFaxNo", SqlDbType.NVarChar, 13); sqlParameter[20].Value = objLeads.LFaxNo; sqlParameter[21] = new SqlParameter("@MAddress1", SqlDbType.NVarChar, 100); sqlParameter[21].Value = objLeads.MAddress1; sqlParameter[22] = new SqlParameter("@MAddress2", SqlDbType.NVarChar, 100); sqlParameter[22].Value = objLeads.MAddress2; sqlParameter[23] = new SqlParameter("@mcity", SqlDbType.NVarChar, 100); sqlParameter[23].Value = objLeads.mcity; sqlParameter[24] = new SqlParameter("@mstate", SqlDbType.NVarChar, 100); sqlParameter[24].Value = objLeads.mstate; sqlParameter[25] = new SqlParameter("@mzip", SqlDbType.NVarChar, 10); sqlParameter[25].Value = objLeads.mzip; sqlParameter[26] = new SqlParameter("@CreatedBy", SqlDbType.BigInt, 10); sqlParameter[26].Value = objLeads.CreatedBy; sqlParameter[27] = new SqlParameter("@Status", SqlDbType.NVarChar, 80); sqlParameter[27].Value = objLeads.LeadStatus; sqlParameter[28] = new SqlParameter("@LeadSource", SqlDbType.NVarChar, 80); sqlParameter[28].Value = objLeads.LeadSource; sqlParameter[29] = new SqlParameter("@LeadGroup", SqlDbType.NVarChar, 80); sqlParameter[29].Value = objLeads.LeadGroup; sqlParameter[30] = new SqlParameter("@AltNo", SqlDbType.NVarChar, 13); sqlParameter[30].Value = objLeads.AltNo; sqlParameter[31] = new SqlParameter("@Lead_ID", SqlDbType.BigInt, 13); sqlParameter[31].Value = objLeads.Lead_ID; sqlParameter[32] = new SqlParameter("@AssignToID", SqlDbType.BigInt, 13); sqlParameter[32].Value = objLeads.AssignToID; DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_EditLeadStep1", sqlParameter, DB_CONSTANTS.ConnectionString_ICS); if (Response.ResponseData.Tables[0].Rows.Count > 0) { Response.ErrorCode = 0; Response.ErrorMessage = Response.ResponseData.Tables[0].Rows[0][0].ToString();; } else { Response.ErrorCode = 2001; Response.ErrorMessage = "There is an Error. Please Try After some time."; } } catch (Exception ex) { Response.ErrorMessage = ex.Message.ToString(); BAL.Common.LogManager.LogError("editLeadStep1", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace)); } return(Response); }
public List <Project.Entity.Leads> getAllLeads(string logedUser, string UserRole) { objResponse Response = new objResponse(); List <Project.Entity.Leads> leads = new List <Project.Entity.Leads>(); try { SqlParameter[] sqlParameter = new SqlParameter[2]; sqlParameter[0] = new SqlParameter("@logedUser", SqlDbType.BigInt, 10); sqlParameter[0].Value = Convert.ToInt64(logedUser); sqlParameter[1] = new SqlParameter("@UserRole", SqlDbType.NVarChar, 50); sqlParameter[1].Value = UserRole; DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_GetAllLeads", sqlParameter, DB_CONSTANTS.ConnectionString_ICS); if (Response.ResponseData.Tables[0].Rows.Count > 0) { Response.ErrorCode = 0; foreach (DataRow dr in Response.ResponseData.Tables[0].Rows) { Project.Entity.Leads objLeads = new Project.Entity.Leads(); objLeads.Lead_ID = Convert.ToInt64(dr["Lead_ID_Auto_PK"]); objLeads.DBA = dr["DBA"].ToString(); objLeads.ContName = dr["ContactName"].ToString(); objLeads.bPhone = dr["BusinessPhone"].ToString(); objLeads.Email = dr["Email"].ToString(); objLeads.LeadStatus = dr["Status_Name"].ToString(); objLeads.LeadColour = dr["StatusColour"].ToString(); objLeads.AssignToName = Convert.ToString(dr["AssignToName"]); objLeads.CreatedByName = dr["CreatedBy"].ToString(); if (dr["AssignTo"].ToString() != "") { objLeads.AssignToID = Convert.ToInt64(dr["AssignTo"]); } if (dr["CreatedDate"].ToString() != "") { objLeads.CreatedDate = Convert.ToDateTime(dr["CreatedDate"]).ToString("MM/dd/yyyy"); } objLeads.LeadSource = dr["LeadSource"].ToString(); leads.Add(objLeads); } } else { Response.ErrorCode = 2001; Response.ErrorMessage = "There is an Error. Please Try After some time."; } } catch (Exception ex) { Response.ErrorMessage = ex.Message.ToString(); BAL.Common.LogManager.LogError("getAllLeads", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace)); } return(leads); }
public objResponse AddLeadStep5(Project.Entity.Leads objLeads) { objResponse Response = new objResponse(); try { SqlParameter[] sqlParameter = new SqlParameter[17]; sqlParameter[0] = new SqlParameter("@EquipmentNo", SqlDbType.NVarChar, 50); sqlParameter[0].Value = objLeads.EquipmentNo; sqlParameter[1] = new SqlParameter("@EPNReaders", SqlDbType.NVarChar, 50); sqlParameter[1].Value = objLeads.EPNReaders; sqlParameter[2] = new SqlParameter("@Terminals", SqlDbType.NVarChar, 50); sqlParameter[2].Value = objLeads.Terminals; sqlParameter[3] = new SqlParameter("@EquipmentType1", SqlDbType.NVarChar, 50); sqlParameter[3].Value = objLeads.EquipmentType1; sqlParameter[4] = new SqlParameter("@TerminalType", SqlDbType.NVarChar, 50); sqlParameter[4].Value = objLeads.TerminalType; sqlParameter[5] = new SqlParameter("@FreeTerminal", SqlDbType.NVarChar, 50); sqlParameter[5].Value = objLeads.FreeTerminal; sqlParameter[6] = new SqlParameter("@SoftwareName", SqlDbType.NVarChar, 50); sqlParameter[6].Value = objLeads.SoftwareName; sqlParameter[7] = new SqlParameter("@GatewayName", SqlDbType.NVarChar, 50); sqlParameter[7].Value = objLeads.GatewayName; sqlParameter[8] = new SqlParameter("@EquipmentSerial", SqlDbType.NVarChar, 50); sqlParameter[8].Value = objLeads.EquipmentSerial; sqlParameter[9] = new SqlParameter("@Pinpad", SqlDbType.NVarChar, 50); sqlParameter[9].Value = objLeads.Pinpad; sqlParameter[10] = new SqlParameter("@PinPadPurchasePrice", SqlDbType.NVarChar, 50); sqlParameter[10].Value = objLeads.PinPadPurchasePrice; sqlParameter[11] = new SqlParameter("@PinpadSerial", SqlDbType.NVarChar, 50); sqlParameter[11].Value = objLeads.PinpadSerial; sqlParameter[12] = new SqlParameter("@ShippingMethod", SqlDbType.NVarChar, 50); sqlParameter[12].Value = objLeads.ShippingMethod; sqlParameter[13] = new SqlParameter("@Shipped", SqlDbType.NVarChar, 50); sqlParameter[13].Value = objLeads.Shipped; sqlParameter[14] = new SqlParameter("@TrackingNumber", SqlDbType.NVarChar, 50); sqlParameter[14].Value = objLeads.TrackingNumber; sqlParameter[15] = new SqlParameter("@EquipmentType2", SqlDbType.NVarChar, 50); sqlParameter[15].Value = objLeads.EquipmentType2; sqlParameter[16] = new SqlParameter("@PurchasePrice", SqlDbType.NVarChar, 50); sqlParameter[16].Value = objLeads.PurchasePrice; sqlParameter[17] = new SqlParameter("@ApplicableTaxes", SqlDbType.NVarChar, 50); sqlParameter[17].Value = objLeads.ApplicableTaxes; sqlParameter[18] = new SqlParameter("@Lead_ID", SqlDbType.BigInt, 10); sqlParameter[18].Value = objLeads.Lead_ID; DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_AddLeadStep5", sqlParameter, DB_CONSTANTS.ConnectionString_ICS); if (Response.ResponseData.Tables[0].Rows.Count > 0) { Response.ErrorCode = 0; Response.ErrorMessage = Response.ResponseData.Tables[0].Rows[0][0].ToString();; } else { Response.ErrorCode = 2001; Response.ErrorMessage = "There is an Error. Please Try After some time."; } } catch (Exception ex) { Response.ErrorMessage = ex.Message.ToString(); BAL.Common.LogManager.LogError("AddLeadStep5", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace)); } return(Response); }
public objResponse AddLeadStep4(Project.Entity.Leads objLeads) { objResponse Response = new objResponse(); try { SqlParameter[] sqlParameter = new SqlParameter[49]; sqlParameter[0] = new SqlParameter("@DebitQual", SqlDbType.NVarChar, 50); sqlParameter[0].Value = objLeads.DebitQual; sqlParameter[1] = new SqlParameter("@DebitMIDQual", SqlDbType.NVarChar, 50); sqlParameter[1].Value = objLeads.DebitMIDQual; sqlParameter[2] = new SqlParameter("@DebitNonQual", SqlDbType.NVarChar, 50); sqlParameter[2].Value = objLeads.DebitNonQual; sqlParameter[3] = new SqlParameter("@CreditQual", SqlDbType.NVarChar, 50); sqlParameter[3].Value = objLeads.CreditQual; sqlParameter[4] = new SqlParameter("@CreditMIDQual", SqlDbType.NVarChar, 50); sqlParameter[4].Value = objLeads.CreditMIDQual; sqlParameter[5] = new SqlParameter("@CreditNonQual", SqlDbType.NVarChar, 50); sqlParameter[5].Value = objLeads.CreditNonQual; sqlParameter[6] = new SqlParameter("@DebitQualPerItem", SqlDbType.NVarChar, 50); sqlParameter[6].Value = objLeads.DebitQualPerItem; sqlParameter[7] = new SqlParameter("@DebitMIDQualPerItem", SqlDbType.NVarChar, 50); sqlParameter[7].Value = objLeads.DebitMIDQualPerItem; sqlParameter[8] = new SqlParameter("@DebitNonQualPerItem", SqlDbType.NVarChar, 50); sqlParameter[8].Value = objLeads.DebitNonQualPerItem; sqlParameter[9] = new SqlParameter("@CreditQualPerItem", SqlDbType.NVarChar, 50); sqlParameter[9].Value = objLeads.CreditQualPerItem; sqlParameter[10] = new SqlParameter("@CreditMIDQualPerItem", SqlDbType.NVarChar, 50); sqlParameter[10].Value = objLeads.CreditMIDQualPerItem; sqlParameter[11] = new SqlParameter("@CreditNonQualPerItem", SqlDbType.NVarChar, 50); sqlParameter[11].Value = objLeads.CreditNonQualPerItem; sqlParameter[12] = new SqlParameter("@DebitTransFee", SqlDbType.NVarChar, 50); sqlParameter[12].Value = objLeads.DebitTransFee; sqlParameter[13] = new SqlParameter("@ReturnTransFee", SqlDbType.NVarChar, 50); sqlParameter[13].Value = objLeads.ReturnTransFee; sqlParameter[14] = new SqlParameter("@EBTTransFee", SqlDbType.NVarChar, 50); sqlParameter[14].Value = objLeads.EBTTransFee; sqlParameter[15] = new SqlParameter("@ElectroAVSFee", SqlDbType.NVarChar, 50); sqlParameter[15].Value = objLeads.ElectroAVSFee; sqlParameter[16] = new SqlParameter("@AMEXTransFee", SqlDbType.NVarChar, 50); sqlParameter[16].Value = objLeads.AMEXTransFee; sqlParameter[17] = new SqlParameter("@StatementFee", SqlDbType.NVarChar, 50); sqlParameter[17].Value = objLeads.StatementFee; sqlParameter[18] = new SqlParameter("@MontMini", SqlDbType.NVarChar, 50); sqlParameter[18].Value = objLeads.MontMini; sqlParameter[19] = new SqlParameter("@ChargeBackFee", SqlDbType.NVarChar, 50); sqlParameter[19].Value = objLeads.ChargeBackFee; sqlParameter[20] = new SqlParameter("@BatchFee", SqlDbType.NVarChar, 50); sqlParameter[20].Value = objLeads.BatchFee; sqlParameter[21] = new SqlParameter("@Lead_ID", SqlDbType.BigInt, 10); sqlParameter[21].Value = objLeads.Lead_ID; sqlParameter[22] = new SqlParameter("@Equipment", SqlDbType.NVarChar, 80); sqlParameter[22].Value = ""; sqlParameter[23] = new SqlParameter("@RatesType", SqlDbType.NVarChar, 50); sqlParameter[23].Value = objLeads.RatesType; sqlParameter[24] = new SqlParameter("@CreditDisocuntRate", SqlDbType.NVarChar, 50); sqlParameter[24].Value = objLeads.CreditDisocuntRate; sqlParameter[25] = new SqlParameter("@DebitDiscountRate", SqlDbType.NVarChar, 50); sqlParameter[25].Value = objLeads.DebitDiscountRate; sqlParameter[26] = new SqlParameter("@ERRSurcharge", SqlDbType.NVarChar, 50); sqlParameter[26].Value = objLeads.ERRSurcharge; sqlParameter[27] = new SqlParameter("@InterchangeRate", SqlDbType.NVarChar, 50); sqlParameter[27].Value = objLeads.InterchangeRate; sqlParameter[28] = new SqlParameter("@DiscountRate", SqlDbType.NVarChar, 50); sqlParameter[28].Value = objLeads.DiscountRate; sqlParameter[29] = new SqlParameter("@ReserveAccountFee", SqlDbType.NVarChar, 50); sqlParameter[29].Value = objLeads.ReserveAccountFee; sqlParameter[30] = new SqlParameter("@FDRHelpDeskFee", SqlDbType.NVarChar, 50); sqlParameter[30].Value = objLeads.FDRHelpDeskFee; sqlParameter[31] = new SqlParameter("@FDRAsstServiceFee", SqlDbType.NVarChar, 50); sqlParameter[31].Value = objLeads.FDRAsstServiceFee; sqlParameter[32] = new SqlParameter("@ACHChangeFee", SqlDbType.NVarChar, 50); sqlParameter[32].Value = objLeads.ACHChangeFee; sqlParameter[33] = new SqlParameter("@RetrivalRequestFee", SqlDbType.NVarChar, 50); sqlParameter[33].Value = objLeads.RetrivalRequestFee; sqlParameter[34] = new SqlParameter("@VoiceAuthFee", SqlDbType.NVarChar, 50); sqlParameter[34].Value = objLeads.VoiceAuthFee; sqlParameter[35] = new SqlParameter("@AnnualFee", SqlDbType.NVarChar, 50); sqlParameter[35].Value = objLeads.AnnualFee; sqlParameter[36] = new SqlParameter("@PCINonActionFee", SqlDbType.NVarChar, 50); sqlParameter[36].Value = objLeads.PCINonActionFee; sqlParameter[37] = new SqlParameter("@RegulatoryFee", SqlDbType.NVarChar, 50); sqlParameter[37].Value = objLeads.RegulatoryFee; sqlParameter[38] = new SqlParameter("@RegulatoryNonComplienceFee", SqlDbType.NVarChar, 50); sqlParameter[38].Value = objLeads.RegulatoryNonComplienceFee; sqlParameter[39] = new SqlParameter("@EarlyTerminationBefore1Year", SqlDbType.NVarChar, 50); sqlParameter[39].Value = objLeads.EarlyTerminationBefore1Year; sqlParameter[40] = new SqlParameter("@EarlyTerminationAfter1Year", SqlDbType.NVarChar, 50); sqlParameter[40].Value = objLeads.EarlyTerminationAfter1Year; sqlParameter[41] = new SqlParameter("@EarlyTerminationBefore2Year", SqlDbType.NVarChar, 50); sqlParameter[41].Value = objLeads.EarlyTerminationBefore2Year; sqlParameter[42] = new SqlParameter("@InterchangeClearFee", SqlDbType.NVarChar, 50); sqlParameter[42].Value = objLeads.InterchangeClearFee; sqlParameter[43] = new SqlParameter("@WirelessSetupFee", SqlDbType.NVarChar, 50); sqlParameter[43].Value = objLeads.WirelessSetupFee; sqlParameter[44] = new SqlParameter("@WirelessMonthlyFee", SqlDbType.NVarChar, 50); sqlParameter[44].Value = objLeads.WirelessMonthlyFee; sqlParameter[45] = new SqlParameter("@WirelessAuthFee", SqlDbType.NVarChar, 50); sqlParameter[45].Value = objLeads.WirelessAuthFee; sqlParameter[46] = new SqlParameter("@GatewaySetupFee", SqlDbType.NVarChar, 50); sqlParameter[46].Value = objLeads.GatewaySetupFee; sqlParameter[47] = new SqlParameter("@GatewayMonthlyFee", SqlDbType.NVarChar, 50); sqlParameter[47].Value = objLeads.GatewayMonthlyFee; sqlParameter[48] = new SqlParameter("@GatewayAuthFee", SqlDbType.NVarChar, 50); sqlParameter[48].Value = objLeads.GatewayAuthFee; DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_AddLeadStep4", sqlParameter, DB_CONSTANTS.ConnectionString_ICS); if (Response.ResponseData.Tables[0].Rows.Count > 0) { Response.ErrorCode = 0; Response.ErrorMessage = Response.ResponseData.Tables[0].Rows[0][0].ToString();; } else { Response.ErrorCode = 2001; Response.ErrorMessage = "There is an Error. Please Try After some time."; } } catch (Exception ex) { Response.ErrorMessage = ex.Message.ToString(); BAL.Common.LogManager.LogError("AddLeadStep4", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace)); } return(Response); }
public objResponse AddLeadStep3(Project.Entity.Leads objLeads) { objResponse Response = new objResponse(); try { SqlParameter[] sqlParameter = new SqlParameter[15]; sqlParameter[0] = new SqlParameter("@MerchantType", SqlDbType.NVarChar, 50); sqlParameter[0].Value = objLeads.MerchantType; sqlParameter[1] = new SqlParameter("@RSwiped", SqlDbType.NVarChar, 50); sqlParameter[1].Value = objLeads.RSwiped; sqlParameter[2] = new SqlParameter("@RKeyed", SqlDbType.NVarChar, 50); sqlParameter[2].Value = objLeads.RKeyed; sqlParameter[3] = new SqlParameter("@MTOrders", SqlDbType.NVarChar, 50); sqlParameter[3].Value = objLeads.MTOrders; sqlParameter[4] = new SqlParameter("@internet", SqlDbType.NVarChar, 50); sqlParameter[4].Value = objLeads.internet; sqlParameter[5] = new SqlParameter("@avgTicket", SqlDbType.NVarChar, 50); sqlParameter[5].Value = objLeads.avgTicket; sqlParameter[6] = new SqlParameter("@highTicket", SqlDbType.NVarChar, 50); sqlParameter[6].Value = objLeads.highTicket; sqlParameter[7] = new SqlParameter("@MVolume", SqlDbType.NVarChar, 50); sqlParameter[7].Value = objLeads.MVolume; sqlParameter[8] = new SqlParameter("@BName", SqlDbType.NVarChar, 100); sqlParameter[8].Value = objLeads.BName; sqlParameter[9] = new SqlParameter("@BCity", SqlDbType.NVarChar, 100); sqlParameter[9].Value = objLeads.BCity; sqlParameter[10] = new SqlParameter("@BState", SqlDbType.NVarChar, 100); sqlParameter[10].Value = objLeads.BState; sqlParameter[11] = new SqlParameter("@BZip", SqlDbType.NVarChar, 100); sqlParameter[11].Value = objLeads.BZip; sqlParameter[12] = new SqlParameter("@BRoutNumber", SqlDbType.NVarChar, 50); sqlParameter[12].Value = objLeads.BRoutNumber; sqlParameter[13] = new SqlParameter("@BacNumber", SqlDbType.NVarChar, 30); sqlParameter[13].Value = objLeads.BacNumber; sqlParameter[14] = new SqlParameter("@Lead_ID", SqlDbType.BigInt, 10); sqlParameter[14].Value = objLeads.Lead_ID; DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_AddLeadStep3", sqlParameter, DB_CONSTANTS.ConnectionString_ICS); if (Response.ResponseData.Tables[0].Rows.Count > 0) { Response.ErrorCode = 0; Response.ErrorMessage = Response.ResponseData.Tables[0].Rows[0][0].ToString();; } else { Response.ErrorCode = 2001; Response.ErrorMessage = "There is an Error. Please Try After some time."; } } catch (Exception ex) { Response.ErrorMessage = ex.Message.ToString(); BAL.Common.LogManager.LogError("AddLeadStep3", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace)); } return(Response); }
public objResponse AddLeadStep2(Project.Entity.Leads objLeads) { objResponse Response = new objResponse(); try { SqlParameter[] sqlParameter = new SqlParameter[13]; sqlParameter[0] = new SqlParameter("@FName", SqlDbType.NVarChar, 100); sqlParameter[0].Value = objLeads.FName; sqlParameter[1] = new SqlParameter("@LName", SqlDbType.NVarChar, 100); sqlParameter[1].Value = objLeads.LName; sqlParameter[2] = new SqlParameter("@DOB", SqlDbType.NVarChar, 100); sqlParameter[2].Value = objLeads.DOB; sqlParameter[3] = new SqlParameter("@SocSecurity", SqlDbType.NVarChar, 50); sqlParameter[3].Value = objLeads.SocSecurity; sqlParameter[4] = new SqlParameter("@DLicense", SqlDbType.NVarChar, 50); sqlParameter[4].Value = objLeads.DLicense; sqlParameter[5] = new SqlParameter("@DLicenseState", SqlDbType.NVarChar, 100); sqlParameter[5].Value = objLeads.DLicenseState; sqlParameter[6] = new SqlParameter("@RAddress1", SqlDbType.NVarChar, 100); sqlParameter[6].Value = objLeads.RAddress1; sqlParameter[7] = new SqlParameter("@RAddress2", SqlDbType.NVarChar, 100); sqlParameter[7].Value = objLeads.RAddress2; sqlParameter[8] = new SqlParameter("@rcity", SqlDbType.NVarChar, 100); sqlParameter[8].Value = objLeads.rcity; sqlParameter[9] = new SqlParameter("@rstate", SqlDbType.NVarChar, 100); sqlParameter[9].Value = objLeads.rstate; sqlParameter[10] = new SqlParameter("@rzip", SqlDbType.NVarChar, 10); sqlParameter[10].Value = objLeads.rzip; sqlParameter[11] = new SqlParameter("@OwnerPhone", SqlDbType.NVarChar, 13); sqlParameter[11].Value = objLeads.OwnerPhone; sqlParameter[12] = new SqlParameter("@Lead_ID", SqlDbType.BigInt, 10); sqlParameter[12].Value = objLeads.Lead_ID; DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_AddLeadStep2", sqlParameter, DB_CONSTANTS.ConnectionString_ICS); if (Response.ResponseData.Tables[0].Rows.Count > 0) { Response.ErrorCode = 0; Response.ErrorMessage = Response.ResponseData.Tables[0].Rows[0][0].ToString();; } else { Response.ErrorCode = 2001; Response.ErrorMessage = "There is an Error. Please Try After some time."; } } catch (Exception ex) { Response.ErrorMessage = ex.Message.ToString(); BAL.Common.LogManager.LogError("AddLeadStep2", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace)); } return(Response); }