public static void Aktualisieren(DAL.Passwort passwort)
{
using (var context = new DAL.Context())
{
context.Entry(passwort).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
using (var context = new DAL.Context())
{
var password = context.Passwort
.Include(i => i.Kategorie)
.FirstOrDefault(i => i.PasswortId == passwort.PasswortId);
var category = context.Kategorie
.FirstOrDefault(i => i.KategorieId == passwort.Kategorie.KategorieId);
if (category != null)
{
context.Entry(password.Kategorie).State = EntityState.Modified;
context.Entry(password).State = EntityState.Modified;
password.Kategorie = category;
context.SaveChanges();
}
}
}
public static void Aktualisieren(DAL.Kategorie kategorie)
{
using (var context = new DAL.Context())
{
context.Entry(kategorie).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public static void Aktualisieren(DAL.Passwort passwort)
{
using (var context = new DAL.Context())
{
context.Entry(passwort).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public static void Aktualisieren(DAL.Artikel artikel)
{
using (var context = new DAL.Context())
{
//TODO null Checks?
context.Entry(artikel).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public static void Loeschen(DAL.Passwort passwort)
{
using (var context = new DAL.Context())
{
context.Entry(passwort).State = System.Data.Entity.EntityState.Deleted;
context.Passwort.Remove(passwort);
context.SaveChanges();
}
}
public void OnGet()
{
UserDT = new DataTable();
UserDT.Columns.Add("UserName");
UserDT.Columns.Add("CategoryCount");
if (DAL.Context.AdditionalColumnSet != null)
{
foreach (var col in DAL.Context.AdditionalColumnSet.Where(x => x.StartsWith("BO.User")))
{
string columnname = col.Split(';')[1];
UserDT.Columns.Add(columnname);
}
}
using (var ctx = new DAL.Context())
{
var UserList = ctx.UserSet.Include(x => x.CategorySet).ToList();
foreach (var u in UserList)
{
var row = UserDT.NewRow();
row["UserName"] = u.UserName;
row["CategoryCount"] = u.CategorySet.Count;
if (DAL.Context.AdditionalColumnSet != null)
{
foreach (var col in DAL.Context.AdditionalColumnSet.Where(x => x.StartsWith("BO.User")))
{
string columnname = col.Split(';')[1];
// access shadow properties using ctx.Entry()
row[columnname] = ctx.Entry(u).Property(columnname).CurrentValue;
}
}
this.UserDT.Rows.Add(row);
}
}
}
private void importarProductos(){
string fileLocation = Server.MapPath("~/Content/stock.xls");
string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" +
fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=1\"";
excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
fileLocation + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"";
OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);
string nombreHoja = "materiales$";
string strSQL = "SELECT * FROM [" + nombreHoja + "]";
OleDbDataAdapter da = new OleDbDataAdapter(strSQL, excelConnection);
DataSet ds = new DataSet();
da.Fill(ds);
int i = 0;
RentaMaq.DAL.Context db = new DAL.Context();
string total = "";
while (i<858)
{
string numpart= Convert.ToString(ds.Tables[0].Rows[i].ItemArray[0]);
string desc = Convert.ToString(ds.Tables[0].Rows[i].ItemArray[1]);
string unidad = Convert.ToString(ds.Tables[0].Rows[i].ItemArray[2]);
string precio = Convert.ToString(ds.Tables[0].Rows[i].ItemArray[3]);
double stock_min=0;
if(!Convert.ToString(ds.Tables[0].Rows[i].ItemArray[4]).Equals("")){
stock_min= Convert.ToDouble(Convert.ToString(ds.Tables[0].Rows[i].ItemArray[4]));
}
double stock_act = Convert.ToDouble(Convert.ToString(ds.Tables[0].Rows[i].ItemArray[5]));
try
{
Producto productoBuscar = db.Productos.SingleOrDefault(s => s.numeroDeParte == numpart && s.descripcion==desc);
if (Object.ReferenceEquals(null, productoBuscar))
{
//INGRESAR
productoBuscar = db.Productos.SingleOrDefault(s => s.numeroDeParte == numpart);
if (Object.ReferenceEquals(null, productoBuscar))
{
Producto producto = new Producto();
producto.numeroDeParte = numpart;
producto.descripcion = desc;
producto.unidadDeMedida = unidad;
producto.stockMinimo = stock_min;
producto.stockActual = stock_act;
db.Productos.Add(producto);
db.SaveChanges();
}
else {
productoBuscar.descripcion = desc;
productoBuscar.stockActual = stock_act;
productoBuscar.stockMinimo = stock_min;
db.Entry(productoBuscar).State = EntityState.Modified;
db.SaveChanges();
}
}
else {
//actualizar
productoBuscar.descripcion = desc;
productoBuscar.stockActual = stock_act;
productoBuscar.stockMinimo = stock_min;
db.Entry(productoBuscar).State = EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception e) {
total = total+"/n" +numpart;
}
i++;
}
}
private void importarProductos()
{
string fileLocation = Server.MapPath("~/Content/stock.xls");
string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" +
fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=1\"";
excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
fileLocation + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"";
OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);
string nombreHoja = "materiales$";
string strSQL = "SELECT * FROM [" + nombreHoja + "]";
OleDbDataAdapter da = new OleDbDataAdapter(strSQL, excelConnection);
DataSet ds = new DataSet();
da.Fill(ds);
int i = 0;
RentaMaq.DAL.Context db = new DAL.Context();
string total = "";
while (i < 858)
{
string numpart = Convert.ToString(ds.Tables[0].Rows[i].ItemArray[0]);
string desc = Convert.ToString(ds.Tables[0].Rows[i].ItemArray[1]);
string unidad = Convert.ToString(ds.Tables[0].Rows[i].ItemArray[2]);
string precio = Convert.ToString(ds.Tables[0].Rows[i].ItemArray[3]);
double stock_min = 0;
if (!Convert.ToString(ds.Tables[0].Rows[i].ItemArray[4]).Equals(""))
{
stock_min = Convert.ToDouble(Convert.ToString(ds.Tables[0].Rows[i].ItemArray[4]));
}
double stock_act = Convert.ToDouble(Convert.ToString(ds.Tables[0].Rows[i].ItemArray[5]));
try
{
Producto productoBuscar = db.Productos.SingleOrDefault(s => s.numeroDeParte == numpart && s.descripcion == desc);
if (Object.ReferenceEquals(null, productoBuscar))
{
//INGRESAR
productoBuscar = db.Productos.SingleOrDefault(s => s.numeroDeParte == numpart);
if (Object.ReferenceEquals(null, productoBuscar))
{
Producto producto = new Producto();
producto.numeroDeParte = numpart;
producto.descripcion = desc;
producto.unidadDeMedida = unidad;
producto.stockMinimo = stock_min;
producto.stockActual = stock_act;
db.Productos.Add(producto);
db.SaveChanges();
}
else
{
productoBuscar.descripcion = desc;
productoBuscar.stockActual = stock_act;
productoBuscar.stockMinimo = stock_min;
db.Entry(productoBuscar).State = EntityState.Modified;
db.SaveChanges();
}
}
else
{
//actualizar
productoBuscar.descripcion = desc;
productoBuscar.stockActual = stock_act;
productoBuscar.stockMinimo = stock_min;
db.Entry(productoBuscar).State = EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception e) {
total = total + "/n" + numpart;
}
i++;
}
}
