private void SearchParcas()
{
var parcalar = parcaislem.getSpesificParcaAll(txtSearch.Text);
GridViewParcaAll.DataSource = parcalar;
GridViewParcaAll.DataBind();
}
protected void GridViewParcaAll_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridViewParcaAll.PageIndex = e.NewPageIndex;
GridViewParcaAll.DataSource = parcaislem.getParcaBilgiAll();
GridViewParcaAll.DataBind();
}
protected void GridViewKullanici_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridViewParcaAll.EditIndex = -1;
GridViewParcaAll.DataSource = parcaislem.getParcaBilgiAll();
GridViewParcaAll.DataBind();
//Label11.Text = "";
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GridViewParcaAll.DataSource = parcaislem.getParcaBilgiAll();
GridViewParcaAll.DataBind();
}
}
protected void GridViewKullanici_RowEditing(object sender, GridViewEditEventArgs e)
{
GridViewParcaAll.EditIndex = e.NewEditIndex;
GridViewParcaAll.DataSource = parcaislem.getParcaBilgiAll();
GridViewParcaAll.DataBind();
//Label11.Text = "";
GridViewParcaAll.EditRowStyle.BackColor = System.Drawing.Color.Orange;
}
protected void GridViewKullanici_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
Label parcaID = GridViewParcaAll.Rows[e.RowIndex].FindControl("Label1") as Label;
TextBox parcaKodu = GridViewParcaAll.Rows[e.RowIndex].FindControl("TextBox2") as TextBox;
TextBox parcaAdi = GridViewParcaAll.Rows[e.RowIndex].FindControl("TextBox4") as TextBox;
TextBox fiyatAlis = GridViewParcaAll.Rows[e.RowIndex].FindControl("TextBox6") as TextBox;
TextBox fiyatSatis = GridViewParcaAll.Rows[e.RowIndex].FindControl("TextBox8") as TextBox;
TextBox stok = GridViewParcaAll.Rows[e.RowIndex].FindControl("TextBox10") as TextBox;
int s1 = Convert.ToInt32(parcaID.Text);
string s2 = Convert.ToString(parcaKodu.Text);
string s3 = Convert.ToString(parcaAdi.Text);
decimal s4 = Convert.ToDecimal(fiyatAlis.Text);
decimal s5 = Convert.ToDecimal(fiyatSatis.Text);
int s6 = Convert.ToInt32(stok.Text);
otoservisdbEntities db = new otoservisdbEntities();
List <string> ifparcaexists = db.parcas.ToList()
.Where(x => x.parcaKodu == parcaKodu.Text)
.Select(x => x.parcaKodu).ToList();
if (ifparcaexists.Count == 0)
{
if (s1 != 0 || s2 != "" || s3 != "" || s4 != 0 || s5 != 0)
{
parcaislem.guncelleParca(s1, s2, s3, s4, s5, s6);
//Label11.Text = "Satır bilgisi başarıyla güncellendi";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentSuccess('Satır bilgisi başarıyla güncellendi', 'İşlem Başarılı');", true);
GridViewParcaAll.EditIndex = -1;
GridViewParcaAll.DataSource = parcaislem.getParcaBilgiAll();
GridViewParcaAll.DataBind();
}
else
{
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Eksik girişler mevcut')", true);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentWarning('Eksik girişler mevcut', 'HATA');", true);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentError('Parça Kodu listede mevcut', '');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Güncelleme Başarısız')", true);
}
}
protected void LinkButtonEkle_Click(object sender, EventArgs e)
{
try
{
otoservisdbEntities db = new otoservisdbEntities();
TextBox parcaID = GridViewParcaAll.FooterRow.FindControl("TextBox1") as TextBox;
TextBox parcaKodu = GridViewParcaAll.FooterRow.FindControl("TextBox3") as TextBox;
TextBox parcaAdi = GridViewParcaAll.FooterRow.FindControl("TextBox5") as TextBox;
TextBox fiyatAlis = GridViewParcaAll.FooterRow.FindControl("TextBox7") as TextBox;
TextBox fiyatSatis = GridViewParcaAll.FooterRow.FindControl("TextBox9") as TextBox;
TextBox stok = GridViewParcaAll.FooterRow.FindControl("TextBox11") as TextBox;
List <string> ifparcaexists = db.parcas.ToList()
.Where(x => x.parcaKodu == parcaKodu.Text)
.Select(x => x.parcaKodu).ToList();
if (ifparcaexists.Count == 0)
{
if (parcaKodu.Text == "" || parcaAdi.Text == "" || fiyatAlis.Text == "" || fiyatSatis.Text == "" || stok.Text == "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentWarning('Eksik girişler mevcut', 'HATALI GİRİŞ');", true);
}
else
{
string s1 = Convert.ToString(parcaID.Text);
string s2 = Convert.ToString(parcaKodu.Text);
string s3 = Convert.ToString(parcaAdi.Text);
decimal s4 = Convert.ToDecimal(fiyatAlis.Text);
decimal s5 = Convert.ToDecimal(fiyatSatis.Text);
int s6 = Convert.ToInt32(stok.Text);
// kullaniciAdi, parola, tckn, adSoyad, iseGirisTarihi, Convert.ToInt32(bolumID), Convert.ToInt32(pozisyonID), telno
if (s1 != "" || s2 != "" || s3 != "" || s4 != 0 || s5 != 0)
{
parcaislem.AddParca(s2, s3, s4, s5, s6);
GridViewParcaAll.DataSource = parcaislem.getParcaBilgiAll();
GridViewParcaAll.DataBind();
}
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentError('Parça Kodu listede mevcut', '');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Ekleme Başarısız')", true);
}
}
protected void GridViewKullanici_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
Label parcaID = GridViewParcaAll.Rows[e.RowIndex].FindControl("Label2") as Label;
//string mid = musteriID.Text;
int pid = Convert.ToInt32(parcaID.Text);
parcaislem.silParca(pid);
GridViewParcaAll.DataSource = parcaislem.getParcaBilgiAll();
GridViewParcaAll.DataBind();
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Silme başarısız')", true);
}
}
