public bool modelInfoUpdate(models modelInfo) { bool sonuc = false; cGenel gnl = new cGenel(); SqlConnection con = new SqlConnection(gnl.conString); SqlCommand cmd = new SqlCommand("update MODELS set MODELKODU=@MODELKODU, MODELADI=@MODELADI where MODELNO=@MODELNO", con); cmd.Parameters.Add("@MODELKODU", SqlDbType.NVarChar).Value = modelInfo._MODELKODU; cmd.Parameters.Add("@MODELADI", SqlDbType.NVarChar).Value = modelInfo._MODELADI; cmd.Parameters.Add("@MODELNO", SqlDbType.NVarChar).Value = modelInfo._MODELNO; try { if (con.State == ConnectionState.Closed) { con.Open(); } sonuc = Convert.ToBoolean(cmd.ExecuteNonQuery()); } catch (Exception ex) { mesajlar.hata(ex, ""); } finally { con.Close(); con.Dispose(); } return(sonuc); }
private void dataGridModels_CellClick(object sender, DataGridViewCellEventArgs e) { models model = new models(); model._MODELNO = dataGridModels.SelectedCells[0].Value.ToString(); txtModelNo.Text = model._MODELNO; txtModelKodu.Text = model.speckInfoSearch(model._MODELNO)._MODELKODU; txtModelAdi.Text = model.speckInfoSearch(model._MODELNO)._MODELADI; }
public void formYukle() { models model = new models(); dataGridModels.AutoGenerateColumns = true; var list = model.modelList(); var lst = (from s in list select new { MODELADI = s._MODELADI, KODU = s._MODELKODU, NO = s._MODELNO }).ToList(); dataGridModels.DataSource = lst; }
private void btnBarkodSearch_Click(object sender, EventArgs e) { models model = new models(); model._MODELNO = txtModelNo.Text.Trim(); if (model.speckInfoSearch(model._MODELNO)._MODELNO != null) { txtModelNo.Text = model.speckInfoSearch(model._MODELNO)._MODELNO; txtModelKodu.Text = model.speckInfoSearch(model._MODELNO)._MODELKODU; txtModelAdi.Text = model.speckInfoSearch(model._MODELNO)._MODELADI; } else { cGenel.genelUyari("Model bulunamadı!", false); } }
private void btnDelete_Click(object sender, EventArgs e) { models model = new models(); model._MODELNO = model.speckInfoSearch(txtModelNo.Text)._MODELNO; bool result = model.modelInfoDelete(model._MODELNO); if (result) { cGenel.genelUyari("Model silme başarılı!", false); formYukle(); } else { cGenel.genelUyari("Model silme başarısız!", false); } }
private void btnUpdate_Click(object sender, EventArgs e) { models model = new models(); model._MODELADI = txtModelAdi.Text; model._MODELKODU = txtModelKodu.Text; model._MODELNO = txtModelNo.Text; bool result = model.modelInfoUpdate(model); if (result) { cGenel.genelUyari("Model güncelleme başarılı!", false); formYukle(); } else { cGenel.genelUyari("Model güncelleme başarısız!", false); } }
public List <models> modelList() { List <models> list = new List <models>(); models info; cGenel gnl = new cGenel(); SqlConnection con = new SqlConnection(gnl.conString); SqlCommand cmd = new SqlCommand("select * from MODELS ", con); SqlDataReader dr = null; try { if (con.State == ConnectionState.Closed) { con.Open(); } dr = cmd.ExecuteReader(); while (dr.Read()) { info = new models(); info._MODELNO = Convert.ToString(dr["MODELNO"]); info._MODELKODU = Convert.ToString(dr["MODELKODU"]); info._MODELADI = Convert.ToString(dr["MODELADI"]); list.Add(info); } } catch (Exception ex) { mesajlar.hata(ex, ""); } finally { con.Close(); con.Dispose(); } return(list); }
public models speckInfoSearch(string modelNo) { models info = new models(); cGenel gnl = new cGenel(); SqlConnection con = new SqlConnection(gnl.conString); SqlCommand cmd = new SqlCommand("select * from MODELS where MODELNO=@MODELNO", con); cmd.Parameters.Add("@MODELNO", SqlDbType.NVarChar).Value = modelNo; SqlDataReader dr = null; try { if (con.State == ConnectionState.Closed) { con.Open(); } dr = cmd.ExecuteReader(); while (dr.Read()) { info._MODELNO = Convert.ToString(dr["MODELNO"]); info._MODELKODU = Convert.ToString(dr["MODELKODU"]); info._MODELADI = Convert.ToString(dr["MODELADI"]); } } catch (Exception ex) { mesajlar.hata(ex, ""); } finally { con.Close(); con.Dispose(); } return(info); }