//Method for adding new part numbers
public ActionResult Add(PartNumbers newPartNumber)
{
try
{
//If the captured data is valid
if (ModelState.IsValid)
{
//Execution of SP for inserting a new row in table PartNumbers
var result = db.sp_in_partnumber(newPartNumber.PartNumber, newPartNumber.IdCustomer, newPartNumber.Available).ToList();
//In case of execution success
if (result[0].Resultado == "OK")
{
ViewBag.ShowAlert = 1;
ViewBag.AlertMessage = "Part number successfully added.";
ModelState.Clear();
return(View(new PartNumbers()));
}
else //In case of error
{
ViewBag.ShowAlert = 1;
ViewBag.AlertMessage = "Error when adding part number. Details: " + result[0].Error;
}
}
}
catch (Exception ex)
{
//In case of error
ViewBag.ShowAlert = 1;
ViewBag.AlertMessage = "Error when adding part number. Details: " + ex.Message;
}
return(View());
}
public async Task <IHttpActionResult> PutPartNumbers(int id, PartNumbers partNumbers)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != partNumbers.Id)
{
return(BadRequest());
}
db.Entry(partNumbers).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PartNumbersExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
// GET: PartNumbers/Create
public ActionResult Create()
{
PartNumbers PartNList = new PartNumbers();
using (MaterialsEntities MELS = new MaterialsEntities())
{
PartNList.CustomersCol = MELS.Customers.ToList <Customers>();
}
return(View(PartNList));
}
public async Task <IHttpActionResult> GetPartNumbers(int id)
{
PartNumbers partNumbers = await db.PartNumbers.FindAsync(id);
if (partNumbers == null)
{
return(NotFound());
}
return(Ok(partNumbers));
}
public async Task <IHttpActionResult> PostPartNumbers(PartNumbers partNumbers)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.PartNumbers.Add(partNumbers);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = partNumbers.Id }, partNumbers));
}
public async Task <IHttpActionResult> DeletePartNumbers(int id)
{
PartNumbers partNumbers = await db.PartNumbers.FindAsync(id);
if (partNumbers == null)
{
return(NotFound());
}
db.PartNumbers.Remove(partNumbers);
await db.SaveChangesAsync();
return(Ok(partNumbers));
}
public ActionResult Create(PartNumbers DataPartNumbers)
{
try
{
using (MaterialsEntities MEDB = new MaterialsEntities())
{
MEDB.InsertPartNumber(DataPartNumbers.PartNumber, DataPartNumbers.FKCustomer,
DataPartNumbers.Available);
MEDB.SaveChanges();
}
return(RedirectToAction("/Home/Index"));
}
catch
{
return(View());
}
}
//MasterListView SelectionChanged
private void MasterListView_OnSelectionChanged(object sender, SelectionChangedEventArgs e)
{
var clickedItem = (PartNumbers)MasterListView.SelectedItem;
_lastSelectedItem = clickedItem;
EnableContentTransitions();
if (MasterListView.SelectedItem != null)
{
EditButton.IsEnabled = true;
DeleteButton.IsEnabled = true;
DetailContentPresenter.Visibility = Visibility.Visible;
EmptyItemsBorder2.Visibility = Visibility.Collapsed;
}
else
{
EditButton.IsEnabled = false;
DeleteButton.IsEnabled = false;
DetailContentPresenter.Visibility = Visibility.Collapsed;
EmptyItemsBorder2.Visibility = Visibility.Visible;
}
}
public App()
{
InitializeComponent();
SplashFactory = e => new Splash(e);
#region App settings
var _settings = SettingsService.Instance;
RequestedTheme = _settings.AppTheme;
CacheMaxDuration = _settings.CacheMaxDuration;
ShowShellBackButton = _settings.UseShellBackButton;
#endregion
#region Migrate DataBase
using (var db = new ProjectContext())
{
db.Database.Migrate();
}
#endregion
#region Inicializar
using (var db = new ProjectContext())
{
var query = db.Servicios.Count();
var query1 = db.Proyectos.Count();
if (query <= 0 && query1 <= 0)
{
db.Servicios.Add(new Servicios {
Descripcion = "Telefonía"
});
db.Servicios.Add(new Servicios {
Descripcion = "Internet"
});
db.Servicios.Add(new Servicios {
Descripcion = "Datos"
});
db.Servicios.Add(new Servicios {
Descripcion = "Telefonía e Internet"
});
db.Servicios.Add(new Servicios {
Descripcion = "Telefonia, Internet y Datos"
});
db.Servicios.Add(new Servicios {
Descripcion = "Telefonía y Datos"
});
db.Servicios.Add(new Servicios {
Descripcion = "Datos e Internet"
});
db.Proyectos.Add(new Proyectos {
Descripcion = "Fitel I"
});
db.Proyectos.Add(new Proyectos {
Descripcion = "Filte II"
});
db.Proyectos.Add(new Proyectos {
Descripcion = "Filtel III"
});
db.Proyectos.Add(new Proyectos {
Descripcion = "Filtel IV"
});
db.Proyectos.Add(new Proyectos {
Descripcion = "Filtel VIII"
});
db.Proyectos.Add(new Proyectos {
Descripcion = "Privados"
});
db.Proyectos.Add(new Proyectos {
Descripcion = "Banco de la Nación"
});
db.Proyectos.Add(new Proyectos {
Descripcion = "Cherry Picking"
});
db.Proyectos.Add(new Proyectos {
Descripcion = "Otros"
});
db.SaveChanges();
}
if (!db.Tecnicos.Any())
{
var tecnicos = new Tecnicos
{
Id = 1,
Nombre = "Gustavo",
Apellido = "Gavancho León",
Apocope = "G",
Dni = "73215945",
Direccion = "Psje. Limatambo 121",
Email = "*****@*****.**",
Telefono = 993704915,
FechaNacimiento = DateTime.Now,
};
db.Add(tecnicos);
db.SaveChangesAsync();
}
if (!db.Almacenes.Any())
{
var almacen = new Almacenes
{
Id = 1,
Descripcion = "General",
Apocope = "G",
};
db.Add(almacen);
db.SaveChangesAsync();
}
if (!db.Locaciones.Any())
{
var locacion1 = new Locaciones
{
Id = 1,
Descripcion = "Malogrados",
Apocope = "M",
};
var locacion2 = new Locaciones
{
Id = 2,
Descripcion = "Robados",
Apocope = "M",
};
var locacion3 = new Locaciones
{
Id = 3,
Descripcion = "Normal",
Apocope = "N",
};
db.AddRange(locacion1, locacion2, locacion3);
db.SaveChangesAsync();
}
if (!db.PartNumbers.Any())
{
var partnumber = new PartNumbers
{
Id = 1,
Categoria = Categoria.Equipos,
PartNumber = "541210-v",
Descripcion = "VSAT DUAL BAND",
};
db.Add(partnumber);
db.SaveChangesAsync();
}
if (!db.Localidades.Any())
{
var localidad = new Localidades
{
Id = 1,
Localidad = "Nueva Union",
Distrito = "La Banda de Shilcayo",
Provincia = "San Martin",
Departamento = "San Martin",
Vsatid = 541310,
Telefonos = "9784984516",
Serviciosid = 1,
Proyectoid = 1,
Latitud = 45.87984984948,
Longitud = 45.98498984949,
Costo = 1100.77,
};
db.Add(localidad);
db.SaveChangesAsync();
}
}
#endregion
}
private async void SaveButton_OnClick(object sender, RoutedEventArgs e)
{
using (var db = new ProjectContext())
{
//Save
if (flag == 0)
{
var partNumber = new PartNumbers
{
Categoria = (Categoria)CategoriaComboBox.SelectedItem,
PartNumber = PartNumberTextBox.Text,
Descripcion = DescripcionTextBox.Text
};
db.PartNumbers.Add(partNumber);
await db.SaveChangesAsync();
cvs.Source = await
db.PartNumbers
.GroupBy(x => x.Categoria)
.ToListAsync();
InputModalDialog.IsModal = false;
MasterListView.SelectedItem = partNumber;
MasterListView.ScrollIntoView(partNumber);
}
//Edit
else if (flag == 1)
{
var itemSelected = (PartNumbers)MasterListView.SelectedItem;
if (MasterListView.SelectedItem != null)
{
itemSelected.Categoria = (Categoria)CategoriaComboBox.SelectedItem;
itemSelected.PartNumber = PartNumberTextBox.Text;
itemSelected.Descripcion = DescripcionTextBox.Text;
db.PartNumbers.Update(itemSelected);
await db.SaveChangesAsync();
cvs.Source = await
db.PartNumbers
.GroupBy(x => x.Categoria)
.ToListAsync();
InputModalDialog.IsModal = false;
MasterListView.SelectedItem = itemSelected;
MasterListView.ScrollIntoView(itemSelected);
}
}
var query1 = db.PartNumbers.Count();
if (query1 <= 0)
{
EmptyItemsBorder.Visibility = Visibility.Visible;
}
else
{
EmptyItemsBorder.Visibility = Visibility.Collapsed;
}
}
//Enable
MasterListView.IsEnabled = true;
ListViewCommandBar.IsEnabled = true;
SearchAutoSuggestBox.IsEnabled = true;
}
/// <summary>
/// Clones this instance.
/// </summary>
/// <returns></returns>
public virtual ProductModel Clone(bool createVersion = true, string modelName = "", string idMask = "", string description = "")
{
// clone item (without child collections), increase version
var clonedModel = (ProductModel)this.MemberwiseClone();
clonedModel.Id = Guid.NewGuid();
clonedModel.IsReleased = false;
clonedModel.IsArchived = false;
if (createVersion)
{
// create a new version
clonedModel.Version = Version + 1;
}
else
{
if (string.IsNullOrEmpty(modelName) || string.IsNullOrEmpty(idMask) || string.IsNullOrEmpty(description))
{
throw new ArgumentNullException("Pass a valid name, id mask and description if a model needs to be cloned.");
}
// or create a new model with new name, 0 version and new base model id
clonedModel.Name = modelName;
clonedModel.Version = 0;
clonedModel.BaseModelId = Guid.NewGuid();
clonedModel.IdMask = IdMask;
clonedModel.Comment = description;
}
clonedModel.NHVersion = 0;
// clone each child element and assign cloned item as parent
var productComponentList = new List <ProductComponent>();
ProductComponent placeHolder;
ProductComponents.ToList().ForEach(x =>
{
placeHolder = x.Clone();
placeHolder.ProductModel = clonedModel;
productComponentList.Add(placeHolder);
});
// clone product model configurations
var productModelConfigurations = new List <ProductModelConfiguration>();
ProductModelConfiguration configPlaceholder;
ProductModelConfigurations.ToList().ForEach(x =>
{
configPlaceholder = new ProductModelConfiguration();
configPlaceholder.Id = Guid.NewGuid();
configPlaceholder.Name = x.Name;
configPlaceholder.ConfigIndex = x.ConfigIndex;
configPlaceholder.Color = x.Color;
productModelConfigurations.Add(configPlaceholder);
});
// assign collection to ProductModelConfigurations property
clonedModel.ProductModelConfigurations = productModelConfigurations;
// clone product part numbers
var productModelPartNrs = new List <PartNumber>();
PartNumber placeholder;
PartNumbers.ToList().ForEach(x =>
{
placeholder = new PartNumber();
placeholder.Id = Guid.NewGuid();
placeholder.Number = x.Number;
placeholder.ProductModel = clonedModel;
productModelPartNrs.Add(placeholder);
});
//assign part numbers to part nrs property
clonedModel.PartNumbers = productModelPartNrs;
// create a new list object or a "Shared collection" exception will be thrown
clonedModel.Tooling = new List <AssemblyTool>();
((List <AssemblyTool>)clonedModel.Tooling).AddRange(Tooling);
// assign clone child collection to cloned model
clonedModel.ProductComponents = productComponentList;
return(clonedModel);
}
