public bool UpdateItem(int Id, TB_M_Items item)
{
Console.Write("Insert your Id : ");
Id = Convert.ToInt16(Console.ReadLine());
var get = myContext.TB_M_Items.Find(Id);
if (get != null)
{
Console.Write("Insert Your Name :");
string Name = Console.ReadLine();
get.Name = Name;
myContext.Entry(get).State = EntityState.Modified;
var result = (myContext.SaveChanges());
if (result > 0)
{
Console.Write("Update Succes");
status = true;
}
else
{
Console.Write("Update Failed");
}
}
else
{
Console.Write("Data Not Found");
}
return(status);
}
public bool InsertItem(TB_M_Items items)
{
Console.Write("Insert your name : ");
String Name = Console.ReadLine();
Console.Write("Insert Supplier ID :");
int TB_M_Suppliers_Id = Convert.ToInt16(Console.ReadLine());
Console.Write("Insert Price :");
int Price = Convert.ToInt16(Console.ReadLine());
Console.Write("Insert Stock : ");
int Stock = Convert.ToInt16(Console.ReadLine());
items.Name = Name;
items.TB_M_Supplier_Id = TB_M_Suppliers_Id;
items.Price = Price;
items.Stock = Stock;
myContext.TB_M_Items.Add(items);
var result = (myContext.SaveChanges());
if (result > 0)
{
status = true;
Console.Write("Insert Successfully");
}
else
{
Console.Write("Insert Failed");
}
return(status);
}
static void Main(string[] args)
{
//SupplierController suppliercontroller = new SupplierController();
//ISupplier SupplierController = new ControllerSupplier();
//SupplierController.viewAllData();
//Console.Read();
//ControllerSupplier.insertdata();
//Console.Read();
IItem iitem;
TB_M_Items item = new TB_M_Items();
Console.WriteLine("======================");
Console.WriteLine("Action");
Console.WriteLine("======================");
Console.WriteLine("1. View Data");
Console.WriteLine("2. Insert");
Console.WriteLine("3. Delete");
Console.WriteLine("4. Upadate");
Console.WriteLine("======================");
Console.Write("Input Pilihan : ");
//int number = Convert.ToInt32(Console.ReadLine());
//if (number == 1)
//{
// controlleritem.viewAllData();
//}
//else if (number == 2)
//{
// iitem = new ControllerSupplier();
// iitem.InsertItem(TB_M_Items);
//}
//else if (number == 3)
//{
// iitem = new ControllerSupplier();
// iitem.DeleteItem(TB_M_Items);
//}
//else if (number == 4)
//{
// iitem = new ControllerSupplier();
// iitem.UpdateItem(TB_M_Items);
//}
//else
//{
// Console.WriteLine("Not Data Found");
//}
//Console.Read();
}
