public static void RemovePaymentFromInvoice(int paymentID, int invoiceID) { using (ClientsDataContext dc = new ClientsDataContext()) { dc.S1_Clients_RemovePaymentFromInvoice(paymentID, invoiceID); } }
public static S1_Clients_AttachPaymentToInvoiceResult AttachPaymentToInvoice(int clientID, int invoiceID, int paymentID, DateTime paymentDate, string paymentQB, decimal amountReceived, bool manualEntry, int manualUserID) { using (ClientsDataContext dc = new ClientsDataContext()) { return(dc.S1_Clients_AttachPaymentToInvoice(clientID, invoiceID, paymentID, paymentDate, paymentQB, amountReceived, manualEntry, manualUserID).FirstOrDefault()); } }
public static S1_Clients_AttachInvoiceToPaymentResult AttachInvoiceToPayment(int clientID, int paymentID, int invoiceID, string invoiceNumber, DateTime invoiceDate, string invoiceQB, decimal paymentSpent, bool manualEntry, int manualUserID) { using (ClientsDataContext dc = new ClientsDataContext()) { return(dc.S1_Clients_AttachInvoiceToPayment(clientID, paymentID, invoiceID, invoiceNumber, invoiceDate, invoiceQB, paymentSpent, manualEntry, manualUserID).FirstOrDefault()); } }
public static List <S1_Users_GetAllClientUsersResult> GetAllClientUsers() { var db = new ClientsDataContext(); var result = db.S1_Users_GetAllClientUsers(); return(result.ToList()); }
public static List <S1_Clients_PaymentToInvoiceSearchByIDResult> PaymentToInvoiceSearchByID(int clientID, string paymentID) { using (ClientsDataContext dc = new ClientsDataContext()) { return(dc.S1_Clients_PaymentToInvoiceSearchByID(clientID, paymentID).ToList()); } }
public static List <S1_Clients_InvoiceToPaymentSearchByDateResult> InvoiceToPaymentSearchByDate(int clientID, string Date) { using (ClientsDataContext dc = new ClientsDataContext()) { return(dc.S1_Clients_InvoiceToPaymentSearchByDate(clientID, Date).ToList()); } }
public static List <S1_Clients_InvoiceToPaymentSearchByAmountResult> InvoiceToPaymentSearchByAmount(int clientID, string totalAmount) { using (ClientsDataContext dc = new ClientsDataContext()) { return(dc.S1_Clients_InvoiceToPaymentSearchByAmount(clientID, totalAmount).ToList()); } }
public static List <S1_Clients_InvoiceToPaymentSearchByInvoiceNumberResult> InvoiceToPaymentSearchByInvoiceNumber(int clientID, string paymentID) { using (ClientsDataContext dc = new ClientsDataContext()) { return(dc.S1_Clients_InvoiceToPaymentSearchByInvoiceNumber(clientID, paymentID).ToList()); } }
public static int GetParentClientIDFromUser(int _UserID) { int?clientID = null; var dc = new ClientsDataContext(); var result = dc.S1_Clients_GetClientsFromUser(_UserID); foreach (var item in result) { clientID = item.ClientID; if (item.ParentClientID == null) { return(item.ClientID); } } if (clientID.HasValue) { int?parentClientID = new int?(); var result2 = dc.S1_Clients_GetClientParentWithOutput(clientID.Value, ref parentClientID); if (parentClientID.HasValue) { return(parentClientID.Value); } } return(0); }
public static List <S1_Clients_InvoiceToPaymentSearchByQBResult> InvoiceToPaymentSearchByQB(int clientID, string QBTransactionID) { using (ClientsDataContext dc = new ClientsDataContext()) { return(dc.S1_Clients_InvoiceToPaymentSearchByQB(clientID, QBTransactionID).ToList()); } }
// End Client Invoice Settings // Expected Revenue Settings //Save = Add or Update public static void SaveExpectedRevenueSettings(int ClientID, decimal ExpectedMonthlyRevenue, DateTime AccountCreateDate, string AccountOwner, string AffiliateName) { using (ClientsDataContext dc = new ClientsDataContext()) { dc.S1_Clients_SaveExpectedRevenueSettings(ClientID, ExpectedMonthlyRevenue, AccountCreateDate, AccountOwner, AffiliateName); } }
public static List <S1_Clients_GetClientListForInvoiceBalancerResult> GetClientListForInvoiceBalancer() { using (ClientsDataContext dc = new ClientsDataContext()) { return(dc.S1_Clients_GetClientListForInvoiceBalancer().ToList()); } }
//returns 0 if admin or client not found public static int GetCurrentClientID(Controller c) { var db = new ClientsDataContext(); var results = db.S1_Clients_GetClientsFromUser(GetCurrentUserIDFromName(c.User.Identity.Name)).SingleOrDefault(); return(results.ClientID); }
//Update public static void UpdateClientInvoiceSettings(int _ClientID, int _InvoiceTemplate, int _ClientSplitMode, int _BillingDetailReport, bool _HideSSN, bool _ApplyFinanceCharges, int _FinChargeDays, decimal _FinChargePct, bool _SentToCollections, bool _ExcludeFromReminders) { var dc = new ClientsDataContext(); dc.S1_Clients_UpdateClientInvoiceSettings(_ClientID, _InvoiceTemplate, _ClientSplitMode, _BillingDetailReport, _HideSSN, _ApplyFinanceCharges, _FinChargeDays, _FinChargePct, _SentToCollections, _ExcludeFromReminders); }
//Update public static int UpdateClientInfo(int _ClientID, string ClientName, string Address1, string Address2, string City, string State, string Zip, int ParentClientID, string BillAsClientName, string Status, bool AuditInvoices, bool DoNotInvoice, int BillingGroupID, string notes) { var dc = new ClientsDataContext(); int result = dc.S1_Clients_UpdateClientInfo(_ClientID, ClientName, Address1, Address2, City, State, Zip, ParentClientID, BillAsClientName, Status, AuditInvoices, DoNotInvoice, BillingGroupID, notes); return(result); }
// Client Info //Create public static int CreateClient(string ClientName, string Address1, string Address2, string City, string State, string Zip, bool Tazworks1Client, bool Tazworks2Client, bool NonTazworksClient) { var dc = new ClientsDataContext(); var result = dc.S1_Clients_CreateClient(ClientName, Address1, Address2, City, State, Zip, Tazworks1Client, Tazworks2Client, NonTazworksClient).SingleOrDefault(); if (result.ClientID != 0) { return(result.ClientID.Value); } else { return(0); } }
//Gets the first primary BillingContactID for a BillAsClientName (QuickBooks Customer Name) public static int?GetFirstBillingContactFromBillAsClientName(string _BillAsClientName) { ClientsDataContext dc = new ClientsDataContext(); var result = dc.S1_Clients_GetFirstBillingContactFromBillAsClientName(_BillAsClientName).SingleOrDefault(); if (result != null) { return(result.BillingContactID); } else { return(null); } }
// End Client Vendor Settings public static List <int> GetClientIDsFromUser(int _UserID) { List <int> outList = new List <int>(); var dc = new ClientsDataContext(); var result = dc.S1_Clients_GetClientsFromUser(_UserID); foreach (var item in result) { outList.Add(item.ClientID); } return(outList); }
//Gets the first primary BillingContactID for a ClientID public static int?GetPrimaryBillingContactIDFromClient(int _ClientID) { ClientsDataContext dc = new ClientsDataContext(); var result = dc.S1_Clients_GetPrimaryBillingContactIDForClient(_ClientID).SingleOrDefault(); if (result != null) { return(result.BillingContactID); } else { return(0); } }
public static S1_Clients_GetClientsFromUserResult GetParentClientFromUser(int _UserID) { var dc = new ClientsDataContext(); var result = dc.S1_Clients_GetClientsFromUser(_UserID); foreach (var item in result) { if (item.ParentClientID == null) { return((S1_Clients_GetClientsFromUserResult)item); } } return(null); }
public static List <Client> GetClients() { List <Client> clientsList = new List <Client>(); var db = new ClientsDataContext(); var result = db.S1_Clients_GetClientList(); foreach (var item in result) { Client listitem = new Client(item.ClientID, item.ClientName, Convert.ToInt32(item.ParentClientID), item.ParentClientName, item.BillAsClientName, item.Status, Convert.ToDecimal(item.CurrentBalance)); clientsList.Add(listitem); } return(clientsList); }
public static bool RemovePayment(int clientID, int paymentID) { bool success = false; using (ClientsDataContext dc = new ClientsDataContext()) { var result = dc.S1_Clients_RemovePayment(clientID, paymentID).FirstOrDefault(); if (result != null && result.success.GetValueOrDefault()) { success = true; } } return(success); }
//return one ClientVendors record public static ClientVendors GetClientVendors(int _ClientID) { ClientVendors clientVendors; var dc = new ClientsDataContext(); var result = dc.S1_Clients_GetClientVendors(_ClientID).SingleOrDefault(); if (result != null) { clientVendors = new ClientVendors(result.Tazworks1ID, result.Tazworks2ID, result.Debtor11ID, result.TransUnionID, result.ExperianID, result.PembrookID, result.ApplicantONEID, result.RentTrackID); } else { clientVendors = new ClientVendors(); } return(clientVendors); }
public static List <SelectListItem> GetClientListFromUser(int _UserID) { List <SelectListItem> clientlist = new List <SelectListItem>(); var dc = new ClientsDataContext(); var result = dc.S1_Clients_GetClientsFromUser(_UserID); foreach (var item in result) { SelectListItem listitem = new SelectListItem(); listitem.Value = item.ClientID.ToString(); listitem.Text = item.ClientName; clientlist.Add(listitem); } return(clientlist); }
public static List <SelectListItem> GetClientsWithUnInvoicedProductTransactionsForDropdown(DateTime StartDate, DateTime EndDate) { List <SelectListItem> clientlist = new List <SelectListItem>(); var db = new ClientsDataContext(); var result = db.S1_Clients_GetClientsWithUnInvoicedProductTransactions(StartDate, EndDate); foreach (var item in result) { SelectListItem listitem = new SelectListItem(); listitem.Value = item.ClientID.ToString(); listitem.Text = item.ClientName; clientlist.Add(listitem); } return(clientlist); }
public static List <SelectListItem> GetClientListBySplitModeForDropdown(int SplitMode, DateTime StartDate, DateTime EndDate) { List <SelectListItem> clientlist = new List <SelectListItem>(); var db = new ClientsDataContext(); var result = db.S1_Clients_GetClientListBySplitMode(SplitMode, StartDate, EndDate); foreach (var item in result) { SelectListItem listitem = new SelectListItem(); listitem.Value = item.ClientID.ToString(); listitem.Text = item.ClientName; clientlist.Add(listitem); } return(clientlist); }
public static List <SelectListItem> GetClientsWithBillingContactsForDropdown() { List <SelectListItem> clientlist = new List <SelectListItem>(); var db = new ClientsDataContext(); var result = db.S1_Clients_GetClientsWithBillingContacts(); foreach (var item in result) { SelectListItem listitem = new SelectListItem(); listitem.Value = item.ClientID.ToString(); listitem.Text = item.ClientName; clientlist.Add(listitem); } return(clientlist); }
//Return a list of Billing Contacts for a client as SelectListItem's (for use in dropdowns) public static List <SelectListItem> GetBillingContactsForClient(int _ClientID) { List <SelectListItem> billingContactList = new List <SelectListItem>(); var dc = new ClientsDataContext(); var result = dc.S1_Clients_GetBillingContactsForClient(_ClientID); foreach (var item in result) { SelectListItem listitem = new SelectListItem(); listitem.Value = item.Value.ToString(); listitem.Text = item.Text; billingContactList.Add(listitem); } return(billingContactList); }
//return one client public static Client GetClient(int _ClientID) { Client client; var dc = new ClientsDataContext(); var result = dc.S1_Clients_GetClient(_ClientID).SingleOrDefault(); if (result != null) { client = new Client(result.ClientID, result.ClientName, Convert.ToInt32(result.ParentClientID), result.ParentClientName, result.BillAsClientName, result.Status, result.Address1, result.Address2, result.City, result.State, result.ZipCode, (result.DoNotInvoice.HasValue ? result.DoNotInvoice.Value : false), (result.AuditInvoices.HasValue ? result.AuditInvoices.Value : false), Convert.ToInt32(result.BillingGroup), result.Notes); } else { client = new Client(); } return(client); }
//return one ClientInvoiceSettings record public static ClientInvoiceSettings GetClientInvoiceSettings(int _ClientID) { ClientInvoiceSettings clientInvoiceSettings; var dc = new ClientsDataContext(); var result = dc.S1_Clients_GetClientInvoiceSettings(_ClientID).SingleOrDefault(); if (result != null) { clientInvoiceSettings = new ClientInvoiceSettings(result.InvoiceTemplateID, result.ReportGroupID.Value, result.SplitByMode.Value, (result.ApplyFinanceCharge.HasValue ? result.ApplyFinanceCharge.Value : false), Convert.ToInt32(result.FinanceChargeDays), Convert.ToDecimal(result.FinanceChargePercent), (result.SentToCollections.HasValue ? result.SentToCollections.Value : false), result.ExcludeFromReminders.GetValueOrDefault()); } else { clientInvoiceSettings = new ClientInvoiceSettings(); } return(clientInvoiceSettings); }