public async Task <int> AddCompanyAsync(Company company) { string sql = string.Format("INSERT INTO [Company] ([Name],[Address],[PhoneNo] ,[FaxNo] ,[EMail] ,[ContactPersonName] ,[WHName] ,[WHAddress] ,[WHPhoneNo] ,[WHEmail]) VALUES ('{0}', '{1}','{2}','{3}', '{4}','{5}','{6}', '{7}','{8}','{9}')", company.Name.Replace("'", "''"), company.Address.Replace("'", "''"), company.PhoneNo, company.FaxNo, company.EMail.Replace("'", "''"), company.ContactPersonName.Replace("'", "''"), company.WHName.Replace("'", "''"), company.WHAddress.Replace("'", "''"), company.PhoneNo.Replace("'", "''"), company.WHEmail.Replace("'", "''")); return(await _sqlHelper.ExecuteNonQueryAsync(ConnectionSettings.ConnectionString, sql, CommandType.Text)); }
public void AssignHgiUserToOrganizationHierarchy(int organizationId) { //await Task.Delay(0); SqlParameter[] parameters = new SqlParameter[1]; SqlParameter parameter0 = new SqlParameter("@organizationId", organizationId); parameters[0] = parameter0; _sqlHelper.ExecuteNonQueryAsync(_connectionStrings.Value.SentinelFmMain, "OrganizationHierarchyAssignHgiUserToTopLevel", CommandType.StoredProcedure, parameters); }
public async Task AddSupplierAsync(Supplier supplier) { string sql = string.Format("INSERT INTO [Supplier] ([CompanyId],[Name],[ContactPersonName],[PhoneNo],[EmailID],[Address],[City],[State],[Country]," + "[ZIPCode],[FAXNo],[DateFormat],[noofstages],[CompanyProfileID],[PoLetterHead]) VALUES ('{0}', '{1}','{2}','{3}', '{4}','{5}','{6}', '{7}','{8}','{9}','{10}', '{11}','{12}','{13}','{14}')", supplier.CompanyId, supplier.Name.Replace("'", "''"), supplier.ContactPersonName.Replace("'", "''"), supplier.PhoneNo, supplier.EmailID.Replace("'", "''"), supplier.Address.Replace("'", "''"), supplier.City.Replace("'", "''"), supplier.State.Replace("'", "''"), supplier.Country.Replace("'", "''"), supplier.ZIPCode.Replace("'", "''"), supplier.FAXNo, supplier.DateFormat, supplier.noofstages, supplier.CompanyProfileID, supplier.PoLetterHead); sql = sql + " Select Scope_Identity()"; var supplierId = _sqlHelper.ExecuteScalar(ConnectionSettings.ConnectionString, sql, CommandType.Text); foreach (SupplierTerms term in supplier.Terms) { sql = string.Format("INSERT INTO [dbo].[supplierterms]([supplierId],[sequenceNo],[terms]) VALUES ('{0}', '{1}','{2}')", supplierId, term.SequenceNo, term.Terms.Replace("'", "''")); await _sqlHelper.ExecuteNonQueryAsync(ConnectionSettings.ConnectionString, sql, CommandType.Text); } }
public void SetOrganizationHierarchyAssignmentExpireDateTime(int organizationId, DateTime exd) { SqlParameter[] parameters = new SqlParameter[2]; SqlParameter parameter0 = new SqlParameter("@OrganizationId", organizationId); parameters[0] = parameter0; SqlParameter parameter1 = new SqlParameter("@expdt", exd); parameters[1] = parameter1; _sqlHelper.ExecuteNonQueryAsync(_connectionStrings.Value.SentinelFmMain, "OrganizationHierarchyAssignmentBatchSetExpireDateTime", CommandType.StoredProcedure, parameters); }
public async Task AddCustomerAsync(Customer customer) { if (customer.Name == null) { customer.Name = string.Empty; } if (customer.AddressLine1 == null) { customer.AddressLine1 = string.Empty; } if (customer.City == null) { customer.City = string.Empty; } if (customer.State == null) { customer.State = string.Empty; } if (customer.ZIPCode == null) { customer.ZIPCode = string.Empty; } if (customer.ContactPersonName == null) { customer.ContactPersonName = string.Empty; } if (customer.TelephoneNumber == null) { customer.TelephoneNumber = string.Empty; } if (customer.FaxNumber == null) { customer.FaxNumber = string.Empty; } if (customer.EmailAddress == null) { customer.EmailAddress = string.Empty; } if (customer.TruckType == null) { customer.TruckType = string.Empty; } if (customer.CollectFreight == null) { customer.CollectFreight = string.Empty; } if (customer.Comments == null) { customer.Comments = string.Empty; } if (customer.FOB == null) { customer.FOB = string.Empty; } if (customer.Terms == null) { customer.Terms = string.Empty; } if (customer.ShipVia == null) { customer.ShipVia = string.Empty; } if (customer.EndCustomerName == null) { customer.EndCustomerName = string.Empty; } if (customer.Billing == null) { customer.Billing = string.Empty; } string sql = string.Format($"INSERT INTO [dbo].[customer] ([CompanyId],[Name],[AddressLine1],[City],[State],[ZIPCode],[ContactPersonName],[TelephoneNumber],[FaxNumber],[EmailAddress],[TruckType],[CollectFreight],[Comments],[Surcharge],[FOB],[Terms],[RePackingCharge],[ShipVia],[invoicingtypeid],[endcustomername],[DisplayLineNo],[Billing],[RePackingPoNo]) VALUES ('{customer.CompanyId}', " + $"'{customer.Name.Replace("'", "''")}', '{customer.AddressLine1.Replace("'", "''")}', '{customer.City.Replace("'", "''")}', '{customer.State.Replace("'", "''")}', '{customer.ZIPCode.Replace("'", "''")}', '{customer.ContactPersonName.Replace("'", "''")}', '{customer.TelephoneNumber.Replace("'", "''")}', " + $"'{customer.FaxNumber.Replace("'", "''")}', '{customer.EmailAddress.Replace("'", "''")}', '{customer.TruckType.Replace("'", "''")}', '{customer.CollectFreight.Replace("'", "''")}', " + $"'{customer.Comments.Replace("'", "''")}', '{customer.Surcharge}', '{customer.FOB.Replace("'", "''")}', '{customer.Terms.Replace("'", "''")}', '{customer.RePackingCharge}', " + $"'{customer.ShipVia.Replace("'", "''")}', '{1}', '{customer.EndCustomerName.Replace("'", "''")}','{ customer.DisplayLineNo}','{ customer.Billing.Replace("'", "''")}','{ string.Empty}')"); sql = sql + " Select Scope_Identity()"; var customerId = _sqlHelper.ExecuteScalar(ConnectionSettings.ConnectionString, sql, CommandType.Text); foreach (CustomerShippingInfo term in customer.ShippingInfos) { if (term.Name == null) { term.Name = string.Empty; } if (term.ContactPersonName == null) { term.ContactPersonName = string.Empty; } if (term.AddressLine1 == null) { term.AddressLine1 = string.Empty; } if (term.City == null) { term.City = string.Empty; } if (term.State == null) { term.State = string.Empty; } if (term.ZIPCode == null) { term.ZIPCode = string.Empty; } sql = string.Format($"INSERT INTO [dbo].[customershippinginfo] ([CustomerID] ,[Name] ,[ContactPersonName] ,[AddressLine1] ,[City] ,[State],[ZIPCode],[IsDefault],[IsOld]) VALUES ( " + $"'{customerId}' , '{term.Name.Replace("'", "''")}' , '{term.ContactPersonName.Replace("'", "''")}' ,'{term.AddressLine1.Replace("'", "''")}', '{term.City.Replace("'", "''")}' , '{term.State.Replace("'", "''")}' , '{term.ZIPCode.Replace("'", "''")}' , '{term.IsDefault}','{false}')"); await _sqlHelper.ExecuteNonQueryAsync(ConnectionSettings.ConnectionString, sql, CommandType.Text); } }