public void UpdateBusinessIsActive(string baseUrl, bool isActive)
{
int value = isActive ? 1 : 0;
using (ManagerIORepository repo = RepositoryHelper.Instance.GetRepository())
{
var sql = string.Format("update Business set IsActive = {0} where BaseApiUrl = '{1}'", value, baseUrl);
repo.Execute(sql);
}
}
public void insertInnerObjectKeys(List <string> innerObjKeys, string parentObjName, int parentObjId, string parentObjKey, decimal businessID, string businessKey)
{
using (ManagerIORepository repo = RepositoryHelper.Instance.GetRepository())
{
var sql = PetaPoco.Sql.Builder;
foreach (var i in innerObjKeys)
{
sql.Append("insert into innerobject values(@0,@1,@2,@3,@4,@5,@6)", i, parentObjName, parentObjId, parentObjKey, businessID, businessKey, true);
}
repo.Execute(sql);
}
}
public void insertLineDescriptionsKeys(List <DescriptionApiModel> keys)
{
using (ManagerIORepository repo = RepositoryHelper.Instance.GetRepository())
{
var sql = PetaPoco.Sql.Builder;
foreach (var i in keys)
{
sql.Append("insert into Description values(@0,@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11,@12)", i.Description, i.Qty, i.Item, i.Amount, i.Account, i.TaxCode, i.IsActive, i.Discount, i.DiscountType, i.EntityID, i.EntityTypeID, i.Invoice, i.Sequence);
}
repo.Execute(sql);
}
}
public void insertReceiptPaymentKeys(List <ReceiptAndPaymentApiModel> keys)
{
using (ManagerIORepository repo = RepositoryHelper.Instance.GetRepository())
{
var sql = PetaPoco.Sql.Builder;
foreach (var i in keys)
{
sql.Append("insert into ReceiptsPayments values(@0,@1,@2,@3,@4,@5,@6,@7,@8)", i.ApiKey, i.Date, i.BankAccount, i.Description, i.Contact, i.TransectionType, i.BusinessID, i.BusinessKey, i.IsActive);
}
repo.Execute(sql);
}
}
public void insertAttachmentKeys(List <AttachmentApiModel> keys)
{
using (ManagerIORepository repo = RepositoryHelper.Instance.GetRepository())
{
var sql = PetaPoco.Sql.Builder;
foreach (var i in keys)
{
sql.Append("insert into Attachment values(@0,@1,@2,@3,@4,@5,@6,@7,@8,@9)", i.ApiKey, i.Date, i.Name, i.ContentType, i.Size, i.Object, i.BusinessID, i.BusinessKey, i.IsActive, i.AttachmentUrl);
}
repo.Execute(sql);
}
}
public void insertComponentKeys(List <ComponentApiModel> keys)
{
using (ManagerIORepository repo = RepositoryHelper.Instance.GetRepository())
{
var sql = PetaPoco.Sql.Builder;
foreach (var i in keys)
{
sql.Append("insert into Component values(@0,@1,@2,@3,@4,@5,@6)", i.Name, i.Rate, i.Account, i.BusinessID, i.BusinessKey, i.IsActive, i.TaxCodeID);
}
repo.Execute(sql);
}
}
public void insertChartOfAccountsKeys(List <ChartofAccApiModel> keys)
{
using (ManagerIORepository repo = RepositoryHelper.Instance.GetRepository())
{
var sql = PetaPoco.Sql.Builder;
foreach (var i in keys)
{
sql.Append("insert into ChartofAccounts values(@0,@1,@2,@3,@4,@5,@6,@7)", i.ApiKey, i.Name, i.ParentAccountID, i.Group, i.BusinessID, i.BusinessKey, i.IsActive, i.Position);
}
repo.Execute(sql);
}
}
public void insertInventoryKeys(List <InventoryApiModel> keys)
{
using (ManagerIORepository repo = RepositoryHelper.Instance.GetRepository())
{
var sql = PetaPoco.Sql.Builder;
foreach (var i in keys)
{
sql.Append("insert into InventoryItem values(@0,@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11,@12,@13)", i.ApiKey, i.Name, i.Description, i.BusinessID, i.BusinessKey, i.IsActive, i.Code, i.UnitName, i.PurchasePrice, i.SalePrice, i.TaxCode, i.IncomeAccount, i.Inactive, i.ExpenseAccount);
}
repo.Execute(sql);
}
}
public void insertFolderKeys(List <FolderApiModel> keys)
{
using (ManagerIORepository repo = RepositoryHelper.Instance.GetRepository())
{
var sql = PetaPoco.Sql.Builder;
foreach (var i in keys)
{
sql.Append("insert into Folders values(@0,@1,@2,@3,@4)", i.ApiKey, i.Description, i.BusinessID, i.BusinessKey, i.IsActive);
}
repo.Execute(sql);
}
}
public void insertAccountKeys(List <AccountApiModel> keys)
{
using (ManagerIORepository repo = RepositoryHelper.Instance.GetRepository())
{
var sql = PetaPoco.Sql.Builder;
foreach (var i in keys)
{
sql.Append("insert into Accounts values(@0,@1,@2,@3,@4,@5,@6,@7)", i.ApiKey, i.Name, i.AccountType, i.BusinessID, i.BusinessKey, i.IsActive, i.CreditLimit, i.Code);
}
repo.Execute(sql);
}
}
public void insertBusinessDetailKeys(List <BusinessDetailApiModel> keys)
{
using (ManagerIORepository repo = RepositoryHelper.Instance.GetRepository())
{
var sql = PetaPoco.Sql.Builder;
foreach (var i in keys)
{
sql.Append("insert into BusinessDetail values(@0,@1,@2,@3,@4,@5)", i.ApiKey, i.Name, i.Address, i.BusinessID, i.BusinessKey, i.IsActive);
}
repo.Execute(sql);
}
}
public List <Business> InsertBusiness(List <BusinessApiModel> businessApiModel, string baseUrl, bool isActive)
{
List <Business> result = new List <Business>();
using (ManagerIORepository repo = RepositoryHelper.Instance.GetRepository())
{
var sql = PetaPoco.Sql.Builder;
foreach (var i in businessApiModel)
{
sql.Append("insert into Business values(@0,@1,@2,@3)", i.Key, i.Name, isActive, baseUrl);
}
repo.Execute(sql);
}
return(result = FetchApiService.Instance.getInsertedBusiness(baseUrl));
}
public void insertPartyKeys(List <PartyApiModel> keys, int ObjectID)
{
using (ManagerIORepository repo = RepositoryHelper.Instance.GetRepository())
{
var sql = PetaPoco.Sql.Builder;
foreach (var i in keys)
{
if (ObjectID == (int)ObjectEnum.Customer)
{
sql.Append("insert into Customers values(@0,@1,@2,@3,@4,@5,@6,@7,@8,@9)", i.ApiKey, i.Name, i.BusinessIdentifier, i.BillingAddress, i.BusinessID, i.BusinessKey, i.IsActive, i.Email, i.Code, i.CreditLimit);
}
else if (ObjectID == (int)ObjectEnum.Supplier)
{
sql.Append("insert into Suppliers values(@0,@1,@2,@3,@4,@5,@6,@7,@8)", i.ApiKey, i.Name, i.Email, i.Address, i.BusinessID, i.BusinessKey, i.IsActive, i.Code, i.CreditLimit);
}
}
repo.Execute(sql);
}
}
