public ActionResult Create([Bind(Include = "clientId,dateCreation,name,identifAbrev,reup,street,city,province,telephone,email,agent,agentPosition,organismId,country,isSubject,fatherId,legalPerson")] Client client, int clientFather, string jsonData)
{
if (ModelState.IsValid)
{
ICollection <AccountBank> accountBanks = SetJson(jsonData);
if (accountBanks.Count > 0)
{
client.AccountBank = accountBanks;
foreach (AccountBank accountBank in accountBanks)
{
db.AccountBank.Add(accountBank);
}
}
if (!client.isSubject)
{
client.fatherId = null;
}
else
{
client.fatherId = clientFather;
}
db.Client.Add(client);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.organismId = new SelectList(db.Organism, "organismId", "name", client.organismId);
return(View(client));
}
public ActionResult Create([Bind(Include = "contractId,number,signedProvider,nom1,nom2,description,clientId,expirationDate,signedClient,comitteNumber,comitteDate")] Contract contract, int stateC, System.DateTime dateState, string descriptionState, int idClient)
{
if (ModelState.IsValid)
{
StateContract _stateContract = new StateContract
{
stateCId = stateC,
Contract = contract,
date = dateState,
description = descriptionState,
state = true
};
db.StateContract.Add(_stateContract);
contract.nom1 = "tempvalue";
contract.nom2 = "tmpvalue";
contract.clientId = idClient;
db.Contract.Add(contract);
db.SaveChanges();
return(RedirectToAction("Index", new { id = contract.clientId }));
}
ViewBag.clientId = contract.clientId;
ViewBag.stateC = db.StateC.Where(s => s.type == "Contrato");
//ViewBag.clientId = new SelectList(db.Client, "clientId", "name", contract.clientId);
return(View(contract));
}
public ActionResult Create([Bind(Include = "globalServiceId,name")] GlobalService globalService)
{
if (ModelState.IsValid)
{
db.GlobalService.Add(globalService);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(globalService));
}
public ActionResult Create([Bind(Include = "organismId,name")] Organism organism)
{
if (ModelState.IsValid)
{
db.Organism.Add(organism);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(organism));
}
public ActionResult Create([Bind(Include = "currencyTypeId,type")] CurrencyType currencyType)
{
if (ModelState.IsValid)
{
db.CurrencyType.Add(currencyType);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(currencyType));
}
public ActionResult Create([Bind(Include = "productId,name,description,version")] Product product)
{
if (ModelState.IsValid)
{
db.Product.Add(product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(product));
}
public ActionResult Create([Bind(Include = "rateId,rate1")] Rate rate)
{
if (ModelState.IsValid)
{
db.Rate.Add(rate);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(rate));
}
public ActionResult Create([Bind(Include = "bankId,name,branch,street,city,province,country")] Bank bank)
{
if (ModelState.IsValid)
{
db.Bank.Add(bank);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bank));
}
public ActionResult Create([Bind(Include = "areaId,name,boss,areaEntityId")] Area area)
{
if (ModelState.IsValid)
{
db.Area.Add(area);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.areaEntityId = new SelectList(db.Entity, "entityId", "name", area.areaEntityId);
return(View(area));
}
public ActionResult Create([Bind(Include = "entityId,name,reupCode,identifAbrev,organismId")] Entity entity)
{
if (ModelState.IsValid)
{
db.Entity.Add(entity);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.organismId = new SelectList(db.Organism, "organismId", "name", entity.organismId);
return(View(entity));
}
public ActionResult Create([Bind(Include = "stageId,name,serviceId,orden")] Stage stage)
{
if (ModelState.IsValid)
{
db.Stage.Add(stage);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.serviceId = new SelectList(db.Service, "serviceId", "name", stage.serviceId);
return(View(stage));
}
public ActionResult Create([Bind(Include = "specialistId,name,areaId,ci")] Specialist specialist)
{
if (ModelState.IsValid)
{
db.Specialist.Add(specialist);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.areaId = new SelectList(db.Area, "areaId", "name", specialist.areaId);
return(View(specialist));
}
public ActionResult Create([Bind(Include = "serviceId,name,globalServiceId,rateId")] Service service)
{
if (ModelState.IsValid)
{
db.Service.Add(service);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.globalServiceId = new SelectList(db.GlobalService, "globalServiceId", "name", service.globalServiceId);
ViewBag.rateId = new SelectList(db.Rate, "rateId", "rateId", service.rateId);
return(View(service));
}
public ActionResult Create([Bind(Include = "invoiceId,amount,invoiceProjectDetailsId,projDetailsSpecialistId")] InvoiceProjectDetails invoiceProjectDetails)
{
if (ModelState.IsValid)
{
db.InvoiceProjectDetails.Add(invoiceProjectDetails);
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));
}
public ActionResult Create([Bind(Include = "clientId,bankId,currencyTypeId,accountNumber,titular")] AccountBank accountBank)
{
if (ModelState.IsValid)
{
db.AccountBank.Add(accountBank);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.bankId = new SelectList(db.Bank, "bankId", "name", accountBank.bankId);
ViewBag.clientId = new SelectList(db.Client, "clientId", "name", accountBank.clientId);
ViewBag.currencyTypeId = new SelectList(db.CurrencyType, "currencyTypeId", "type", accountBank.currencyTypeId);
return(View(accountBank));
}
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();
}
public string SCron(Int32 id, Int32 idf, string d, string m)
{
List <ProjectDetails> pdtDetails = db.ProjectDetails.Where(p => p.projSupId == id).ToList();
if (pdtDetails.Count > 0)
{
foreach (var x in pdtDetails)
{
List <ProjectDetailsSpecialist> pds =
db.ProjectDetailsSpecialist.Where(p => p.projectDetailsId == x.projectDetailsId).ToList();
if (pds.Count > 0)
{
return("-1");
}
}
}
List <Schedule> sch = db.Schedule.Where(p => p.projSupId == id && p.stageId == idf).ToList();
if (sch.Count > 0)
{
foreach (var c in sch)
{
db.Schedule.Remove(c);
}
}
Schedule s = new Schedule();
s.projSupId = id;
s.stageId = idf;
s.nDays = float.Parse(d);
s.amount = float.Parse(m);
db.Schedule.Add(s);
/*ASignando detalle al proyecto*/
foreach (var projectdetail in db.ProjectDetails.Where(p => p.projSupId == id && p.stageId == idf))
{
db.ProjectDetails.Remove(projectdetail);
}
ProjectDetails pd = new ProjectDetails();
pd.projSupId = id;
pd.stageId = idf;
pd.totalContracted = float.Parse(m);
pd.totalInvoiced = 0;
pd.toInvoice = float.Parse(m);
pd.state = false;
db.ProjectDetails.Add(pd);
db.SaveChanges();
return("1");
}
public ActionResult Create([Bind(Include = "supplementId,number,name,contractId,amount,nom1,nom2,signedClient,productId,serviceId,signedProvider,comitteNumber,comitteDate,expirationDate")] Supplement supplement, int stateC, System.DateTime dateState, string descriptionState, string jsonClient, int contractId, bool idclient)
{
if (ModelState.IsValid)
{
supplement.nom1 = "tmpvalue";
supplement.nom2 = "tmpvalue";
StateCSupplement _stateCSupplement = new StateCSupplement
{
stateCId = stateC,
Supplement = supplement,
date = dateState,
description = descriptionState,
state = true
};
db.StateCSupplement.Add(_stateCSupplement);
List <string> stringData = SetJson(jsonClient);
decimal amountValue = 0;
if (stringData.Any())
{
for (int i = 0; i < stringData.Count(); i += 3)
{
int id = int.Parse(stringData.ElementAt(i));
string newAmount = stringData.ElementAt(i + 1);
string[] newValue = newAmount.Split('.');
decimal endValue = 0;
if (newValue.Count() == 2)
{
decimal decens = decimal.Parse(newValue[0]);
decimal centens = decimal.Parse(newValue[1]);
endValue = decens + (centens / 100);
}
else
{
endValue = decimal.Parse(newAmount);
}
string idproy = stringData.ElementAt(i + 2);
ClientSupplement clientSupplement = new ClientSupplement
{
clientId = id,
Supplement = supplement,
amount = endValue
};
amountValue += endValue;
if (clientSupplement != null)
{
db.ClientSupplement.Add(clientSupplement);
}
//creando los proyectos
Client client = db.Client.First(c => c.clientId == id);
if (client != null)
{
if (idproy != "*")
{
Project p = db.Project.Find(int.Parse(idproy));
ProjSup projSup = new ProjSup
{
Project = p,
Supplement = supplement,
amount = endValue
};
p.totalContracted += endValue;
p.toInvoiced += endValue;
db.ProjSup.Add(projSup);
}
else
{
State c = db.State.Find(3);
Project project = new Project
{
name = supplement.number + " - " + client.name,
clientId = id,
productId = supplement.productId,
advancePercent = 0,
totalContracted = endValue,
toInvoiced = endValue
};
db.Project.Add(project);
ProjectState ps = new ProjectState
{
State1 = c,
date = DateTime.Now,
description = "Proyecto creado automaticamente al crear Sumpelento",
state = true,
Project = project
};
db.ProjectState.Add(ps);
ProjSup projSup = new ProjSup
{
Project = project,
Supplement = supplement,
amount = endValue
};
db.ProjSup.Add(projSup);
}
}
}
}
supplement.amount = amountValue;
supplement.contractId = contractId;
db.Supplement.Add(supplement);
db.SaveChanges();
return(RedirectToAction("Index", new { id = supplement.contractId, idclient = idclient }));
}
ViewBag.contractId = contractId;
ViewBag.productId = new SelectList(db.Product, "productId", "name", supplement.productId);
ViewBag.serviceId = new SelectList(db.Service, "serviceId", "name", supplement.serviceId);
ViewBag.stateC = db.StateC.Where(s => s.type == "Suplemento");
Contract contract = db.Contract.First(c => c.contractId == contractId);
ViewBag.clientFather = db.Client.First(fa => fa.clientId == contract.clientId);
ViewBag.clients = db.Client.Where(cl => cl.fatherId == contract.clientId).ToList();
ViewBag.idclientValue = idclient;
return(View(supplement));
}