protected void Application_Error(object sender, EventArgs e)
{
Exception exception = System.Web.HttpContext.Current.Server.GetLastError();
IWSLookUp.LogException(exception);
//TODO: Handle Exception
}
public ActionResult DetailGridViewPartialAddNew([ModelBinder(typeof(DevExpressEditorsBinder))] BankAccount line, string owner)
{
var model = db.BankAccounts;
line.Owner = owner;
line.CompanyID = (string)Session["CompanyID"];
ViewBag.BankAccount = line;
if (ModelState.IsValid)
{
try
{
model.InsertOnSubmit(line);
db.SubmitChanges();
return(PartialView("DetailGridViewPartial", IWSLookUp.GetBankAccount(owner)));
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
IWSLookUp.LogException(e);
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
return(PartialView("DetailGridViewPartial", line));
}
public ActionResult SuppliersGridViewPartialAddNew([ModelBinder(typeof(DevExpressEditorsBinder))] Supplier item)
{
var model = db.Suppliers;
item.CompanyID = (string)Session["CompanyID"];
item.ModelId = (int)IWSLookUp.MetaModelId.Supplier;
DateTime dateTime = IWSLookUp.GetCurrentDateTime();
item.Posted = dateTime;
item.Updated = dateTime;
ViewBag.Supplier = item;
if (ModelState.IsValid)
{
try
{
model.InsertOnSubmit(item);
db.SubmitChanges();
Session["Suppliers"] = IWSLookUp.GetSupplier();
return(PartialView("SuppliersGridViewPartial", Session["Suppliers"]));
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
IWSLookUp.LogException(e);
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
return(PartialView("SuppliersGridViewPartial", item));
}
public ActionResult DetailDetailGridViewPartialDelete(int Id, int transId)
{
var model = db.DetailDetailComptas;
if (Id >= 0)
{
try
{
var item = model.FirstOrDefault(i => i.Id == Id);
if (item != null)
{
model.DeleteOnSubmit(item);
db.SubmitChanges();
var details = from detail in db.DetailComptas
where
detail.id == item.OID
select detail;
foreach (var detail in details)
{
detail.Balanced = false;
}
db.SubmitChanges();
}
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
}
}
return(PartialView("DetailDetailGridViewPartial", IWSLookUp.GetDetailDetailCompta(transId, (int)Session["Modelid"])));
}
public ActionResult RolesGridViewPartialUpdate([ModelBinder(typeof(DevExpressEditorsBinder))] IdentityRole item)
{
var model = context.Roles.ToList();
ViewData["role"] = item;
if (ModelState.IsValid)
{
try
{
var modelItem = model.FirstOrDefault(it => it.Id == item.Id);
if (modelItem != null)
{
UpdateModel(modelItem);
context.SaveChanges();
}
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
IWSLookUp.LogException(e);
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
return(PartialView("RolesGridViewPartial", context.Roles.ToList()));
}
public ActionResult MasterGridViewPartialUpdate([ModelBinder(typeof(DevExpressEditorsBinder))] MasterCompta item)
{
var model = db.MasterComptas;
int modelId = (int)Session["Modelid"];
ViewBag.MasterCompta = item;
if (ModelState.IsValid)
{
try
{
var modelItem = model.FirstOrDefault(it => it.id == item.id);
if (model != null)
{
this.UpdateModel(modelItem);
db.SubmitChanges();
}
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
return(PartialView("MasterGridViewPartial", IWSLookUp.GetMasterCompta((IWSLookUp.ComptaMasterModelId)modelId)));
}
public ActionResult DetailGridViewPartialUpdate([ModelBinder(typeof(DevExpressEditorsBinder))] DetailCompta line, int transId)
{
var model = db.DetailComptas;
line.transid = transId;
ViewBag.DetailCompta = line;
if (ModelState.IsValid)
{
try
{
var modelItem = model.FirstOrDefault(p => p.id == line.id);
if (modelItem != null)
{
this.UpdateModel(modelItem);
db.SubmitChanges();
IWSLookUp.SetJournal(transId);
}
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
return(PartialView("DetailGridViewPartial", IWSLookUp.GetDetailCompta(transId)));
}
public ActionResult CallbackPanelPartialView(int currentModelId)
{
Session["ModelId"] = currentModelId;
Session["IsVending"] = IsVending(currentModelId);
return(PartialView("CallbackPanelPartialView",
IWSLookUp.GetMasterCompta((IWSLookUp.ComptaMasterModelId)currentModelId)));
}
public ActionResult DetailGridViewPartialAddNew([ModelBinder(typeof(DevExpressEditorsBinder))] CashLine line, int transId)
{
var model = db.CashLines;
line.TransId = transId;
ViewData["line"] = line;
if (ModelState.IsValid)
{
try
{
model.InsertOnSubmit(line);
db.SubmitChanges();
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
IWSLookUp.LogException(e);
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
return(PartialView("DetailGridViewPartial", IWSLookUp.GetCashLines(transId)));
}
public ActionResult MenuUIGridViewPartialUpdate([ModelBinder(typeof(DevExpressEditorsBinder))] Menu item)
{
var model = db.Menus;
ViewData["menus"] = item;
if (ModelState.IsValid)
{
try
{
var modelItem = model.FirstOrDefault(it => it.ID == item.ID);
if (modelItem != null)
{
this.UpdateModel(modelItem);
db.SubmitChanges();
return(PartialView("MenuUIGridViewPartial", IWSLookUp.GetMenus()));
}
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
IWSLookUp.LogException(e);
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
return(PartialView("MenuUIGridViewPartial", item));
}
private static void UpdatePdfDetails(int Id)
{
string query = "Update MasterCompta Set FileName = NULL, FileContent = NULL, ContentType = NULL Where Id= @Id;";
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["IWSConnectionString"].ToString()))
{
using (SqlCommand command = new SqlCommand(query, connection))
{
try
{
connection.Open();
command.Parameters.Add("@Id", SqlDbType.Int).Value = Id;
command.ExecuteScalar();
command.Parameters.Clear();
}
catch (Exception ex)
{
IWSLookUp.LogException(ex);
}
finally
{
if (connection.State.Equals(ConnectionState.Open))
{
connection.Close();
}
}
}
}
}
public ActionResult MenuUIGridViewPartialAddNew([ModelBinder(typeof(DevExpressEditorsBinder))] Menu item)
{
var model = db.Menus;
item.CompanyID = (string)Session["CompanyID"];
item.HasAccess = false;
item.Disable = false;
ViewData["menus"] = item;
if (ModelState.IsValid)
{
try
{
model.InsertOnSubmit(item);
db.SubmitChanges();
return(PartialView("MenuUIGridViewPartial", IWSLookUp.GetMenus()));
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
IWSLookUp.LogException(e);
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
return(PartialView("MenuUIGridViewPartial", item));
}
public ActionResult ImmoGridViewPartialUpdate([ModelBinder(typeof(DevExpressEditorsBinder))] Depreciation item)
{
var model = db.Depreciations;
ViewData["immo"] = item;
if (ModelState.IsValid)
{
try
{
var modelItem = model.FirstOrDefault(i => i.Id == item.Id);
if (modelItem != null)
{
this.UpdateModel(modelItem);
db.SubmitChanges();
DeleteDepreciation(item);
SetDepreciation(item);
}
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
IWSLookUp.LogException(e);
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
return(PartialView("ImmoGridViewPartial", IWSLookUp.GetDepreciation()));
}
public ActionResult ImmoGridViewPartialAddNew([ModelBinder(typeof(DevExpressEditorsBinder))] Depreciation item)
{
var model = db.Depreciations;
item.CompanyId = (string)Session["CompanyID"];
item.ModelId = (int)IWSLookUp.MetaModelId.Asset;
DateTime dateTime = IWSLookUp.GetCurrentDateTime();
item.Posted = dateTime;
item.Updated = dateTime;
ViewData["immo"] = item;
if (ModelState.IsValid)
{
try
{
model.InsertOnSubmit(item);
db.SubmitChanges();
SetDepreciation(item);
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
IWSLookUp.LogException(e);
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
return(PartialView("ImmoGridViewPartial", IWSLookUp.GetDepreciation()));
}
public ActionResult CallbackPanelPartial(string ClassId, string Start)
{
if (string.IsNullOrWhiteSpace(Start) || string.IsNullOrWhiteSpace(ClassId))
{
return(PartialView("_CallbackPartialView"));
}
try
{
string account = IWSLookUp.HasNoParent(Start);
if (!string.IsNullOrEmpty(account))
{
string message = $"{account} {IWSLocalResource.HasNoParent}";
throw new System.Exception(message);
}
Session["ClassId"] = ClassId;
Session["txtStart"] = Start;
string company = (string)Session["CompanyID"];
List <ResultsViewModel> resultsView = (List <ResultsViewModel>)IWSLookUp.GetResultat(ClassId, Start, company);
Session["Results"] = resultsView;
List <ResultsViewModel> incomesAndBalanceView = (List <ResultsViewModel>)IWSLookUp.GetIncomesAndBalance(ClassId, Start, company);
Session["IncomesAndBalance"] = incomesAndBalanceView;
IncomesAndBalanceViewModel models = new IncomesAndBalanceViewModel
{
ResultsView = (List <ResultsViewModel>)Session["Results"],
IncomesAndBalanceView = (List <ResultsViewModel>)Session["IncomesAndBalance"]
};
return(PartialView("_CallbackPartialView"));
}
catch (System.Exception ex)
{
ViewData["GenericError"] = ex.Message;
IWSLookUp.LogException(ex);
return(PartialView("_CallbackPartialView"));
}
}
public ActionResult DetailGridViewPartialUpdate([ModelBinder(typeof(DevExpressEditorsBinder))] CashLine line, int transId)
{
var model = db.CashLines;
line.TransId = transId;
ViewData["line"] = line;
if (ModelState.IsValid)
{
try
{
var modelItem = model.FirstOrDefault(it => it.Id == line.Id);
if (modelItem != null)
{
this.UpdateModel(modelItem);
db.SubmitChanges();
}
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
IWSLookUp.LogException(e);
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
return(PartialView("DetailGridViewPartial", IWSLookUp.GetCashLines(transId)));
}
public ActionResult ResultatView()
{
Session["Results"] = null;
Session["IncomesAndBalance"] = null;
ViewData["class"] = IWSLookUp.GetClass();
return(PartialView());
}
public ActionResult MasterGridViewPartialAddNew([ModelBinder(typeof(DevExpressEditorsBinder))] Cash item)
{
var model = db.Cashes;
item.IsValidated = false;
item.CompanyId = (string)Session["CompanyID"];
ViewData["item"] = item;
ViewBag.IsNewRow = true;
if (ModelState.IsValid)
{
try
{
model.InsertOnSubmit(item);
db.SubmitChanges();
ViewData["NewKeyValue"] = item.Id;
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
IWSLookUp.LogException(e);
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
return(PartialView("MasterGridViewPartial", IWSLookUp.GetCash()));
}
public ActionResult DetailGridViewPartialAddNew([ModelBinder(typeof(DevExpressEditorsBinder))] DetailCompta line, int transId)
{
int modelId = (int)Session["Modelid"];
var model = db.DetailComptas;
line.transid = transId;
line.ModelId = modelId;
ViewBag.DetailCompta = line;
if (ModelState.IsValid)
{
try
{
model.InsertOnSubmit(line);
db.SubmitChanges();
IWSLookUp.SetJournal(transId);
db.SubmitChanges();
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
return(PartialView("DetailGridViewPartial", IWSLookUp.GetDetailCompta(transId)));
}
public ActionResult MasterGridViewPartialUpdate([ModelBinder(typeof(DevExpressEditorsBinder))] Cash item)
{
var model = db.Cashes;
ViewData["item"] = item;
ViewBag.IsNewRow = false;
if (ModelState.IsValid)
{
try
{
var modelItem = model.FirstOrDefault(it => it.Id == item.Id);
if (modelItem != null)
{
this.UpdateModel(modelItem);
db.SubmitChanges();
}
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
IWSLookUp.LogException(e);
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
return(PartialView("MasterGridViewPartial", IWSLookUp.GetCash()));
}
public ActionResult DetailGridViewPartialDelete(int Id, int transId)
{
var model = db.DetailComptas;
if (Id >= 0)
{
try
{
var item = model.FirstOrDefault(it => it.id == Id);
if (item != null)
{
model.DeleteOnSubmit(item);
}
db.SubmitChanges();
IWSLookUp.SetJournal(transId);
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
}
}
return(PartialView("DetailGridViewPartial", IWSLookUp.GetDetailCompta(transId)));
}
public ActionResult BankAccountsGridViewPartialAddNew([ModelBinder(typeof(DevExpressEditorsBinder))] BankAccount item)
{
var model = db.BankAccounts;
item.CompanyID = (string)Session["CompanyID"];
item.ModelId = (int)IWSLookUp.MetaModelId.BankAccount;
ViewData["bankAccount"] = item;
if (ModelState.IsValid)
{
try
{
model.InsertOnSubmit(item);
db.SubmitChanges();
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
return(PartialView("BankAccountsGridViewPartial", db.BankAccounts.Where(c => c.CompanyID == (string)Session["CompanyID"])));
}
public ActionResult RolesGridViewPartialAddNew([ModelBinder(typeof(DevExpressEditorsBinder))] IdentityRole item)
{
var roleManager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(context));
ViewData["role"] = item;
//item.CompanyID = (string)Session["CompanyID"];
if (ModelState.IsValid)
{
if (roleManager.RoleExists(item.Name.Trim()))
{
return(PartialView("RolesGridViewPartial", roleManager.Roles.ToList()));
}
try
{
var role = new IdentityRole(item.Name.Trim());
roleManager.Create(role);
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
IWSLookUp.LogException(e);
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
return(PartialView("RolesGridViewPartial", roleManager.Roles.ToList()));
}
public ActionResult BankAccountsGridViewPartialUpdate([ModelBinder(typeof(DevExpressEditorsBinder))] BankAccount item)
{
var model = db.BankAccounts;
ViewData["bankAccount"] = item;
if (ModelState.IsValid)
{
try
{
var modelItem = model.FirstOrDefault(it => it.IBAN == item.IBAN);
if (modelItem != null)
{
this.UpdateModel(modelItem);
db.SubmitChanges();
}
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
return(PartialView("BankAccountsGridViewPartial", db.BankAccounts.Where(c => c.CompanyID == (string)Session["CompanyID"])));
}
public ActionResult AssetsGridViewDelete(string id)
{
var model = db.Assets;
if (id != null)
{
try
{
var item = model.FirstOrDefault(it => it.Id == id);
if (item != null)
{
model.DeleteOnSubmit(item);
}
db.SubmitChanges();
Session["Assets"] = IWSLookUp.GetAssets();
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
IWSLookUp.LogException(e);
}
}
return(PartialView("AssetsGridViewPartial", Session["Assets"]));
}
public ActionResult AffectationJournalGridViewPartialAddNew([ModelBinder(typeof(DevExpressEditorsBinder))] AffectationJournal item)
{
item.CompanyID = (string)Session["CompanyID"];
ViewBag.AffectationDraft = item;
if (ModelState.IsValid)
{
try
{
db.AffectationJournals.InsertOnSubmit(item);
db.SubmitChanges();
Session["AffectationJournal"] = IWSLookUp.GetAffectationJournal();
return(PartialView("AffectationJournalGridViewPartial", Session["AffectationJournal"]));
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
ViewBag.Aff = IWSLookUp.GetAffectationJournal();
return(PartialView("AffectationJournalGridViewPartial", item));
}
public ActionResult DetailGridViewPartialUpdate([ModelBinder(typeof(DevExpressEditorsBinder))] BankAccount line, string owner)
{
var model = db.BankAccounts;
line.Owner = owner;
ViewBag.BankAccount = line;
if (ModelState.IsValid)
{
try
{
var modelItem = model.FirstOrDefault(i => i.IBAN == line.IBAN);
if (modelItem != null)
{
this.UpdateModel(modelItem);
db.SubmitChanges();
return(PartialView("DetailGridViewPartial", IWSLookUp.GetBankAccount(owner)));
}
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
IWSLookUp.LogException(e);
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
return(PartialView("DetailGridViewPartial", line));
}
public ActionResult AffectationJournalGridViewPartialUpdate([ModelBinder(typeof(DevExpressEditorsBinder))] AffectationJournal item)
{
var model = db.AffectationJournals;
item.CompanyID = (string)Session["CompanyID"];
ViewBag.AffectationDraft = item;
if (ModelState.IsValid)
{
try
{
var modelItem = model.FirstOrDefault(i => i.AccountID == item.AccountID &&
i.OAccountID == item.OAccountID &&
i.Side == item.Side &&
i.CompanyID == item.CompanyID
);
if (modelItem != null)
{
this.UpdateModel(modelItem);
db.SubmitChanges();
Session["AffectationJournal"] = IWSLookUp.GetAffectationJournal();
return(PartialView("AffectationJournalGridViewPartial", Session["AffectationJournal"]));
}
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
return(PartialView("AffectationJournalGridViewPartial", item));
}
public ActionResult SuppliersGridViewPartialUpdate([ModelBinder(typeof(DevExpressEditorsBinder))] Supplier item)
{
var model = db.Suppliers;
ViewBag.Supplier = item;
if (ModelState.IsValid)
{
try
{
var modelItem = model.FirstOrDefault(it => it.id == item.id);
if (modelItem != null)
{
this.UpdateModel(modelItem);
db.SubmitChanges();
Session["Suppliers"] = IWSLookUp.GetSupplier();
return(PartialView("SuppliersGridViewPartial", Session["Suppliers"]));
}
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
IWSLookUp.LogException(e);
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
return(PartialView("SuppliersGridViewPartial", item));
}
public ActionResult CompaniesGridViewPartialAddNew([ModelBinder(typeof(DevExpressEditorsBinder))] Company item)
{
var model = db.Companies;
ViewBag.Company = item;
item.ModelId = (int)IWSLookUp.MetaModelId.Company;
if (ModelState.IsValid)
{
try
{
model.InsertOnSubmit(item);
db.SubmitChanges();
Session["Company"] = IWSLookUp.GetCompany();
return(PartialView("CompaniesGridViewPartial", Session["Company"]));
}
catch (Exception e)
{
ViewData["GenericError"] = e.Message;
IWSLookUp.LogException(e);
}
}
else
{
ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState);
}
return(PartialView("CompaniesGridViewPartial", item));
}
