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 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)));
}
private void MakeGeneralLedger(string IDs)
{
decimal amount = 0;
int newId = 0;
string period = string.Empty;
string IDx = string.Empty;
IList <string> items = new List <string>(IDs.Split(new string[] { ";" }, StringSplitOptions.None));
foreach (string item in items)
{
var list = item.Split(new string[] { "," }, StringSplitOptions.None);
IDx = list[1];
period = list[2];
amount = Convert.ToDecimal(list[3], CultureInfo.InvariantCulture);
ImmoDetailViewModel details = IWSLookUp.GetImmoDetail(IDx, period);
MasterCompta header = new MasterCompta()
{
CostCenter = details.CostCenter,
account = "6222",
HeaderText = IWSLocalResource.Depreciation,
TransDate = details.TransDate,
ItemDate = details.ItemDate,
EntryDate = details.EntryDate,
CompanyId = details.CompanyId,
ModelId = (int)IWSLookUp.ComptaMasterModelId.GeneralLedger,
IsValidated = false
};
newId = MakeGLHeader(header);
DetailCompta detailCompta = new DetailCompta()
{
transid = newId,
account = details.OAccount,
side = details.Side,
oaccount = details.Account,
amount = Math.Round(amount, 2),
duedate = details.DueDate,
Currency = details.Currency,
ModelId = (int)IWSLookUp.ComptaMasterModelId.GeneralLedger,
Terms = null,
text = null,
Balanced = false
};
newId = MakeGLDetail(detailCompta);
if (newId > 0)
{
UpdateDepreciationDetail(IDx, period);
}
}
}
private int MakeGLDetail(DetailCompta detailCompta)
{
int id = 0;
try
{
db.DetailComptas.InsertOnSubmit(detailCompta);
db.SubmitChanges(ConflictMode.FailOnFirstConflict);
id++;
int transid = detailCompta.transid;
bool rs = IWSLookUp.SetJournal(transid);
db.SubmitChanges();
}
catch (Exception ex)
{
IWSLookUp.LogException(ex);
}
return(id);
}
