public bool ItemCodeExists(string itemCode)
{
return(Items.ItemExistsByCode(AppUsers.GetCurrentUserDB(), itemCode));
}
public int GetSalesTaxId(string tranBook, int storeId, string partyCode, string shippingAddressCode, int priceTypeId, string itemCode, int unitId, decimal price)
{
return(SalesTax.GetSalesTaxId(AppUsers.GetCurrentUserDB(), tranBook, storeId, partyCode, shippingAddressCode, priceTypeId, itemCode, unitId, price));
}
public override void OnControlLoad(object sender, EventArgs e)
{
this.TopSellingProductsLiteral.Text = Titles.TopSellingProductsOfAllTime;
this.TopSellingProductsGridView.Attributes.Add("style", "display:none;");
this.TopSellingProductsGridView.DataSource = Data.Reports.TopSellingProducts.GetTopSellingProductsOfAllTimeByOffice(AppUsers.GetCurrentUserDB());
this.TopSellingProductsGridView.DataBind();
}
public int GetAuthorizationPermission(AppUsers objAppUsers)
{
return(new AppUsersManager().GetAuthorizationPermission(objAppUsers));
}
public static bool HasActiveResetRequest(string email)
{
const string sql = "SELECT * FROM account.has_active_reset_request(@0::text);";
return(Factory.Scalar <bool>(AppUsers.GetCatalog(), sql, email));
}
public void RemoveWidget(string group, string widget)
{
Data.Core.Widget.RemoveWidget(AppUsers.GetCurrentUserDB(), group, widget);
}
public void OrderWidgets(List <WidgetSetup> widgets)
{
Data.Core.Widget.OrderWidgets(AppUsers.GetCurrentUserDB(), widgets);
}
public AppUsers Update(AppUsers Update)
{
return(uow.GetService <IAppUsersRepository>().Update(Update));
}
private static string GetDisplayFields()
{
List <string> displayFields = new List <string>();
string accountDisplayField = DbConfig.GetDbParameter(AppUsers.GetCurrentUserDB(), "AccountDisplayField");
ScrudHelper.AddDisplayField(displayFields, "core.item_groups.parent_item_group_id", DbConfig.GetDbParameter(AppUsers.GetCurrentUserDB(), "ItemGroupDisplayField"));
ScrudHelper.AddDisplayField(displayFields, "core.item_groups.sales_tax_id", DbConfig.GetDbParameter(AppUsers.GetCurrentUserDB(), "SalesTaxDisplayField"));
ScrudHelper.AddDisplayField(displayFields, "core.accounts.account_id", accountDisplayField);
ScrudHelper.AddDisplayField(displayFields, "core.item_groups.sales_account_id", accountDisplayField);
ScrudHelper.AddDisplayField(displayFields, "core.item_groups.sales_discount_account_id", accountDisplayField);
ScrudHelper.AddDisplayField(displayFields, "core.item_groups.sales_return_account_id", accountDisplayField);
ScrudHelper.AddDisplayField(displayFields, "core.item_groups.purchase_account_id", accountDisplayField);
ScrudHelper.AddDisplayField(displayFields, "core.item_groups.purchase_discount_account_id", accountDisplayField);
ScrudHelper.AddDisplayField(displayFields, "core.item_groups.inventory_account_id", accountDisplayField);
ScrudHelper.AddDisplayField(displayFields, "core.item_groups.cost_of_goods_sold_account_id", accountDisplayField);
return(string.Join(",", displayFields));
}
public string GetItemCodeByItemId(int itemId)
{
return(Items.GetItemCodeByItemId(AppUsers.GetCurrentUserDB(), itemId));
}
public AppUsers Delete(AppUsers user)
{
return(uow.GetService <IAppUsersRepository>().Delete(user));
}
public decimal CountItemInStock(string itemCode, int unitId, int storeId)
{
return(Items.CountItemInStock(AppUsers.GetCurrentUserDB(), itemCode, unitId, storeId));
}
public List <DbGetCompoundItemDetailsResult> GetCompoundItemDetails(string compoundItemCode,
string salesTaxCode, string tranBook, int storeId, string partyCode, int priceTypeId)
{
return(Items.GetCompoundItemDetails(AppUsers.GetCurrentUserDB(), compoundItemCode, salesTaxCode, tranBook,
storeId, partyCode, priceTypeId).ToList());
}
public bool UnitNameExists(string unitName)
{
return(Units.UnitExistsByName(AppUsers.GetCurrentUserDB(), unitName));
}
private void RegisterJavascript()
{
string script = JSUtility.GetVar("culture", CultureManager.GetCurrent().Name);
script += JSUtility.GetVar("language", CultureManager.GetCurrent().TwoLetterISOLanguageName);
script += JSUtility.GetVar("jqueryUIi18nPath", this.Page.ResolveUrl("~/Scripts/jquery-ui/i18n/"));
script += JSUtility.GetVar("today", string.Format(CultureManager.GetCurrent(), CultureManager.GetCurrent().DateTimeFormat.ShortDatePattern, DateTime.Now));
script += JSUtility.GetVar("now", DateTime.Now.ToString(CultureManager.GetCurrent()));
script += JSUtility.GetVar("date", DateTime.Now.ToString(CultureInfo.InvariantCulture));
script += JSUtility.GetVar("reportTemplatePath", PageUtility.ResolveUrl(DbConfig.GetScrudParameter(AppUsers.GetCurrentUserDB(), "TemplatePath")));
script += JSUtility.GetVar("reportExportTemplatePath", PageUtility.ResolveUrl(DbConfig.GetScrudParameter(AppUsers.GetCurrentUserDB(), "ExportTemplatePath")));
script += JSUtility.GetVar("reportHeaderPath", PageUtility.ResolveUrl(DbConfig.GetScrudParameter(AppUsers.GetCurrentUserDB(), "HeaderPath")));
script += JSUtility.GetVar("userId", AppUsers.GetCurrent().View.UserId);
script += JSUtility.GetVar("user", AppUsers.GetCurrent().View.UserName);
script += JSUtility.GetVar("officeCode", AppUsers.GetCurrent().View.OfficeCode);
script += JSUtility.GetVar("office", AppUsers.GetCurrent().View.OfficeName);
script += JSUtility.GetVar("applicationDates", JsonConvert.SerializeObject(DatePersister.GetFrequencyDates(AppUsers.GetCurrentUserDB(), AppUsers.GetCurrent().View.OfficeId.ToInt())), false);
script += JSUtility.GetVar("metaView", JsonConvert.SerializeObject(AppUsers.GetCurrent().View), false);
script += JSUtility.GetVar("overridePath", this.OverridePath);
script += JSUtility.GetVar("shortDateFormat", CultureManager.GetShortDateFormat());
script += JSUtility.GetVar("longDateFormat", CultureManager.GetLongDateFormat());
script += JSUtility.GetVar("thousandSeparator", CultureManager.GetThousandSeparator());
script += JSUtility.GetVar("decimalSeparator", CultureManager.GetDecimalSeparator());
script += JSUtility.GetVar("currencyDecimalPlaces", CultureManager.GetCurrencyDecimalPlaces());
script += JSUtility.GetVar("currencySymbol", CultureManager.GetCurrencySymbol());
script += JSUtility.GetVar("today", DateTime.Now.ToShortDateString());
script += JSUtility.GetVar("shortDateFormat", CultureManager.GetShortDateFormat());
script += JSUtility.GetVar("thousandSeparator", CultureManager.GetThousandSeparator());
script += JSUtility.GetVar("decimalSeparator", CultureManager.GetDecimalSeparator());
script += JSUtility.GetVar("currencyDecimalPlaces", CultureManager.GetCurrencyDecimalPlaces());
script += JSUtility.GetVar("baseCurrencyCode", AppUsers.GetCurrent().View.CurrencyCode);
script += JSUtility.GetVar("catalog", AppUsers.GetCurrentUserDB());
script += JSUtility.GetVar("update", this.Update());
script += JSUtility.GetVar("firstStepsPending", this.Context.Session["FirstStepsPending"]);
script += JSUtility.GetVar("datepickerFormat", jQueryUI.GetDatePickerFormat());
script += JSUtility.GetVar("datepickerShowWeekNumber", jQueryUI.ShowWeekNumber());
script += JSUtility.GetVar("datepickerWeekStartDay", jQueryUI.GetWeekStartDay());
script += JSUtility.GetVar("datepickerNumberOfMonths", jQueryUI.GetNumberOfMonths());
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "MixERPMasterPage", script, true);
}
public Collection <ListItem> GetAddressByPartyCode(string partyCode)
{
Collection <ListItem> values = new Collection <ListItem>();
foreach (ShippingAddressView view in ShippingAddresses.GetShippingAddressView(AppUsers.GetCurrentUserDB(), partyCode))
{
string address = string.Format(CultureInfo.InvariantCulture, "{0}{1}{2}{1}{3}{4}{5}{1}{6}{4}{7}", view.AddressLine1, Environment.NewLine, view.AddressLine2, view.Street, ", ", view.City, view.State, view.Country);
values.Add(new ListItem(view.ShippingAddressCode, address));
}
return(values);
}
private void CreateBackupNameField(HtmlGenericControl container)
{
using (HtmlGenericControl field = HtmlControlHelper.GetField())
{
using (
HtmlGenericControl label = HtmlControlHelper.GetLabel(Titles.EnterBackupName, "BackupNameInputText")
)
{
field.Controls.Add(label);
}
using (HtmlInputText backupNameInputText = new HtmlInputText())
{
this.server.Validate();
backupNameInputText.ID = "BackupNameInputText";
if (this.server.IsValid)
{
backupNameInputText.Value = string.Format(CultureInfo.InvariantCulture, "{0}.{1}.{2}.{3}",
this.server.DatabaseName, AppUsers.GetCurrent().View.OfficeId.ToInt(),
AppUsers.GetCurrent().View.UserName, DateTime.Now.ToFileTime());
}
field.Controls.Add(backupNameInputText);
}
container.Controls.Add(field);
}
}
public string GetPartyCodeByPartyId(int partyId)
{
return(Parties.GetPartyCodeByPartyId(AppUsers.GetCurrentUserDB(), partyId));
}
public void AddWidget(int order, string group, string widget)
{
Data.Core.Widget.AddWidget(AppUsers.GetCurrentUserDB(), order, group, widget);
}
public DbGetPartyTransactionSummaryResult GetPartyDue(string partyCode)
{
int officeId = AppUsers.GetCurrentLogin().View.OfficeId.ToInt();
return(Parties.GetPartyDue(AppUsers.GetCurrentUserDB(), officeId, partyCode));
}
private void BindGrid()
{
DateTime from = Conversion.TryCastDate(this.fromDateTextBox.Text);
DateTime to = Conversion.TryCastDate(this.toDateTextBox.Text);
decimal factor = Conversion.TryCastDecimal(this.factorInputText.Value);
int userId = AppUsers.GetCurrent().View.UserId.ToInt();
int officeId = AppUsers.GetCurrent().View.OfficeId.ToInt();
this.cashflowStatementGridView.DataSource = Data.Reports.CashFlow.GetDirectCashFlowStatement(AppUsers.GetCurrentUserDB(), from, to, userId, officeId, factor);
this.cashflowStatementGridView.DataBind();
}
public PartyView GetPartyView(string partyCode)
{
return(Parties.GetPartyView(AppUsers.GetCurrentUserDB(), partyCode));
}
public static void CompleteReset(string requestId, string password)
{
const string sql = "SELECT * FROM account.complete_reset(@0::uuid, @1::text)";
Factory.NonQuery(AppUsers.GetCatalog(), sql, requestId, password);
}
public IEnumerable <ShippingAddress> GetShippingAddresses(string partyCode)
{
return(Parties.GetShippingAddresses(AppUsers.GetCurrentUserDB(), partyCode));
}
public decimal GetSalesTax(string tranBook, int storeId, string partyCode, string shippingAddressCode, int priceTypeId, string itemCode, decimal price, int quantity, decimal discount, decimal shippingCharge, int salesTaxId)
{
return(SalesTax.GetSalesTax(AppUsers.GetCurrentUserDB(), tranBook, storeId, partyCode, shippingAddressCode, priceTypeId, itemCode, price, quantity, discount, shippingCharge, salesTaxId));
}
private void editcreateuserbtn_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(usernametxtbox.Text) || string.IsNullOrEmpty(surnametxtbox.Text) || string.IsNullOrEmpty(fintxtbox.Text) || string.IsNullOrEmpty(numbertxtbox.Text) || string.IsNullOrEmpty(emailtxtbox.Text))
{
MessageBox.Show("Fill all fields", "Warning!!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (fintxtbox.Text.Length < 7)
{
MessageBox.Show("Invalid FIN", "Warning!!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
AppUsers appUser = new AppUsers()
{
Name = usernametxtbox.Text,
Surname = surnametxtbox.Text,
FIN = fintxtbox.Text,
PhoneNumber = numbertxtbox.Text,
Email = emailtxtbox.Text,
Password = passwordtxtbox.Text,
rolesId = (int)rolecombobox.SelectedValue
};
if (isEdit)
{
AddUpdateResponseModel result = accountRepository.UpdateUser(appUser);
if (result.Status)
{
MessageBox.Show("User Edited", "Edited", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show(result.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
else
{
if (!string.IsNullOrEmpty(passwordtxtbox.Text.Trim()))
{
AddUpdateResponseModel result = accountRepository.AddUser(appUser);
if (result.Status)
{
MessageBox.Show("User Created", "Created", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show(result.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
else
{
MessageBox.Show("Incorrect password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
userdatagrid.DataSource = accountRepository.GetAppUsers();
clearbtn_Click(sender, e);
}
public async Task <IActionResult> Register()
{
var appUsers = new AppUsers();
return(View(appUsers));
}
public void Terminate(int counter)
{
string catalog = AppUsers.GetCurrentUserDB();
this.Clients.All.terminate(counter, catalog);
}
public IEnumerable <Currency> GetExchangeCurrencies()
{
int officeId = AppUsers.GetCurrent().View.OfficeId.ToInt();
return(Currencies.GetExchangeCurrencies(AppUsers.GetCurrentUserDB(), officeId));
}
public bool IsStockItem(string itemCode)
{
return(Items.IsStockItem(AppUsers.GetCurrentUserDB(), itemCode));
}
