public int SaveInvoice(Mikhailova_invoices item)
{
try
{
if (item.id == 0)
{
db.Mikhailova_invoices.Add(item);
db.SaveChanges();
}
else
{
try
{
db.Entry(item).State = EntityState.Modified;
db.SaveChanges();
}
catch (OptimisticConcurrencyException ex)
{
RDL.Debug.LogError(ex);
}
}
}
catch (Exception ex)
{
RDL.Debug.LogError(ex);
}
return(item.id);
}
public Mikhailova_invoices GetInvoice(int id)
{
var res = new Mikhailova_invoices();
res = db.GetInvoice(id);
return(res);
}
public ActionResult EditInvoice(Mikhailova_invoices item)
{
var mng = new ContractsManager();
mng.SaveInvoice(item);
return(Json(new { result = true }));
}
public void SaveInvoice(Mikhailova_invoices item)
{
try
{
db.SaveInvoice(item);
}
catch (Exception ex)
{
RDL.Debug.LogError(ex);
}
}
public void SaveInvoice(Mikhailova_invoices item)
{
try
{
_db.SaveInvoice(item);
}
catch (Exception ex)
{
_debug(ex, new object { }, "");
}
}
public Mikhailova_invoices GetInvoice(int id)
{
var res = new Mikhailova_invoices();
try
{
res = _db.GetInvoices().FirstOrDefault(x => x.id == id);
}
catch (Exception ex)
{
_debug(ex, new { }, "");
}
return res;
}
public int SaveInvoice(Mikhailova_invoices element, bool withSave = true)
{
if (element.id == 0)
{
db.Mikhailova_invoices.Add(element);
}
else
{
db.Entry(element).State = EntityState.Modified;
}
if (withSave)
{
Save();
}
return(element.id);
}
public bool AddInvoice(int number, Mikhailova_invoices user)
{
bool res = false;
var invoice = new Mikhailova_invoices();
try
{
invoice = new Mikhailova_invoices
{
id = 0,
number = number.ToString(),
contagentID = user.id,
date = DateTime.Now,
};
SaveInvoice(invoice);
}
catch (Exception ex)
{
_debug(ex, new object { }, "");
}
return res;
}
public ActionResult CreateInvoice(string number, int contagentID, string desc)
{
var mng = new ContractsManager();
int statusID = 1;
var item = new Mikhailova_invoices
{
id = 0,
number = number,
date = DateTime.Now.Date,
statusID = statusID,
contagentID = contagentID,
desc = desc
};
mng.SaveInvoice(item);
return(Json(new
{
result = item.id > 0,
savedID = item.id,
}, JsonRequestBehavior.AllowGet));
}
public bool EditInvoiceField(int id, string code, string value, out string msg, Mikhailova_invoices user)
{
bool res = false;
var invoice = new Mikhailova_invoices();
try
{
invoice = GetInvoice(id);
if (invoice.contagentID != user.id)
{
msg = "Нет прав для редактирования счета";
return res;
}
if (invoice != null)
{
switch (code)
{
case "number": invoice.number = value;
break;
case "contractorID": invoice.contagentID = RDL.Convert.StrToInt(value, 0);
break;
case "comment": invoice.desc = value;
break;
case "InvoiceStatus": invoice.statusID = RDL.Convert.StrToInt(value, 0);
break;
}
SaveInvoice(invoice);
res = true;
msg = "Успешно";
}
else
msg = "Не удалось найти счет";
}
catch (Exception ex)
{
_debug(ex, new object { }, "");
msg = "Ошибка редатирования";
}
return res;
}
