public ActionResult DeleteConfirmed(int id)
{
InvoiceProjectDetails invoiceProjectDetails = db.InvoiceProjectDetails.Find(id);
db.InvoiceProjectDetails.Remove(invoiceProjectDetails);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "invoiceId,amount,invoiceProjectDetailsId,projDetailsSpecialistId")] InvoiceProjectDetails invoiceProjectDetails)
{
if (ModelState.IsValid)
{
db.Entry(invoiceProjectDetails).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.invoiceId = new SelectList(db.Invoice, "invoiceId", "invoiceNum", invoiceProjectDetails.invoiceId);
ViewBag.projDetailsSpecialistId = new SelectList(db.ProjectDetailsSpecialist, "projDetailsSpecialistId", "projDetailsSpecialistId", invoiceProjectDetails.projDetailsSpecialistId);
return(View(invoiceProjectDetails));
}
// GET: InvoiceProjectDetails/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
InvoiceProjectDetails invoiceProjectDetails = db.InvoiceProjectDetails.Find(id);
if (invoiceProjectDetails == null)
{
return(HttpNotFound());
}
return(View(invoiceProjectDetails));
}
public void Crear_Factura(int iddetalle, int idcliente, int idproducto, int idestado, string fecha,
string numero, string projDetailsSpecialistId, string montos)
{
List <int> ids = Convert(projDetailsSpecialistId);
List <double> montosv = ConvertMontos(montos);
DateTime f = DateTime.Parse(fecha);
double montof = montosv.Sum();
Invoice i = new Invoice();
i.Client = db.Client.Find(idcliente);
i.Product = db.Product.Find(idproducto);
i.invoiceNum = numero;
i.amount = montof;
i.date = f;
db.Invoice.Add(i);
InvoiceStateSet issSet = new InvoiceStateSet
{
Invoice = i,
State1 = db.State.Find(idestado),
date = fecha,
description = db.State.Find(idestado).name
};
db.InvoiceStateSet.Add(issSet);
for (int j = 0; j < ids.Count; j++)
{
InvoiceProjectDetails ipd = new InvoiceProjectDetails();
ipd.projDetailsSpecialistId = ids[j];
ipd.amount = montosv[j];
ipd.Invoice = i;
db.InvoiceProjectDetails.Add(ipd);
}
//Restando del Detalle
ProjectDetails pd = db.ProjectDetails.Find(iddetalle);
pd.totalInvoiced = pd.totalInvoiced + montof;
pd.toInvoice = pd.totalContracted - pd.totalInvoiced;
//Atualizando proyecto
pd.ProjSup.Project.totalnvoiced = decimal.Parse((pd.totalInvoiced + montof).ToString());
pd.ProjSup.Project.toInvoiced = decimal.Parse((pd.totalContracted - pd.totalInvoiced).ToString());
db.SaveChanges();
}
// GET: InvoiceProjectDetails/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
InvoiceProjectDetails invoiceProjectDetails = db.InvoiceProjectDetails.Find(id);
if (invoiceProjectDetails == null)
{
return(HttpNotFound());
}
ViewBag.invoiceId = new SelectList(db.Invoice, "invoiceId", "invoiceNum", invoiceProjectDetails.invoiceId);
ViewBag.projDetailsSpecialistId = new SelectList(db.ProjectDetailsSpecialist, "projDetailsSpecialistId", "projDetailsSpecialistId", invoiceProjectDetails.projDetailsSpecialistId);
return(View(invoiceProjectDetails));
}
public void Editar_Factura(int?idfact, int?iddet, string projDetailsSpecialistId, string montos, string oldm)
{
List <int> ids = Convert(projDetailsSpecialistId);
List <double> montosv = ConvertMontos(montos);
Invoice i = db.Invoice.Find(idfact);
double montoant = i.amount;
db.InvoiceProjectDetails.RemoveRange(i.InvoiceProjectDetails);
for (int j = 0; j < ids.Count; j++)
{
InvoiceProjectDetails ipd = new InvoiceProjectDetails();
ipd.projDetailsSpecialistId = ids[j];
ipd.amount = montosv[j];
ipd.Invoice = i;
i.InvoiceProjectDetails.Add(ipd);
}
double montof = montosv.Sum();
i.amount = montof;
//Actualizando el Detalle
ProjectDetails pd = db.ProjectDetails.Find(iddet);
pd.totalInvoiced = pd.totalInvoiced + montof - montoant;
pd.toInvoice = pd.totalContracted - pd.totalInvoiced;
//Actualizar Proyecto
pd.ProjSup.Project.totalnvoiced = decimal.Parse((pd.totalInvoiced + montof - montoant).ToString());
pd.ProjSup.Project.toInvoiced = decimal.Parse((pd.totalContracted - pd.totalInvoiced).ToString());
//Actualizar Estado del SUplemento
Supplement s = pd.ProjSup.Supplement;
double facturado = s.ProjSup.Sum(z => z.ProjectDetails.Sum(ss => ss.totalInvoiced));
if (Math.Abs(facturado - decimal.ToDouble(s.amount)) < 0.1)
{
foreach (var state in s.StateCSupplement)
{
state.state = false;
}
StateC terminado = db.StateC.Find(10);
StateCSupplement stateCSupplement = new StateCSupplement
{
stateCId = terminado.stateCId,
Supplement = s,
date = DateTime.Now,
description = "Maximo de facturacion alcanzada",
state = true
};
db.StateCSupplement.Add(stateCSupplement);
}
else
{
if (s.StateCSupplement.First(a => a.state).stateCId == 10)
{
foreach (var state in s.StateCSupplement)
{
state.state = false;
}
StateC iniciado = db.StateC.Find(5);
StateCSupplement stateCSupplement = new StateCSupplement
{
stateCId = iniciado.stateCId,
Supplement = s,
date = DateTime.Now,
description = "Estado cambiado dinamicamente x Ediacion de Facturas",
state = true
};
db.StateCSupplement.Add(stateCSupplement);
}
}
/////////////////////////
db.SaveChanges();
}