public ActionResult GetMeta()
{
return(Json(new ViewModels.Dashboard
{
Culture = CultureManager.GetCurrent().Name,
Language = CultureManager.GetCurrent().TwoLetterISOLanguageName,
JqueryUIi18NPath = "/Scripts/jquery-ui/i18n/",
Today = DateTime.Now.ToShortDateString(),
Now = DateTime.Now.ToString(CultureManager.GetCurrent()),
UserId = AppUsers.GetCurrent().View.UserId,
User = AppUsers.GetCurrent().View.Email,
Office = AppUsers.GetCurrent().View.Office,
MetaView = AppUsers.GetCurrent().View,
ShortDateFormat = CultureManager.GetShortDateFormat(),
LongDateFormat = CultureManager.GetLongDateFormat(),
ThousandSeparator = CultureManager.GetThousandSeparator(),
DecimalSeparator = CultureManager.GetDecimalSeparator(),
CurrencyDecimalPlaces = CultureManager.GetCurrencyDecimalPlaces(),
CurrencySymbol = CultureManager.GetCurrencySymbol(),
DatepickerFormat = CultureManager.GetCurrent().DateTimeFormat.ShortDatePattern,
DatepickerShowWeekNumber = true,
DatepickerWeekStartDay = (int)CultureManager.GetCurrent().DateTimeFormat.FirstDayOfWeek,
DatepickerNumberOfMonths = "[2, 3]"
}, JsonRequestBehavior.AllowGet));
}
public ActionResult GetMeta()
{
return(this.Ok
(
new ViewModels.Dashboard
{
Culture = CultureManager.GetCurrent().Name,
Tenant = this.Tenant,
Language = CultureManager.GetCurrent().TwoLetterISOLanguageName,
JqueryUIi18NPath = "/Scripts/jquery-ui/i18n/",
Today = DateTime.Today.Date.ToString("O"),
Now = DateTimeOffset.UtcNow.ToString("O"),
UserId = this.AppUser.UserId,
User = this.AppUser.Email,
Office = this.AppUser.OfficeName,
MetaView = this.AppUser,
ShortDateFormat = CultureManager.GetShortDateFormat(),
LongDateFormat = CultureManager.GetLongDateFormat(),
ThousandSeparator = CultureManager.GetThousandSeparator(),
DecimalSeparator = CultureManager.GetDecimalSeparator(),
CurrencyDecimalPlaces = CultureManager.GetCurrencyDecimalPlaces(),
CurrencySymbol = CultureManager.GetCurrencySymbol(),
DatepickerFormat = CultureManager.GetCurrent().DateTimeFormat.ShortDatePattern,
DatepickerShowWeekNumber = true,
DatepickerWeekStartDay = (int)CultureManager.GetCurrent().DateTimeFormat.FirstDayOfWeek,
DatepickerNumberOfMonths = "[2, 3]"
}));
}
public static async Task <long> PostAsync(string tenant, TransactionPosting model, LoginView meta)
{
foreach (var item in model.Details)
{
if (item.Debit > 0 && item.Credit > 0)
{
throw new InvalidOperationException(I18N.InvalidData);
}
if (item.Debit == 0 && item.Credit == 0)
{
throw new InvalidOperationException(I18N.InvalidData);
}
if (item.Credit < 0 || item.Debit < 0)
{
throw new InvalidOperationException(I18N.InvalidData);
}
if (item.Credit > 0)
{
if (await Accounts.IsCashAccountAsync(tenant, item.AccountNumber).ConfigureAwait(true))
{
if (await CashRepositories.GetBalanceAsync(tenant, item.CashRepositoryCode, item.CurrencyCode).ConfigureAwait(true) < item.Credit)
{
throw new InvalidOperationException(I18N.InsufficientBalanceInCashRepository);
}
}
}
}
decimal drTotal = (from detail in model.Details select detail.LocalCurrencyDebit).Sum();
decimal crTotal = (from detail in model.Details select detail.LocalCurrencyCredit).Sum();
if (drTotal != crTotal)
{
throw new InvalidOperationException(I18N.ReferencingSidesNotEqual);
}
int decimalPlaces = CultureManager.GetCurrencyDecimalPlaces();
if ((from detail in model.Details
where
decimal.Round(detail.Credit * detail.ExchangeRate, decimalPlaces) !=
decimal.Round(detail.LocalCurrencyCredit, decimalPlaces) ||
decimal.Round(detail.Debit * detail.ExchangeRate, decimalPlaces) !=
decimal.Round(detail.LocalCurrencyDebit, decimalPlaces)
select detail).Any())
{
throw new InvalidOperationException(I18N.ReferencingSidesNotEqual);
}
long tranId = await TransactionPostings.AddAsync(tenant, meta, model).ConfigureAwait(true);
return(tranId);
}
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);
}
private void AddJavascript()
{
string script = JSUtility.GetVar("shortDateFormat", CultureManager.GetShortDateFormat());
script += JSUtility.GetVar("thousandSeparator", CultureManager.GetThousandSeparator());
script += JSUtility.GetVar("decimalSeparator", CultureManager.GetDecimalSeparator());
script += JSUtility.GetVar("currencyDecimalPlaces", CultureManager.GetCurrencyDecimalPlaces());
PageUtility.RegisterJavascript("SignInPage_Vars", script, this.Page, true);
}
private void AddJavascript()
{
string challenge = Guid.NewGuid().ToString().Replace("-", "");
this.Session["Challenge"] = challenge;
string script = JSUtility.GetVar("challenge", challenge);
script += JSUtility.GetVar("shortDateFormat", CultureManager.GetShortDateFormat());
script += JSUtility.GetVar("thousandSeparator", CultureManager.GetThousandSeparator());
script += JSUtility.GetVar("decimalSeparator", CultureManager.GetDecimalSeparator());
script += JSUtility.GetVar("currencyDecimalPlaces", CultureManager.GetCurrencyDecimalPlaces());
PageUtility.RegisterJavascript("SignInPage_Vars", script, this.Page, true);
}
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("user", AppUsers.GetCurrent().View.UserName);
script += JSUtility.GetVar("office", AppUsers.GetCurrent().View.OfficeName);
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());
PageUtility.RegisterJavascript("MixERPMasterPage", script, this.Page, true);
}
public static long Add(string catalog, DateTime valueDate, DateTime bookDate, int officeId, int userId,
long loginId, int costCenterId, string referenceNumber, Collection <JournalDetail> details,
Collection <Attachment> attachments)
{
if (details == null)
{
throw new InvalidOperationException(Errors.NoTransactionToPost);
}
if (details.Count.Equals(0))
{
throw new InvalidOperationException(Errors.NoTransactionToPost);
}
decimal debitTotal = (from detail in details select detail.LocalCurrencyDebit).Sum();
decimal creditTotal = (from detail in details select detail.LocalCurrencyCredit).Sum();
if (debitTotal != creditTotal)
{
throw new InvalidOperationException(Errors.ReferencingSidesNotEqual);
}
int decimalPlaces = CultureManager.GetCurrencyDecimalPlaces();
if ((from detail in details
where
decimal.Round(detail.Credit * detail.ExchangeRate, decimalPlaces) !=
decimal.Round(detail.LocalCurrencyCredit, decimalPlaces) ||
decimal.Round(detail.Debit * detail.ExchangeRate, decimalPlaces) !=
decimal.Round(detail.LocalCurrencyDebit, decimalPlaces)
select detail).Any())
{
throw new InvalidOperationException(Errors.ReferencingSidesNotEqual);
}
using (NpgsqlConnection connection = new NpgsqlConnection(DbConnection.GetConnectionString(catalog)))
{
connection.Open();
using (NpgsqlTransaction transaction = connection.BeginTransaction())
{
try
{
string sql =
"INSERT INTO transactions.transaction_master(transaction_master_id, transaction_counter, transaction_code, book, value_date, book_date, user_id, login_id, office_id, cost_center_id, reference_number) SELECT nextval(pg_get_serial_sequence('transactions.transaction_master', 'transaction_master_id')), transactions.get_new_transaction_counter(@ValueDate), transactions.get_transaction_code(@ValueDate, @OfficeId, @UserId, @LoginId), @Book, @ValueDate, @BookDate, @UserId, @LoginId, @OfficeId, @CostCenterId, @ReferenceNumber;SELECT currval(pg_get_serial_sequence('transactions.transaction_master', 'transaction_master_id'));";
long transactionMasterId;
using (NpgsqlCommand master = new NpgsqlCommand(sql, connection))
{
master.Parameters.AddWithValue("@ValueDate", valueDate);
master.Parameters.AddWithValue("@BookDate", bookDate);
master.Parameters.AddWithValue("@OfficeId", officeId);
master.Parameters.AddWithValue("@UserId", userId);
master.Parameters.AddWithValue("@LoginId", loginId);
master.Parameters.AddWithValue("@Book", "Journal");
master.Parameters.AddWithValue("@CostCenterId", costCenterId);
master.Parameters.AddWithValue("@ReferenceNumber", referenceNumber);
transactionMasterId = Conversion.TryCastLong(master.ExecuteScalar());
}
foreach (JournalDetail model in details)
{
sql =
"INSERT INTO transactions.transaction_details(value_date, transaction_master_id, tran_type, account_id, statement_reference, cash_repository_id, currency_code, amount_in_currency, local_currency_code, er, amount_in_local_currency) " +
"SELECT @ValueDate, @TransactionMasterId, @TranType, core.get_account_id_by_account_number(@AccountNumber::text), @StatementReference, office.get_cash_repository_id_by_cash_repository_code(@CashRepositoryCode), @CurrencyCode, @AmountInCurrency, transactions.get_default_currency_code_by_office_id(@OfficeId), @Er, @AmountInLocalCurrency;";
if (model.Credit > 0 && model.Debit > 0)
{
throw new InvalidOperationException(Errors.BothSidesCannotHaveValue);
}
if (model.LocalCurrencyCredit > 0 && model.LocalCurrencyDebit > 0)
{
throw new InvalidOperationException(Errors.BothSidesCannotHaveValue);
}
decimal amountInCurrency;
decimal amountInLocalCurrency;
string tranType;
if (model.Credit.Equals(0) && model.Debit > 0)
{
tranType = "Dr";
amountInCurrency = model.Debit;
amountInLocalCurrency = model.LocalCurrencyDebit;
}
else
{
tranType = "Cr";
amountInCurrency = model.Credit;
amountInLocalCurrency = model.LocalCurrencyCredit;
}
using (NpgsqlCommand transactionDetail = new NpgsqlCommand(sql, connection))
{
transactionDetail.Parameters.AddWithValue("@ValueDate", valueDate);
transactionDetail.Parameters.AddWithValue("@TransactionMasterId", transactionMasterId);
transactionDetail.Parameters.AddWithValue("@TranType", tranType);
transactionDetail.Parameters.AddWithValue("@AccountNumber", model.AccountNumber);
transactionDetail.Parameters.AddWithValue("@StatementReference",
model.StatementReference);
transactionDetail.Parameters.AddWithValue("@CashRepositoryCode",
model.CashRepositoryCode);
transactionDetail.Parameters.AddWithValue("@CurrencyCode", model.CurrencyCode);
transactionDetail.Parameters.AddWithValue("@AmountInCurrency", amountInCurrency);
transactionDetail.Parameters.AddWithValue("@OfficeId", officeId);
transactionDetail.Parameters.AddWithValue("@Er", model.ExchangeRate);
transactionDetail.Parameters.AddWithValue("@AmountInLocalCurrency",
amountInLocalCurrency);
transactionDetail.ExecuteNonQuery();
}
}
#region Attachment
if (attachments != null && attachments.Count > 0)
{
foreach (Attachment attachment in attachments)
{
sql =
"INSERT INTO core.attachments(user_id, resource, resource_key, resource_id, original_file_name, file_extension, file_path, comment) SELECT @UserId, @Resource, @ResourceKey, @ResourceId, @OriginalFileName, @FileExtension, @FilePath, @Comment;";
using (NpgsqlCommand attachmentCommand = new NpgsqlCommand(sql, connection))
{
attachmentCommand.Parameters.AddWithValue("@UserId", userId);
attachmentCommand.Parameters.AddWithValue("@Resource",
"transactions.transaction_master");
attachmentCommand.Parameters.AddWithValue("@ResourceKey", "transaction_master_id");
attachmentCommand.Parameters.AddWithValue("@ResourceId", transactionMasterId);
attachmentCommand.Parameters.AddWithValue("@OriginalFileName",
attachment.OriginalFileName);
attachmentCommand.Parameters.AddWithValue("@FileExtension",
Path.GetExtension(attachment.OriginalFileName));
attachmentCommand.Parameters.AddWithValue("@FilePath", attachment.FilePath);
attachmentCommand.Parameters.AddWithValue("@Comment", attachment.Comment);
attachmentCommand.ExecuteNonQuery();
}
}
}
#endregion Attachment
#region Auto Verification
sql = "SELECT * FROM transactions.auto_verify(@TranId::bigint, @OfficeId::integer);";
using (NpgsqlCommand command = new NpgsqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@TranId", transactionMasterId);
command.Parameters.AddWithValue("@OfficeId", officeId);
command.ExecuteNonQuery();
}
#endregion
transaction.Commit();
return(transactionMasterId);
}
catch (NpgsqlException ex)
{
Log.Warning(
@"Could not post transaction. ValueDate: {ValueDate}, OfficeId: {OfficeId}, UserId: {UserId}, LoginId: {LoginId}, CostCenterId:{CostCenterId}, ReferenceNumber: {ReferenceNumber}, Details: {Details}, Attachments: {Attachments}. {Exception}.",
valueDate, officeId, userId, loginId, costCenterId, referenceNumber, details, attachments,
ex);
transaction.Rollback();
throw;
}
catch (InvalidOperationException ex)
{
Log.Warning(
@"Could not post transaction. ValueDate: {ValueDate}, OfficeId: {OfficeId}, UserId: {UserId}, LoginId: {LoginId}, CostCenterId:{CostCenterId}, ReferenceNumber: {ReferenceNumber}, Details: {Details}, Attachments: {Attachments}. {Exception}.",
valueDate, officeId, userId, loginId, costCenterId, referenceNumber, details, attachments,
ex);
transaction.Rollback();
throw;
}
}
}
}
public async Task <ActionResult> PostAsync(TransactionPosting model)
{
if (!this.ModelState.IsValid)
{
return(this.InvalidModelState(this.ModelState));
}
foreach (var item in model.Details)
{
if (item.Debit > 0 && item.Credit > 0)
{
throw new InvalidOperationException(I18N.InvalidData);
}
if (item.Debit == 0 && item.Credit == 0)
{
throw new InvalidOperationException(I18N.InvalidData);
}
if (item.Credit < 0 || item.Debit < 0)
{
throw new InvalidOperationException(I18N.InvalidData);
}
if (item.Credit > 0)
{
if (await Accounts.IsCashAccountAsync(this.Tenant, item.AccountNumber).ConfigureAwait(true))
{
if (
await CashRepositories.GetBalanceAsync(this.Tenant, item.CashRepositoryCode,
item.CurrencyCode).ConfigureAwait(true) < item.Credit)
{
throw new InvalidOperationException(I18N.InsufficientBalanceInCashRepository);
}
}
}
}
decimal drTotal = (from detail in model.Details select detail.LocalCurrencyDebit).Sum();
decimal crTotal = (from detail in model.Details select detail.LocalCurrencyCredit).Sum();
if (drTotal != crTotal)
{
throw new InvalidOperationException(I18N.ReferencingSidesNotEqual);
}
int decimalPlaces = CultureManager.GetCurrencyDecimalPlaces();
if ((from detail in model.Details
where
decimal.Round(detail.Credit * detail.ExchangeRate, decimalPlaces) !=
decimal.Round(detail.LocalCurrencyCredit, decimalPlaces) ||
decimal.Round(detail.Debit * detail.ExchangeRate, decimalPlaces) !=
decimal.Round(detail.LocalCurrencyDebit, decimalPlaces)
select detail).Any())
{
throw new InvalidOperationException(I18N.ReferencingSidesNotEqual);
}
var user = await AppUsers.GetCurrentAsync().ConfigureAwait(true);
try
{
long tranId = await TransacitonPostings.AddAsync(this.Tenant, user, model).ConfigureAwait(true);
return(this.Ok(tranId));
}
catch (Exception ex)
{
return(this.Failed(ex.Message, HttpStatusCode.InternalServerError));
}
}