public static List <KartelaProduct> Edit(int Id)
{
using (var db = new MTSEntities())
{
var model = (from x in db.KartelaProduct where x.Id == Id select x).ToList();
return(model);
}
}
public static List <Kartela> List()
{
using (var db = new MTSEntities())
{
var kartela = (from x in db.Kartela select x).ToList();
return(kartela);
}
}
public static List <Kartela> Edit(int Id)
{
using (var db = new MTSEntities())
{
var kartela = (from x in db.Kartela where x.Id == Id select x).ToList();
return(kartela);
}
}
public static List <KartelaProduct> KartelaForProduct(int KartelaId)
{
using (var db = new MTSEntities())
{
var kartelaForProduct = (from x in db.KartelaProduct where x.KartelaId == KartelaId select x).ToList();
return(kartelaForProduct);
}
}
public static List <Product> List()
{
using (var db = new MTSEntities())
{
var Produtcs = (from x in db.Product select x).ToList();
return(Produtcs);
}
}
public static List <Product> Edit(int Id)
{
using (var db = new MTSEntities())
{
var Products = (from x in db.Product where x.Id == Id select x).ToList();
return(Products);
}
}
public static List <User> GetUser()
{
using (var db = new MTSEntities())
{
var users = (from x in db.User select x).ToList();
return(users);
}
}
public static List <tblModel> Edit(int Id)
{
using (var db = new MTSEntities())
{
var model = (from x in db.tblModel where x.Id == Id select x).ToList();
return(model);
}
}
public static List <tblModel> ProductForModel(int ProductId)
{
using (var db = new MTSEntities())
{
var productForModel = (from x in db.tblModel where x.ProductId == ProductId select x).ToList();
return(productForModel);
}
}
public static List <User> Edit(int Id)
{
using (var db = new MTSEntities())
{
var users = (from x in db.User where x.Id == Id select x).ToList();
return(users);
}
}
public static List <Customer> List()
{
using (var db = new MTSEntities())
{
var customers = (from x in db.Customer select x).ToList();
return(customers);
}
}
public static int Add(Order order)
{
try
{
using (var db = new MTSEntities())
{
var item = new Order
{
Cila = order.Cila,
CustomerId = order.CustomerId,
Description = order.Description,
FinishDate = order.FinishDate,
KaporaPrice = order.KaporaPrice,
KartelaId = order.KartelaId,
KartelaModelId = order.KartelaModelId,
ModelId = order.ModelId,
ProductId = order.ProductId,
StartDate = order.StartDate,
TotalPrice = order.TotalPrice,
ProductId2 = order.ProductId2,
ModelId2 = order.ModelId2,
KartelaId2 = order.KartelaId2,
KartelaModelId2 = order.KartelaModelId2,
Cila2 = order.Cila2,
Description2 = order.Description2,
ProductId3 = order.ProductId3,
ModelId3 = order.ModelId3,
KartelaId3 = order.KartelaId3,
KartelaModelId3 = order.KartelaModelId3,
Cila3 = order.Cila3,
Description3 = order.Description3,
ProductId4 = order.ProductId4,
ModelId4 = order.ModelId4,
KartelaId4 = order.KartelaId4,
KartelaModelId4 = order.KartelaModelId4,
Cila4 = order.Cila4,
Description4 = order.Description4,
KaporaType = order.KaporaType,
PaymentType = order.PaymentType,
};
db.Order.Add(item);
db.SaveChanges();
return(1);
}
}
catch (Exception ex)
{
return(0);
}
}
public static List <User> GetUserLogin(User user)
{
using (var db = new MTSEntities())
{
var getuser = (from x in db.User
where x.Email == user.Email && x.Password == user.Password
select x).ToList();
return(getuser);
}
}
public static int Update(Order order)
{
try
{
using (var db = new MTSEntities())
{
Order temp = db.Order.SingleOrDefault(x => x.Id == order.Id);
temp.FinishDate = order.FinishDate;
temp.StartDate = order.StartDate;
temp.ProductId = order.ProductId;
temp.ProductId2 = order.ProductId2;
temp.ProductId3 = order.ProductId3;
temp.ProductId4 = order.ProductId4;
temp.ModelId = order.ModelId;
temp.ModelId2 = order.ModelId2;
temp.ModelId3 = order.ModelId3;
temp.ModelId4 = order.ModelId4;
temp.KartelaModelId = order.KartelaModelId;
temp.KartelaModelId2 = order.KartelaModelId2;
temp.KartelaModelId3 = order.KartelaModelId3;
temp.KartelaModelId4 = order.KartelaModelId4;
temp.KartelaId = order.KartelaId;
temp.KartelaId2 = order.KartelaId2;
temp.KartelaId3 = order.KartelaId3;
temp.KartelaId4 = order.KartelaId4;
temp.Description = order.Description;
temp.Description2 = order.Description2;
temp.Description3 = order.Description3;
temp.Description4 = order.Description4;
temp.CustomerId = order.CustomerId;
temp.Cila = order.Cila;
temp.Cila2 = order.Cila2;
temp.Cila3 = order.Cila3;
temp.Cila4 = order.Cila4;
temp.TotalPrice = order.TotalPrice;
db.SaveChanges();
return(1);
}
}
catch (Exception ex)
{
return(0);
}
}
public static List <OrderCustomerProduct> Edit(int Id)
{
using (var db = new MTSEntities())
{
var getOrder = (from order in db.Order
join customer in db.Customer on order.CustomerId equals customer.Id
where order.Id == Id
select new OrderCustomerProduct
{
Id = order.Id,
CustomerId = customer.Id,
StartDate = order.StartDate.ToString(),
FinishDate = order.FinishDate.ToString(),
ProductId = order.ProductId,
ModelId = order.ModelId,
KartelaId = order.KartelaId,
KartelaModelId = order.KartelaModelId,
Cila = order.Cila,
Description = order.Description,
ProductId2 = order.ProductId2,
ModelId2 = order.ModelId2,
KartelaId2 = order.KartelaId2,
KartelaModelId2 = order.KartelaModelId2,
Cila2 = order.Cila2,
Description2 = order.Description2,
ProductId3 = order.ProductId3,
ModelId3 = order.ModelId3,
KartelaId3 = order.KartelaId3,
KartelaModelId3 = order.KartelaModelId3,
Cila3 = order.Cila3,
Description3 = order.Description3,
ProductId4 = order.ProductId4,
ModelId4 = order.ModelId4,
KartelaId4 = order.KartelaId4,
KartelaModelId4 = order.KartelaModelId4,
Cila4 = order.Cila4,
Description4 = order.Description4,
KaporaType = order.KaporaType,
PaymentType = order.PaymentType,
TotalPrice = order.TotalPrice
}
).ToList();
return(getOrder);
}
}
public static int Update(Product product)
{
try
{
using (var db = new MTSEntities())
{
Product temp = db.Product.SingleOrDefault(x => x.Id == product.Id);
temp.ProductName = product.ProductName;
db.SaveChanges();
return(1);
}
}
catch (Exception ex)
{
return(0);
}
}
public static List <ModelProduct> List()
{
using (var db = new MTSEntities())
{
var models = (from x in db.tblModel
join p in db.Product on x.ProductId equals p.Id
select new ModelProduct
{
ProductName = p.ProductName,
Id = x.Id,
ProductId = p.Id,
ModelName = x.ModelName
}
).ToList();
return(models);
}
}
public static int Update(Kartela kartela)
{
try
{
using (var db = new MTSEntities())
{
var item = db.Kartela.SingleOrDefault(x => x.Id == kartela.Id);
item.KartelaName = kartela.KartelaName;
db.SaveChanges();
return(1);
}
}
catch (Exception ex)
{
return(0);
}
}
public static List <CatalogProduct> List()
{
using (var db = new MTSEntities())
{
var kp = (from x in db.KartelaProduct
join k in db.Kartela on x.KartelaId equals k.Id
select new CatalogProduct
{
ProductName = x.ProductName,
Id = x.Id,
KartelaId = k.Id,
KartelaName = k.KartelaName,
ProductCode = x.ProductName
}).ToList();
return(kp);
}
}
public static int Update(tblModel model)
{
try
{
using (var db = new MTSEntities())
{
tblModel temp = db.tblModel.SingleOrDefault(x => x.Id == model.Id);
temp.ModelName = model.ModelName;
temp.ProductId = model.ProductId;
db.SaveChanges();
return(1);
}
}
catch (Exception ex)
{
return(0);
}
}
public static int Update(KartelaProduct kp)
{
try
{
using (var db = new MTSEntities())
{
KartelaProduct temp = db.KartelaProduct.SingleOrDefault(x => x.Id == kp.Id);
temp.KartelaId = kp.KartelaId;
temp.ProductName = kp.ProductName;
temp.ProductCode = kp.ProductCode;
db.SaveChanges();
return(1);
}
}
catch (Exception ex)
{
return(0);
}
}
public static int Update(User user)
{
try
{
using (var db = new MTSEntities())
{
User temp = db.User.SingleOrDefault(x => x.Id == user.Id);
temp.NameSurname = user.NameSurname;
temp.Password = user.Password;
temp.Email = user.Email;
db.SaveChanges();
return(1);
}
}
catch (Exception ex)
{
return(0);
}
}
public static int Add(Kartela kartela)
{
try
{
using (var db = new MTSEntities())
{
var item = new Kartela
{
KartelaName = kartela.KartelaName
};
db.Kartela.Add(item);
db.SaveChanges();
return(1);
}
}
catch (Exception ex)
{
return(0);
}
}
public static int Add(Product product)
{
try
{
using (var db = new MTSEntities())
{
var temp = new Product
{
ProductName = product.ProductName
};
db.Product.Add(temp);
db.SaveChanges();
return(1);
}
}
catch (Exception ex)
{
return(0);
}
}
public static int Add(tblModel model)
{
try
{
using (var db = new MTSEntities())
{
var temp = new tblModel
{
ProductId = model.ProductId,
ModelName = model.ModelName
};
db.tblModel.Add(temp);
db.SaveChanges();
return(1);
}
}
catch (Exception ex)
{
return(0);
}
}
public static List <OrderCustomerProduct> FirstLoginPageOrderList()
{
using (var db = new MTSEntities())
{
var orderList = (from order in db.Order
join customer in db.Customer on order.CustomerId equals customer.Id
select new OrderCustomerProduct
{
Id = order.Id,
CustomerId = customer.Id,
NameSurname = customer.NameSurname,
Phone1 = customer.Phone1,
TotalPrice = order.TotalPrice,
FinishDate = order.FinishDate.ToString(),
StartDate = order.StartDate.ToString(),
KaporaPrice = order.KaporaPrice
}
).ToList();
return(orderList);
}
}
public static int Add(User user)
{
try
{
using (var db = new MTSEntities())
{
var temp = new User
{
Email = user.Email,
NameSurname = user.NameSurname,
Password = user.Password
};
db.User.Add(temp);
db.SaveChanges();
return(1);
}
}
catch (Exception ex)
{
return(0);
}
}
public static int Add(KartelaProduct kp)
{
try
{
using (var db = new MTSEntities())
{
var item = new KartelaProduct
{
KartelaId = kp.KartelaId,
ProductName = kp.ProductName,
ProductCode = kp.ProductCode
};
db.KartelaProduct.Add(item);
db.SaveChanges();
return(1);
}
}
catch (Exception ex)
{
return(0);
}
}
public static int Delete(int Id)
{
try
{
using (var db = new MTSEntities())
{
var item = db.Kartela.SingleOrDefault(x => x.Id == Id);
if (item != null)
{
db.Kartela.Remove(item);
db.SaveChanges();
return(1);
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
return(0);
}
}
public static int Delete(int Id)
{
try
{
using (var db = new MTSEntities())
{
var tempRemove = db.tblModel.SingleOrDefault(x => x.Id == Id);
if (tempRemove != null)
{
db.tblModel.Remove(tempRemove);
db.SaveChanges();
return(1);
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
return(0);
}
}
