public void DeleteCard(int cardID)
{
using (QuanLyPhongNETDataContext objWriter = new QuanLyPhongNETDataContext())
{
var objDelete = objWriter.TheCards.Single(x => x.CardID == cardID);
objWriter.TheCards.DeleteOnSubmit(objDelete);
objWriter.SubmitChanges();
}
}
public void UpdateCategory(string name)
{
using (QuanLyPhongNETDataContext objWriter = new QuanLyPhongNETDataContext())
{
Category objUpdate;
objUpdate = objWriter.Categories.FirstOrDefault(x => x.CategoryName.Equals(name));
objUpdate.CategoryName = name;
objWriter.SubmitChanges();
}
}
public void InsertCatergory(string name)
{
using (QuanLyPhongNETDataContext objWriter = new QuanLyPhongNETDataContext())
{
objWriter.Categories.InsertOnSubmit(new Category
{
CategoryName = name
});
objWriter.SubmitChanges();
}
}
public void UpdateGroupClient(string groupClientName, string description)
{
using (QuanLyPhongNETDataContext objWriter = new QuanLyPhongNETDataContext())
{
GroupClient objUpdate;
objUpdate = objWriter.GroupClients.FirstOrDefault(x => x.GroupName.Equals(groupClientName));
objUpdate.GroupName = groupClientName;
objUpdate.Discription = description;
objWriter.SubmitChanges();
}
}
public void InsertGroupClient(string groupClientName, string description)
{
using (QuanLyPhongNETDataContext objWriter = new QuanLyPhongNETDataContext())
{
objWriter.GroupClients.InsertOnSubmit(new GroupClient
{
GroupName = groupClientName,
Discription = description
});
objWriter.SubmitChanges();
}
}
public void UpdateClient(string name, string groupClientName, string status, string note)
{
using (QuanLyPhongNETDataContext objWriter = new QuanLyPhongNETDataContext())
{
Client objUpdate;
objUpdate = objWriter.Clients.FirstOrDefault(x => x.ClientName.Equals(name));
objUpdate.ClientName = name;
objUpdate.GroupClientName = groupClientName;
objUpdate.StatusClient = status;
objUpdate.Note = note;
objWriter.SubmitChanges();
}
}
public void UpdateDrink(int drinkID, string name, string categoryName, float priceUnit, string unitLot, int inventoryNumber)
{
using (QuanLyPhongNETDataContext objWriter = new QuanLyPhongNETDataContext())
{
Drink objUpdate;
objUpdate = objWriter.Drinks.FirstOrDefault(x => x.DrinkID == drinkID);
objUpdate.DrinkName = name;
objUpdate.CategoryName = categoryName;
objUpdate.PriceUnit = priceUnit;
objUpdate.UnitLot = unitLot;
objUpdate.InventoryNumber = inventoryNumber;
objWriter.SubmitChanges();
}
}
public void InsertClient(string name, string groupClientName, string status, string note)
{
using (QuanLyPhongNETDataContext objWriter = new QuanLyPhongNETDataContext())
{
objWriter.Clients.InsertOnSubmit(new Client
{
ClientName = name,
GroupClientName = groupClientName,
StatusClient = status,
Note = note
});
objWriter.SubmitChanges();
}
}
public void UpdateMember(int memberID, string account, string pass, string groupUser, TimeSpan time, float money, string status)
{
using (QuanLyPhongNETDataContext objWriter = new QuanLyPhongNETDataContext())
{
Member objUpdate;
objUpdate = objWriter.Members.FirstOrDefault(x => x.MemberID == memberID);
objUpdate.AccountName = account;
objUpdate.Password = pass;
objUpdate.GroupUser = groupUser;
objUpdate.CurrentTime = time;
objUpdate.CurrentMoney = money;
objUpdate.StatusAccount = status;
objWriter.SubmitChanges();
}
}
public void InsertDrink(string name, string categoryName, float priceUnit, string unitLot, int inventoryNumber)
{
using (QuanLyPhongNETDataContext objWriter = new QuanLyPhongNETDataContext())
{
objWriter.Drinks.InsertOnSubmit(new Drink
{
DrinkName = name,
CategoryName = categoryName,
PriceUnit = priceUnit,
UnitLot = unitLot,
InventoryNumber = inventoryNumber
});
objWriter.SubmitChanges();
}
}
public void InsertMember(string account, string pass, string groupUser, TimeSpan time, float money, string status)
{
using (QuanLyPhongNETDataContext objWriter = new QuanLyPhongNETDataContext())
{
objWriter.Members.InsertOnSubmit(new Member
{
AccountName = account,
Password = pass,
GroupUser = groupUser,
CurrentTime = time,
CurrentMoney = money,
StatusAccount = status
});
objWriter.SubmitChanges();
}
}
public void UpdateGroupUser(string groupUserName, string typeName)
{
using (QuanLyPhongNETDataContext objWriter = new QuanLyPhongNETDataContext())
{
GroupUser objUpdate;
if ((objUpdate = objWriter.GroupUsers.FirstOrDefault(x => x.GroupName.Equals(groupUserName))) == null)
{
objWriter.GroupUsers.InsertOnSubmit(new GroupUser
{
GroupName = groupUserName,
TypeName = typeName
});
objWriter.SubmitChanges();
}
else
{
objUpdate.GroupName = groupUserName;
objUpdate.TypeName = typeName;
objWriter.SubmitChanges();
}
}
}
public ProcessGroupUser()
{
objReader = new QuanLyPhongNETDataContext();
objWriter = new QuanLyPhongNETDataContext();
}
public ProcessDrink()
{
objReader = new QuanLyPhongNETDataContext();
objWriter = new QuanLyPhongNETDataContext();
}
public ProcessCategory()
{
objReader = new QuanLyPhongNETDataContext();
objWriter = new QuanLyPhongNETDataContext();
}