public string InsertRequestLog(DAL_M_VendorDD vmvendorDD, DAL.Models.DAL_M_SourceIPInfo ipInfo) { try { using (SqlConnection con = DBconnection.Open()) { SqlCommand sqlComm = new SqlCommand("InsertRequestLog", con); sqlComm.Parameters.AddWithValue("@VEND_CUST_CD", vmvendorDD.Vendorname); sqlComm.Parameters.AddWithValue("@ConfirmationNum", vmvendorDD.Confirmation); sqlComm.Parameters.AddWithValue("@Source_ip", ipInfo.Source_IP); sqlComm.Parameters.AddWithValue("@Source_device", ipInfo.Source_Device); sqlComm.Parameters.AddWithValue("@User_agent", vmvendorDD.User_agent); // this is used for entered by sqlComm.Parameters.AddWithValue("@Host_headers", ipInfo.Source_Host_Headers); sqlComm.Parameters.AddWithValue("@Source_Location", ipInfo.Source_Location); sqlComm.CommandType = CommandType.StoredProcedure; sqlComm.ExecuteNonQuery(); logw.LogWrite("Inserted RequestLog"); con.Close(); } } catch (Exception ex) { LogManager.log.Error("Error in InsertRequestLog. Message: " + ex.Message); logw.LogWrite("Error in InsertRequestLog. Message:" + ex.Message); return(string.Empty); } return("SUCCESS"); }
public Tuple <string, string> SubmitAttachmentFile(DAL_M_VendorDD vmvendorDD) { try { DataSet ds = new DataSet("Vendor"); using (SqlConnection con = DBconnection.Open()) { SqlCommand sqlComm = new SqlCommand("SubmitVendorAttachment", con); // Srini - 6/1/21 Enhancement #73 if (string.IsNullOrEmpty(vmvendorDD.VendorAttachmentFileName) == false) { sqlComm.Parameters.AddWithValue("@ConfirmationNum", vmvendorDD.Confirmation); sqlComm.Parameters.AddWithValue("@TypeID", getDocumentTypeID(vmvendorDD.VendorAttachmentFileName)); sqlComm.Parameters.AddWithValue("@AttachmentFileName", vmvendorDD.VendorAttachmentFileName); sqlComm.Parameters.AddWithValue("@LastUpdatedUser", ""); sqlComm.Parameters.AddWithValue("@LastUpdateDateTime", DateTime.Now); sqlComm.CommandType = CommandType.StoredProcedure; sqlComm.ExecuteNonQuery(); } //VCM Document int type_id = 5; // VCM Request Submission Receipt sqlComm.Parameters.Clear(); sqlComm.Parameters.AddWithValue("@ConfirmationNum", vmvendorDD.Confirmation); sqlComm.Parameters.AddWithValue("@TypeID", type_id); sqlComm.Parameters.AddWithValue("@AttachmentFileName", vmvendorDD.VendorReportFileName); sqlComm.Parameters.AddWithValue("@LastUpdatedUser", ""); sqlComm.Parameters.AddWithValue("@LastUpdateDateTime", DateTime.Now); sqlComm.CommandType = CommandType.StoredProcedure; sqlComm.ExecuteNonQuery(); //if there is second attachment, when submit from DDMS if ((vmvendorDD.AttachmentFileName_ddwetform != null) && (!string.IsNullOrEmpty(vmvendorDD.AttachmentFileName_ddwetform.Trim()))) { int dtypeid = 6; SqlCommand sqlComm_ddwetform = new SqlCommand("SubmitVendorAttachment", con); sqlComm_ddwetform.Parameters.AddWithValue("@ConfirmationNum", vmvendorDD.Confirmation); sqlComm_ddwetform.Parameters.AddWithValue("@TypeID", dtypeid); sqlComm_ddwetform.Parameters.AddWithValue("@AttachmentFileName", vmvendorDD.AttachmentFileName_ddwetform); sqlComm_ddwetform.Parameters.AddWithValue("@LastUpdatedUser", ""); sqlComm_ddwetform.Parameters.AddWithValue("@LastUpdateDateTime", DateTime.Now); sqlComm_ddwetform.CommandType = CommandType.StoredProcedure; sqlComm_ddwetform.ExecuteNonQuery(); } con.Close(); } } catch (Exception ex) { LogManager.log.Error("Error in SubmitAttachmentFile. Message: " + ex.Message); logw.LogWrite("Error in SubmitAttachmentFile. " + ex.Message); return(null); } return(new Tuple <string, string>("SUCCESS", "true")); }
public Tuple <string, string> InsertVendorReportFileName(DAL_M_VendorDD vmvendorDD) { try { DataSet ds = new DataSet("Vendor"); using (SqlConnection con = DBconnection.Open()) { int type_id = 5; // VCM Request Submission Receipt SqlCommand sqlComm = new SqlCommand("SubmitVendorAttachment", con); sqlComm.Parameters.AddWithValue("@ConfirmationNum", vmvendorDD.Confirmation); sqlComm.Parameters.AddWithValue("@TypeID", type_id); sqlComm.Parameters.AddWithValue("@AttachmentFileName", vmvendorDD.VendorReportFileName); sqlComm.Parameters.AddWithValue("@LastUpdatedUser", ""); sqlComm.Parameters.AddWithValue("@LastUpdateDateTime", DateTime.Now); sqlComm.CommandType = CommandType.StoredProcedure; sqlComm.ExecuteNonQuery(); con.Close(); } } catch (Exception ex) { LogManager.log.Error("Error in InsertVendorReportFileName. Message: " + ex.Message); logw.LogWrite("Error in InsertVendorReportFileName. " + ex.Message); return(new Tuple <string, string>("error --" + ex.Message, "false")); } return(new Tuple <string, string>("SUCCESS", "true")); }
public Tuple <string, string> SubmitVendor(DAL_M_VendorDD vmvendorDD) { try { DataTable reqDetails = CreateTable(); if (vmvendorDD.LocationAddressList == null) { foreach (string locid in vmvendorDD.LocationIDs) { reqDetails.Rows.Add(vmvendorDD.Confirmation, vmvendorDD.Vendorname, locid, 1, "", "", "", "", ""); } } else { foreach (DAL_M_LocationAddress loc in vmvendorDD.LocationAddressList) { reqDetails.Rows.Add(vmvendorDD.Confirmation, vmvendorDD.Vendorname, loc.LocationID, 1, loc.Address1, loc.Address2, loc.City, loc.State, loc.ZipCode); } } DataSet ds = new DataSet("Vendor"); using (SqlConnection con = DBconnection.Open()) { { SqlCommand sqlComm = new SqlCommand("SubmitVendorDetails", con); sqlComm.Parameters.AddWithValue("@VEND_CUST_CD", vmvendorDD.Vendorname); sqlComm.Parameters.AddWithValue("@ConfirmationNum", vmvendorDD.Confirmation);//vmvendorDD.Confirmation) sqlComm.Parameters.AddWithValue("@RequestDate", vmvendorDD.SubmitDateTime); sqlComm.Parameters.AddWithValue("@Status", 5); // 5 pending sqlComm.Parameters.AddWithValue("@DDNotifyEmail", vmvendorDD.DDNotifyEmail); sqlComm.Parameters.AddWithValue("@AccountType", vmvendorDD.AccountType); sqlComm.Parameters.AddWithValue("@NameOnBankAccount", vmvendorDD.NameOnBankAccount); sqlComm.Parameters.AddWithValue("@AccountNumber", vmvendorDD.BankAccountNumber); sqlComm.Parameters.AddWithValue("@RoutingNumber", vmvendorDD.BankRoutingNo); sqlComm.Parameters.AddWithValue("@FinInstName", vmvendorDD.FinancialIns); sqlComm.Parameters.AddWithValue("@AuthorizedName", vmvendorDD.Signername); sqlComm.Parameters.AddWithValue("@AuthorizedTitle", vmvendorDD.Signertitle); sqlComm.Parameters.AddWithValue("@AuthorizedPhone", vmvendorDD.Signerphone); sqlComm.Parameters.AddWithValue("@AuthorizedPhoneExt", ""); sqlComm.Parameters.AddWithValue("@AuthorizedEmail", vmvendorDD.Signeremail); sqlComm.Parameters.AddWithValue("@LastUpdateDateTime", vmvendorDD.SubmitDateTime); sqlComm.Parameters.AddWithValue("@RequestType", vmvendorDD.RequestType); sqlComm.Parameters.AddWithValue("@TableTypeRequestDetail", reqDetails); sqlComm.Parameters.AddWithValue("@SubmitFromWhere", vmvendorDD.SubmitFromWhere); sqlComm.Parameters.AddWithValue("@PayeeName", vmvendorDD.Payeename); sqlComm.Parameters.AddWithValue("@FirstName", vmvendorDD.FirstName); sqlComm.Parameters.AddWithValue("@MiddleName", vmvendorDD.MiddleName); sqlComm.Parameters.AddWithValue("@LastName", vmvendorDD.LastName); sqlComm.Parameters.AddWithValue("@CompanyName", vmvendorDD.CompanyName); sqlComm.Parameters.AddWithValue("@AliasDBA", vmvendorDD.AliasDBAName); sqlComm.Parameters.AddWithValue("@TaxpayerID", vmvendorDD.Ssn); sqlComm.Parameters.AddWithValue("@CaseNo", vmvendorDD.CaseNo); sqlComm.Parameters.AddWithValue("@PhoneNumber", vmvendorDD.PhoneNumber); sqlComm.Parameters.AddWithValue("@DepartmentName", vmvendorDD.DepartmentName); sqlComm.Parameters.AddWithValue("@DepartmentContactName", vmvendorDD.DepartmentContactName); sqlComm.Parameters.AddWithValue("@DepartmentEmail", vmvendorDD.DepartmentEmail); sqlComm.Parameters.AddWithValue("@DepartmentContactNo", vmvendorDD.DepartmentContactNo); sqlComm.CommandType = CommandType.StoredProcedure; sqlComm.ExecuteNonQuery(); } con.Close(); } } catch (Exception ex) { LogManager.log.Error("Error in SubmitVendor. Message: " + ex.Message); logw.LogWrite("Error in Vendor DAL SubmitVendor. FileName: " + vmvendorDD.Confirmation + ". " + ex.Message); return(null); } return(new Tuple <string, string>("SUCCESS", "true")); }