private void btnSave_Click(object sender, EventArgs e)
{
try
{
eTelephone tele = new eTelephone();
tele.TeleID = int.Parse(txtID.Text);
tele.Name = txtName.Text;
tele.Price = double.Parse(txtPrice.Text);
tele.Provider = txtProvider.Text;
tele.State = txtState.Text;
tele.ImpdetailID = int.Parse(txtIPID.Text);
int kq = qldtdd.updatePhone(tele);
if (kq == 1)
{
MessageBox.Show("Edit Success !");
btnEdit.Text = "Edit";
txtEnableFalse();
this.dgvTele.Enabled = true;
}
else
{
MessageBox.Show("Key Exist");
}
LoadDataGriwView();
}
catch (Exception ex)
{
Console.Write(ex);
throw;
}
}
public List <eTelephone> SearchTelephone(string input) //Tim kiem dien thoai
{
var listTele = db.Telephones.Where(delegate(Telephone c)
{
if (ConvertToUnSign(c.teleID + c.name + c.impdetaiID + c.price + c.provider + c.state).IndexOf(input, StringComparison.CurrentCultureIgnoreCase) >= 0)
{
return(true);
}
else
{
return(false);
}
}).AsQueryable();
List <eTelephone> lt = new List <eTelephone>();
foreach (Telephone t in listTele)
{
eTelephone te = new eTelephone();
te.TeleID = t.teleID;
te.Name = t.name;
te.ImpdetailID = (int)t.impdetaiID;
te.Price = double.Parse(t.price.ToString());
te.Provider = t.provider;
te.State = t.state;
lt.Add(te);
}
return(lt);
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (cbxTeleName.Text == "")// rỗng
{
MessageBox.Show("Vui lòng điện thoại ");
cbxTeleName.Focus();
}
else
{
btnThanhToan.Enabled = true;
eTelephone x = qldtdd.GetETelephoneByName(txtID.Text.Trim());
dgvImpDetail.Rows.Add(txtID.Text, txtPrice.Text, txtPrice.Text);
cbxTeleName.SelectedIndex = -1;
txtID.Text = "";
txtPrice.Text = "";
txtProvider.Text = "";
txtStatePhone.Text = "";
txtIPID.Text = "";
if (dgvImpDetail.RowCount >= 11)
{
btnAdd.Text = "Tối đa 10 điện thoại";
btnAdd.Enabled = false;
}
}
}
catch (Exception a)
{
MessageBox.Show("Loi" + a);
}
}
private void cbxTeleName_SelectedIndexChanged(object sender, EventArgs e)
{
eTelephone tele = new eTelephone();
tele = qldtdd.GetETelephoneByName(cbxTeleName.Text);
if (tele != null)
{
txtID.Text = tele.TeleID.ToString();
txtPrice.Text = tele.Price.ToString();
txtProvider.Text = tele.Provider;
txtStatePhone.Text = tele.State;
txtIPID.Text = tele.ImpdetailID.ToString();
}
}
public int updatePhone(eTelephone teleold) // Chinh sua thong tin nhan vien
{
if (!CheckIfExistTele(teleold.TeleID))
{
return(0);
}
IQueryable <Telephone> tele = db.Telephones.Where(x => x.teleID == teleold.TeleID);
tele.First().name = teleold.Name;
tele.First().price = (decimal)teleold.Price;
tele.First().impdetaiID = teleold.ImpdetailID;
tele.First().provider = teleold.Provider;
tele.First().state = teleold.State;
db.SubmitChanges();
return(1);
}
//Telephone
#region
public List <eTelephone> GetAllTelephone() // lay danh sach dt
{
var listTele = db.Telephones.ToList();
List <eTelephone> lt = new List <eTelephone>();
foreach (Telephone t in listTele)
{
eTelephone te = new eTelephone();
te.TeleID = t.teleID;
te.Name = t.name;
te.ImpdetailID = (int)t.impdetaiID;
te.Price = double.Parse(t.price.ToString());
te.Provider = t.provider;
te.State = t.state;
lt.Add(te);
}
return(lt);
}
public int insertPhone(eTelephone tele) // them dien thoai moi
{
if (CheckIfExistTele(tele.TeleID))
{
return(0);
}
Telephone t = new Telephone();
t.teleID = tele.TeleID;
t.name = tele.Name;
t.impdetaiID = tele.ImpdetailID;
t.price = decimal.Parse(tele.Price.ToString());
t.provider = tele.Provider;
t.state = tele.State;
db.Telephones.InsertOnSubmit(t);
db.SubmitChanges();
return(1);
}
public eTelephone GetETelephoneByName(string name)
{
Telephone tele = db.Telephones.Where(s => s.name == name).FirstOrDefault();
if (tele != null)
{
eTelephone t = new eTelephone();
t.TeleID = tele.teleID;
t.Name = tele.name;
t.Price = (double)tele.price;
t.Provider = tele.provider;
t.State = tele.state;
t.ImpdetailID = (int)tele.impdetaiID;
return(t);
}
else
{
return(null);
}
}
public int updatePhone(eTelephone tele)
{
return(teleDAL.EditTelephone(tele));
}
public int insertPhone(eTelephone tele)
{
return(teleDAL.insertTelephone(tele));
}
