public TaskCampaign SaveTaskRegister(string inputTask, Guid idAccount)
{
TaskCampaign result;
var taskModelView = JSonConvertUtil.Deserialize <TaskRegisterModelView>(inputTask);
var task = new TaskCampaign()
{
IdAccount = idAccount,
IdBranch = taskModelView.IdBranch,
IdCampaign = taskModelView.IdCampaign,
IdMerchant = taskModelView.IdMerchant,
IdStatusTask = taskModelView.IdStatusTask,
Description = taskModelView.Description,
StartDate = taskModelView.StartDate,
Campaign = null,
Branch = null
};
if (taskModelView.IdStatusTask == Guid.Empty)
{
var status = _statusTaskBusiness.GeStatusTaskByName(CTask.StatusPending);
task.IdStatusTask = status.Id;
}
using (var transaccion = Context.Database.BeginTransaction())
{
try
{
if (string.IsNullOrEmpty(task.Code))
{
var nextSequence = _sequenceBusiness.NextSequence(CTask.SequenceCode,
idAccount);
task.Code = nextSequence.ToString();
}
var stateRegister = EntityState.Added;
if (Guid.Empty != task.Id)
{
stateRegister = EntityState.Modified;
}
Context.TaskCampaigns.Add(task);
Context.Entry(task).State = stateRegister;
//graba cambios en COntexto
Context.SaveChanges();
transaccion.Commit();
result = GetTaskByIdForRegisterPage(task.Id, idAccount);
}
catch
{
transaccion.Rollback();
result = null;
}
}
return(result);
}
public string SaveDetalle(Invoice_detail _insertData, string numFact, int idAccount, int iduser, string option, string campaign, string statusStask)
{
bool status = false;
Branch branch = null;
Person person = null;
Central_Warenhouse centralw = new Central_Warenhouse();
Invoice invoice = new Invoice();
IQueryable <Invoice> invoices = Enumerable.Empty <Invoice>().AsQueryable();
IQueryable <Distributor> distributors = Enumerable.Empty <Distributor>().AsQueryable();
TaskCampaign task = null;
int idDistributor = 0;
try
{
invoices = Context.Invoices.Where(i => i.NUMBER == numFact);
if (invoices.Count() > 0)
{
invoice = invoices.First();
distributors = Context.Distributors.Where(d => d.RUC == invoice.RUC_CEDULA);
if (invoice.IDINVOICE != 0)
{
invoice.Invoice_details = new List <Invoice_detail>();
invoice.Invoice_details.Add(_insertData);
}
}
else
{
return("No puedo actualizar la información en la base de datos. Revise la Información");
}
Context.SaveChanges();
centralw.IDPRODUCTO = _insertData.IDPRODUCTO;
centralw.BALANCE = (decimal)_insertData.AMOUNT;
centralw.DESCRIPTION = _insertData.DESCRIPTION;
centralw.MOVEMENT = "1";
centralw.IDDISTRIBUTOR = distributors.Count() > 0 ? distributors.First().IDDISTRIBUTOR : 1;
Context.Central_Warenhouses.Add(centralw);
Context.SaveChanges();
Context.Query <string>($@"EXEC dbo.sp_actualiza_central_warehouse_app @idproducto = {centralw.IDPRODUCTO}, @iddistribuidor = {centralw.IDDISTRIBUTOR}");
return("");
}
catch (Exception e)
{
return("No puedo actualizar la información en la base de datos. Revise la Información");
throw;
}
finally
{
status = true;
}
}
/// <summary>
///
/// </summary>
/// <param name="taskCampaign"></param>
/// <returns></returns>
public static MyTaskViewModel ToMyTaskViewModel(TaskCampaign taskCampaign)
{
if (taskCampaign.IdTaskNoImplementedReason == null)
{
taskCampaign.IdTaskNoImplementedReason = Guid.Empty;
}
return(new MyTaskViewModel()
{
IdTask = taskCampaign.Id,
TaskCode = taskCampaign.Code,
IdCampaign = taskCampaign.IdCampaign,
IdAccount = taskCampaign.IdAccount,
CampaignName = taskCampaign.Campaign.Name,
IdCustomer = taskCampaign.Campaign.IdCustomer,
CustomerName = taskCampaign.Campaign.Customer.Name,
CustomerCode = taskCampaign.Campaign.Customer.Code,
IdMerchant = taskCampaign.IdMerchant,
MerchantName = taskCampaign.Merchant.Person.Name,
MerchantSurname = taskCampaign.Merchant.Person.SurName,
DateCreation = taskCampaign.DateCreation,
StartDate = taskCampaign.StartDate,
IdBranch = taskCampaign.IdBranch,
BranchName = taskCampaign.Branch.Name,
BranchLongitude = taskCampaign.Branch.LenghtBranch,
BranchLatitude = taskCampaign.Branch.LatitudeBranch,
IdStatusTask = taskCampaign.IdStatusTask,
StatusTaskName = taskCampaign.StatusTask.Name,
BranchOwnerName = taskCampaign.Branch.PersonOwner.Name,
BranchCity = taskCampaign.Branch.District.Name,
BranchSector = taskCampaign.Branch.Zone,
BranchParish = taskCampaign.Branch.Parish.Name,
BranchNeighborhood = taskCampaign.Branch.Neighborhood,
BranchMainStreet = taskCampaign.Branch.MainStreet,
BranchSecundaryStreet = taskCampaign.Branch.SecundaryStreet,
BranchReference = taskCampaign.Branch.Reference,
IdTaskNotImplementedReason = (Guid)taskCampaign.IdTaskNoImplementedReason,
CommentTaskNotImplemented = taskCampaign.CommentTaskNoImplemented,
Description = taskCampaign.Description,
//TODO: Revisar acceso para revisar estos datos
ServiceCollection = GetServiceCollection(taskCampaign.Campaign.CampaignServices),
BranchTypeBusiness = taskCampaign.Branch.TypeBusiness,
BranchExternalCode = taskCampaign.Branch.ExternalCode,
BranchMardisCode = taskCampaign.Branch.Code,
Route = taskCampaign.Route,
BranchLabel = taskCampaign.Branch.Label,
BranchOwnerPhone = taskCampaign.Branch.PersonOwner.Phone,
BranchOwnerMobile = taskCampaign.Branch.PersonOwner.Mobile,
BranchProvince = taskCampaign.Branch.Province.Name,
BranchOwnerDocument = taskCampaign.Branch.PersonOwner.Document
});
}
/// <summary>
///
/// </summary>
/// <param name="taskCampaign"></param>
/// <returns></returns>
public static TaskRegisterModelView ConvertTaskToTaskRegisterModelView(TaskCampaign taskCampaign)
{
return(new TaskRegisterModelView()
{
Id = taskCampaign.Id,
BranchName = taskCampaign.Branch.Name,
Code = taskCampaign.Code,
Description = taskCampaign.Description,
IdBranch = taskCampaign.IdBranch,
IdCampaign = taskCampaign.IdCampaign,
IdMerchant = taskCampaign.IdMerchant,
IdStatusTask = taskCampaign.IdStatusTask,
NameCampaign = taskCampaign.Campaign.Name,
NameMerchant = taskCampaign.Merchant.Profile.Name
});
}
public bool ModifyTask(TaskCampaign task)
{
using (var transaccion = Context.Database.BeginTransaction())
{
try
{
Context.TaskCampaigns.Add(task);
Context.Entry(task).State = EntityState.Modified;
Context.SaveChanges();
transaccion.Commit();
}
catch (Exception)
{
transaccion.Rollback();
return(false);
}
}
return(true);
}
public static TaskRegisterViewModel ToTaskRegisterViewModel(TaskCampaign task)
{
return(new TaskRegisterViewModel()
{
BranchName = task.Branch.Name,
Description = task.Description,
Id = task.Id,
IdBranch = task.IdBranch,
IdCampaign = task.IdCampaign,
IdMerchant = task.IdMerchant,
StartDate = task.StartDate,
IdStatusTask = task.IdStatusTask,
Code = task.Code,
DateCreation = task.DateCreation,
Route = task.Route,
AggregateUri = task.AggregateUri,
UserValidator = task.UserValidator,
ExternalCode = task.ExternalCode,
DateValidation = task.DateValidation
});
}
/// <summary>
/// Clase para guardar información que proviene de un archivo excel
/// </summary>
/// <param name="branchPerson"> El parametero tiene informacion de persona y local</param>
/// <returns></returns>
// public bool SaveBranchMigrate(IList<CBranch> branchPerson, Guid idAccount, Guid idcampaing)
// {
// bool status = false;
// Branch branch = null;
// Person person = null;
//#pragma warning disable CS0219 // La variable 'task' está asignada pero su valor nunca se usa
// TaskCampaign task = null;
//#pragma warning restore CS0219 // La variable 'task' está asignada pero su valor nunca se usa
// try
// {
// foreach (var item in branchPerson.Where(x => x.Code != "NA"))
// {
// using (var transaction = Context.Database.BeginTransaction())
// {
// try
// {
// var Getbrach = _brachDao.GetBranchByExternalCode(item.Code, idAccount);
// if (Getbrach == null)
// {
// var stateRegister = EntityState.Added;
// person = new Person();
// var ci = item.Document == null ? item.Code : item.Document;
// person.Code = item.Code;
// person.Name = item.PersonName;
// person.Phone = item.phone;
// person.Mobile = item.Mobil;
// person.Document = ci;
// person.SurName = "";
// person.TypeDocument = "CI";
// person.StatusRegister = "A";
// person.IdAccount = idAccount;
// //Context.SaveChanges();
// //Guid idperson = person.Id;
// branch = new Branch();
// branch.Code = item.Code;
// branch.ExternalCode = item.Code;
// branch.IdCountry = Guid.Parse("BE7CF5FF-296B-464D-82FA-EF0B4F48721B");// Pais ecuador
// branch.IdProvince = item.IdProvice;
// branch.IdDistrict = item.IdDistrict;
// branch.IdParish = item.IdParish;
// branch.IdSector = item.IdSector;
// branch.Name = item.BranchName;
// branch.Label = item.BranchName;
// branch.LatitudeBranch = item.LatitudeBranch;
// branch.LenghtBranch = item.LenghtBranch;
// branch.MainStreet = item.BranchStreet;
// branch.Reference = item.BranchReference;
// branch.Zone = "";
// branch.TypeBusiness = item.BranchType;
// branch.Neighborhood = "-";
// branch.SecundaryStreet = "-";
// branch.NumberBranch = "-";
// branch.IdPersonAdministrator = person.Id;
// branch.IdPersonOwner = person.Id;
// branch.IsAdministratorOwner = "SI";
// branch.IdAccount = idAccount;
// branch.IMEI_ID = item.IMEI;
// branch.RUTAAGGREGATE = item.Rute;
// branch.ESTADOAGGREGATE = "S";
// branch.routeDate = DateTime.Now;
// //Context.Branches.Add(branch);
// branch.PersonAdministration.IdAccount=
// Context.Persons.Add(person);
// Context.Entry(person).State = stateRegister;
// Context.SaveChanges();
// //task = new TaskCampaign();
// //task.Code = item.Code;
// //task.Description = "Agregada Para Gestión de Rutas";
// //task.ExternalCode = item.Code;
// //task.IdAccount = idAccount;
// //task.IdCampaign = idcampaing;
// //task.IdBranch = branch.Id;
// //task.IdMerchant = _userDao.GetMerchants(idAccount).First().Id;
// //task.IdStatusTask = Guid.Parse("7B0D0269-1AEF-4B73-9089-20E53698FF75");
// //task.StatusRegister = "A";
// //task.Route = item.Rute;
// //Context.TaskCampaigns.Add(task);
// //Context.Entry(task).State = stateRegister;
// //Context.SaveChanges();
// transaction.Commit();
// }
// else
// {
// var stateRegister = Guid.Empty == Getbrach.Id ? EntityState.Added : EntityState.Modified;
// Getbrach.IMEI_ID = item.IMEI;
// Getbrach.RUTAAGGREGATE = item.Rute;
// Getbrach.MainStreet = item.BranchStreet;
// Getbrach.Name = item.BranchName;
// Getbrach.Label = item.BranchName;
// Getbrach.Reference = item.BranchReference;
// Getbrach.LenghtBranch = item.LenghtBranch;
// Getbrach.LatitudeBranch = item.LatitudeBranch;
// Getbrach.ESTADOAGGREGATE = "S";
// Getbrach.routeDate = DateTime.Now;
// Context.Branches.Add(Getbrach);
// Context.Entry(Getbrach).State = stateRegister;
// Context.SaveChanges();
// //task = new TaskCampaign();
// //task.Code = item.Code;
// //task.Description = "Agregada Para Gestión de Rutas";
// //task.ExternalCode = item.Code;
// //task.IdAccount = idAccount;
// //task.IdCampaign = idcampaing;
// //task.IdBranch = Getbrach.Id;
// //task.IdMerchant = _userDao.GetMerchants(idAccount).First().Id;
// //task.IdStatusTask = Guid.Parse("7B0D0269-1AEF-4B73-9089-20E53698FF75");
// //task.StatusRegister = "A";
// //task.Route = item.Rute;
// //Context.TaskCampaigns.Add(task);
// //Context.Entry(task).State = EntityState.Modified;
// //Context.Entry(task).State = EntityState.Added;
// //Context.SaveChanges();
// transaction.Commit();
// }
// }
// catch (Exception ex)
// {
// transaction.Rollback();
// return false;
// }
// finally{
// status = true;
// }
// }
// }
// }
// catch (Exception)
// {
// return false;
// throw;
// }
// finally
// {
// status=true;
// }
// return status;
// }
// }
//}
public bool SaveBranchMigrate(IList <Branch> branchPerson, Guid idAccount, Guid idcampaing)
{
bool status = false;
Branch branch = null;
Person person = null;
#pragma warning disable CS0219 // La variable 'task' está asignada pero su valor nunca se usa
TaskCampaign task = null;
#pragma warning restore CS0219 // La variable 'task' está asignada pero su valor nunca se usa
try
{
var _dataUpdate = branchPerson.Where(x => x.Id != Guid.Parse("00000000-0000-0000-0000-000000000000"));
if (_dataUpdate.Count() > 0)
{
Context.Branches.UpdateRange(_dataUpdate);
Context.SaveChanges();
}
var _datainsert = branchPerson.Where(x => x.Id == Guid.Parse("00000000-0000-0000-0000-000000000000"));
if (_datainsert.Count() > 0)
{
Context.Branches.AddRange(_datainsert);
Context.SaveChanges();
}
return(true);
}
catch (Exception e)
{
return(false);
throw;
}
finally
{
status = true;
}
}
public string SaveInvoive(Invoice _insertData, int idAccount, int iduser, string option, string campaign, string statusStask)
{
bool status = false;
Branch branch = null;
Person person = null;
Central_Warenhouse centralw = new Central_Warenhouse();
Invoice invoice = new Invoice();
IQueryable <Invoice> invoices = Enumerable.Empty <Invoice>().AsQueryable();
TaskCampaign task = null;
try
{
invoices = Context.Invoices.Where(i => i.NUMBER == _insertData.NUMBER);
if (invoices.Count() > 0)
{
invoice = invoices.First();
}
else
{
invoice = _insertData;
Context.Invoices.Add(invoice);
}
Context.SaveChanges();
return("");
}
catch (Exception e)
{
return("No puedo actualizar la información en la base de datos. Revise la Información");
throw;
}
finally
{
status = true;
}
}
public string SaveProductNutriMigrate(Invoice _insertData, int idAccount, int iduser, string option, string campaign, string statusStask)
{
bool status = false;
Branch branch = null;
Person person = null;
Central_Warenhouse centralw = new Central_Warenhouse();
Invoice invoice = new Invoice();
IQueryable <Invoice> invoices = Enumerable.Empty <Invoice>().AsQueryable();
TaskCampaign task = null;
try
{
invoices = Context.Invoices.Where(i => i.NUMBER == _insertData.NUMBER);
if (invoices.Count() > 0)
{
invoice = invoices.First();
if (invoice.IDINVOICE != 0)
{
invoice.Invoice_details = new List <Invoice_detail>();
invoice.Invoice_details.Add(_insertData.Invoice_details.First());
}
}
else
{
invoice = _insertData;
Context.Invoices.Add(invoice);
}
Context.SaveChanges();
if (Context.Central_Warenhouses.Where(c => c.IDPRODUCTO == _insertData.Invoice_details.First().IDPRODUCTO).Count() > 0)
{
centralw = Context.Central_Warenhouses.Where(c => c.IDPRODUCTO == _insertData.Invoice_details.First().IDPRODUCTO).First();
if (centralw.ID_CENTRALW != 0)
{
centralw.BALANCE = centralw.BALANCE + (decimal)_insertData.Invoice_details.First().AMOUNT;
}
}
else
{
centralw.IDPRODUCTO = _insertData.Invoice_details.First().IDPRODUCTO;
//centralw.ID = _insertData.Invoice_details.First().IDPRODUCTO;
centralw.IDDISTRIBUTOR = 1;
centralw.BALANCE = (decimal)_insertData.Invoice_details.First().AMOUNT;
centralw.DESCRIPTION = _insertData.Invoice_details.First().DESCRIPTION;
centralw.MOVEMENT = "1";
Context.Central_Warenhouses.Add(centralw);
}
Context.SaveChanges();
return("");
}
catch (Exception e)
{
return("No puedo actualizar la información en la base de datos. Revise la Información");
throw;
}
finally
{
status = true;
}
}
/// <summary>
///
/// </summary>
/// <param name="branchPerson"></param>
/// <param name="idAccount"></param>
/// <param name="iduser"></param>
/// <param name="option"></param>
/// <param name="campaign"></param>
/// <param name="statusStask"></param>
/// <param name="datestart"></param>
/// <returns></returns>
public Branch GuardarlocalesCreadoAPPPedido(Branch branchPerson, int idAccount, string iduser, int option, int campaign, int statusStask, DateTime datestart)
{
bool status = false;
Branch branch = null;
Person person = null;
#pragma warning disable CS0219 // La variable 'task' está asignada pero su valor nunca se usa
TaskCampaign task = null;
#pragma warning restore CS0219 // La variable 'task' está asignada pero su valor nunca se usa
try
{
//var rutas = branchPerson.Select(x => x.RUTAAGGREGATE).Distinct();
if (branchPerson.Id != 0)
{
Context.Branches.Update(branchPerson);
Context.SaveChanges();
}
//var _datainsert = branchPerson.Where(x => x.Id == Guid.Parse("00000000-0000-0000-0000-000000000000"));
if (branchPerson.Id == 0)
{
Context.Branches.Add(branchPerson);
Context.SaveChanges();
}
if (option.Equals(2))
{
TaskCampaign _modelTask = new TaskCampaign();
var IMEID = branchPerson.IMEI_ID.Split('-');
if (IMEID.Length > 0)
{
if (IMEID[0] != "0")
{
try
{
var idpollster = Context.Pollsters.Where(x => x.IMEI == IMEID[0] &&
(datestart >= x.Fecha_Inicio && datestart <= x.Fecha_Fin) &&
x.idaccount.ToString().ToUpper() == idAccount.ToString().ToUpper() &&
x.Status == CStatusRegister.Active
);
_modelTask.idPollster = idpollster.FirstOrDefault().Id;
}
catch (Exception e)
{
return(null);
throw;
}
}
}
_modelTask.IdAccount = idAccount;
_modelTask.IdBranch = branchPerson.Id;
_modelTask.IdCampaign = campaign;
_modelTask.IdMerchant = Guid.Parse(iduser);
_modelTask.IdStatusTask = statusStask;
_modelTask.Route = branchPerson.RUTAAGGREGATE;
_modelTask.DateCreation = DateTime.Now;
_modelTask.StartDate = datestart;
_modelTask.DateModification = DateTime.Now;
_modelTask.Code = branchPerson.Code;
_modelTask.ExternalCode = branchPerson.Code;
_modelTask.Description = "Tarea creada desde carga de rutas";
_modelTask.StatusMigrate = "M";
Context.TaskCampaigns.Add(_modelTask);
Context.SaveChanges();
}
return(branchPerson);
}
catch (Exception e)
{
return(null);
throw;
}
finally
{
status = true;
}
}
