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);
}
