private void btnKaydet_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtYayineviAdi.Text))
{
List <EPublisher> publisherList = BLLPublisher.GetAll();
publisherList = (from l in publisherList
where l.Name.Trim().ToLower().Equals(txtYayineviAdi.Text.Trim().ToLower())
select l).ToList();
if (publisherList.Count == 0)
{
EPublisher publisher = new EPublisher();
publisher.Name = txtYayineviAdi.Text;
if (BLLPublisher.InsertNewPublisher(new EPublisher(0, txtYayineviAdi.Text)))
{
MessageBox.Show("Yeni yayınevi kayıt işlemi başarıyla tamamlanmıştır!");
txtYayineviAdi.Clear();
listBox1.DataSource = BLLPublisher.GetAll();
txtYayineviAdi.Focus();
}
else
{
MessageBox.Show("Bir hata oluştu!");
}
}
else
{
MessageBox.Show("Kaydetmek istediğiniz yayınevi zaten kayıtlı!");
}
}
else
{
MessageBox.Show("Yayınevi adı boş geçilemez!");
}
}
private void btnSil_Click(object sender, EventArgs e)
{
if (listBox1.SelectedItems.Count > 0)
{
int silinecekPublisherID = (int)listBox1.SelectedValue;
DialogResult result = MessageBox.Show("Silmek istediğinize emin misiniz ?", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (result == DialogResult.Yes)
{
EPublisher publisher = new EPublisher();
publisher.ID = silinecekPublisherID;
if (BLLPublisher.Delete(publisher))
{
MessageBox.Show("Silme işleminiz başarıyla tamamlanmıştır.");
listBox1.DataSource = BLLPublisher.GetAll();
}
else
{
MessageBox.Show("Bir hata oluştu!");
}
}
}
else
{
MessageBox.Show("Lütfen silmek istediğiniz yayınevini seçiniz!");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
if (Request.QueryString["ID"] != null)
{
EPublisher publisher = new EPublisher();
publisher.ID = int.Parse(Request.QueryString["ID"]);
bool sonuc = BLLPublisher.Delete(publisher);
if (sonuc)
{
Response.Write("<script>alert('Harika! Silindi!')</script>");
}
else
{
Response.Write("<script>alert('Hay Aksi! Silinemedi!')</script>");
}
}
rptYayinevleri.DataSource = BLLPublisher.GetAll();
rptYayinevleri.DataBind();
if (Request.QueryString["scs"] != null)
{
int scsID = Convert.ToInt32(Request.QueryString["scs"].ToString());
if (scsID == 1)
{
Response.Write("<script>alert('Harika! Güncellendi!');</script>");
}
}
}
private void GelismisArama_Load(object sender, EventArgs e)
{
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = BLLBooks.GetAll();
cmbYazar.DataSource = BLLAuthors.GetAll();
cmbYazar.DisplayMember = "FullName";
cmbYazar.ValueMember = "ID";
cmbTur.DataSource = BLLCategories.GetAll();
cmbTur.DisplayMember = "Name";
cmbTur.ValueMember = "ID";
cmbRaf.DataSource = BLLShelf.GetAll();
cmbRaf.DisplayMember = "ShelfNo";
cmbRaf.ValueMember = "ID";
cmbYayinevi.DataSource = BLLPublisher.GetAll();
cmbYayinevi.DisplayMember = "Name";
cmbYayinevi.ValueMember = "ID";
cmbRaf.Enabled = false;
cmbTur.Enabled = false;
cmbYayinevi.Enabled = false;
cmbYazar.Enabled = false;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
cmbKitapYazari.DataSource = BLLAuthors.GetAll();
cmbKitapYazari.DataTextField = "FullName";
cmbKitapYazari.DataValueField = "ID";
cmbKitapYazari.DataBind();
cmbTur.DataSource = BLLCategories.GetAll();
cmbTur.DataTextField = "Name";
cmbTur.DataValueField = "ID";
cmbTur.DataBind();
cmbRafNo.DataSource = BLLShelf.GetAll();
cmbRafNo.DataTextField = "ShelfNo";
cmbRafNo.DataValueField = "ID";
cmbRafNo.DataBind();
cmbYayinEvi.DataSource = BLLPublisher.GetAll();
cmbYayinEvi.DataTextField = "Name";
cmbYayinEvi.DataValueField = "ID";
cmbYayinEvi.DataBind();
}
}
protected void btnKaydet_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtYayineviAdi.Text))
{
List <EPublisher> publisherList = BLLPublisher.GetAll();
publisherList = (from l in publisherList
where l.Name.Trim().ToLower().Equals(txtYayineviAdi.Text.Trim().ToLower())
select l).ToList();
if (publisherList.Count == 0)
{
if (BLLPublisher.InsertNewPublisher(new EPublisher(0, txtYayineviAdi.Text)))
{
Response.Write("<script>alert('Yayınevi kayıt işleminiz başarıyla gerçekleşmiştir.')</script>");
}
else
{
Response.Write("<script>alert('Hata Oluştu!')</script>");
}
}
else
{
Response.Write("<script>alert('Kaydetmek istediğiniz yayınevi zaten kayıtlıdır!')</script>");
}
txtYayineviAdi.Text = String.Empty;
txtYayineviAdi.Focus();
}
else
{
Response.Write("<script>alert('Yayınevi adı boş geçilemez!')</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
cmbKitapYazari.DataSource = BLLAuthors.GetAll();
cmbKitapYazari.DataTextField = "FullName";
cmbKitapYazari.DataValueField = "ID";
cmbKitapYazari.DataBind();
cmbTur.DataSource = BLLCategories.GetAll();
cmbTur.DataTextField = "Name";
cmbTur.DataValueField = "ID";
cmbTur.DataBind();
cmbRafNo.DataSource = BLLShelf.GetAll();
cmbRafNo.DataTextField = "ShelfNo";
cmbRafNo.DataValueField = "ID";
cmbRafNo.DataBind();
cmbYayinEvi.DataSource = BLLPublisher.GetAll();
cmbYayinEvi.DataTextField = "Name";
cmbYayinEvi.DataValueField = "ID";
cmbYayinEvi.DataBind();
}
if (chbRaf.Checked == true)
{
panelRaf.Enabled = true;
}
else
{
panelRaf.Enabled = false;
}
if (chbTur.Checked == true)
{
panelTur.Enabled = true;
}
else
{
panelTur.Enabled = false;
}
if (chbYayinevi.Checked == true)
{
panelYayinEvi.Enabled = true;
}
else
{
panelYayinEvi.Enabled = false;
}
if (chbYazar.Checked == true)
{
panelKitapYazari.Enabled = true;
}
else
{
panelKitapYazari.Enabled = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int publisherID = Convert.ToInt32(Request.QueryString["yayineviID"].ToString());
EPublisher publisher = new EPublisher();
publisher = BLLPublisher.GetIdOnly(publisherID);
txtYayineviAdi.Text = publisher.Name;
}
}
public void LoadPublisherType()
{
try
{
Session["PublisherTypeList"] = BLLPublisher.GetPublisherList();
this.LBPublisher.DataSource = (List <ATTPublisher>)Session["PublisherTypeList"];
this.LBPublisher.DataTextField = "PublisherName";
this.LBPublisher.DataValueField = "PublisherID";
this.LBPublisher.DataBind();
}
catch (Exception ex)
{
throw (ex);
}
}
protected void BtnDelete_Click(object sender, EventArgs e)
{
ATTPublisher ObjPT;
if (LBPublisher.SelectedIndex > -1)
{
ObjPT = new ATTPublisher(int.Parse(LBPublisher.SelectedValue));
BLLPublisher.DeletePublisher(ObjPT);
LBPublisher.Items.Remove(LBPublisher.SelectedItem);
btnSave.Text = "Save";
this.txtPublisherName_Rqd.Text = "";
this.txtLookupAddress_Rqd.Text = "";
this.txtPublisherName_Rqd.Focus();
LblStatus.Text = "Deleted..";
}
}
void LoadPublisher()
{
try
{
List <ATTPublisher> l = BLLPublisher.GetPublisherList();
l.Insert(0, new ATTPublisher(0, "--- Select Publisher ---", "", "", ""));
this.ddlPublisher_Rqd.DataSource = l;
this.ddlPublisher_Rqd.DataTextField = "PublisherName";
this.ddlPublisher_Rqd.DataValueField = "PublisherID";
this.ddlPublisher_Rqd.DataBind();
}
catch (Exception ex)
{
throw ex;
}
}
void LoadPublisher()
{
try
{
List <ATTPublisher> l = BLLPublisher.GetPublisherList();
l.Insert(0, new ATTPublisher(0, "--- Select Publisher ---", "", "", ""));
this.ddlPublisherType.DataSource = l;
this.ddlPublisherType.DataTextField = "PublisherName";
this.ddlPublisherType.DataValueField = "PublisherID";
this.ddlPublisherType.DataBind();
}
catch (Exception ex)
{
this.lblStatus.Text = ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
cmbKitapYazari.DataSource = BLLAuthors.GetAll();
cmbKitapYazari.DataTextField = "FullName";
cmbKitapYazari.DataValueField = "ID";
cmbKitapYazari.DataBind();
cmbTur.DataSource = BLLCategories.GetAll();
cmbTur.DataTextField = "Name";
cmbTur.DataValueField = "ID";
cmbTur.DataBind();
cmbRafNo.DataSource = BLLShelf.GetAll();
cmbRafNo.DataTextField = "ShelfNo";
cmbRafNo.DataValueField = "ID";
cmbRafNo.DataBind();
cmbYayinEvi.DataSource = BLLPublisher.GetAll();
cmbYayinEvi.DataTextField = "Name";
cmbYayinEvi.DataValueField = "ID";
cmbYayinEvi.DataBind();
int bookID = Convert.ToInt32(Request.QueryString["bookID"].ToString());
EBooks book = new EBooks();
book.Author = new EAuthors();
book.Shelf = new EShelf();
book.Category = new ECategories();
book.Publisher = new EPublisher();
book = BLLBooks.GetIdOnly(bookID);
txtKitapAdi.Text = book.Name;
txtISBNNo.Text = book.ISBNNO;
cmbRafNo.SelectedValue = book.Shelf.ID.ToString();
cmbKitapYazari.SelectedValue = book.Author.ID.ToString();
cmbTur.SelectedValue = book.Category.ID.ToString();
cmbYayinEvi.SelectedValue = book.Publisher.ID.ToString();
dtpBasimTarihi.Text = book.DateOfPublish.ToString();
}
}
private void Form1_Load(object sender, EventArgs e)
{
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = BLLBooks.GetAll();
cmbKitapYazari.DataSource = BLLAuthors.GetAll();
cmbKitapYazari.DisplayMember = "FullName";
cmbKitapYazari.ValueMember = "ID";
cmbTur.DataSource = BLLCategories.GetAll();
cmbTur.DisplayMember = "Name";
cmbTur.ValueMember = "ID";
cmbRafNo.DataSource = BLLShelf.GetAll();
cmbRafNo.DisplayMember = "ShelfNo";
cmbRafNo.ValueMember = "ID";
cmbYayinEvi.DataSource = BLLPublisher.GetAll();
cmbYayinEvi.DisplayMember = "Name";
cmbYayinEvi.ValueMember = "ID";
}
protected void btnGuncelle_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtYayineviAdi.Text))
{
EPublisher guncellenecek = new EPublisher();
guncellenecek.ID = int.Parse(Request.QueryString["yayineviID"]);
guncellenecek.Name = txtYayineviAdi.Text;
bool sonuc = BLLPublisher.Update(guncellenecek);
if (sonuc)
{
Response.Write("<script>alert('Harika! Güncellendi!');</script>");
Response.Redirect("Yayinevleri.aspx?scs=1");
}
else
{
Response.Write("<script>alert('Hay Aksi! Hata Oluştu!')</script>");
}
}
else
{
Response.Write("<script>alert('Yayınevi adı boş geçilemez!')</script>");
}
}
private void Yayınevleri_Listesi_Load(object sender, EventArgs e)
{
listBox1.DataSource = BLLPublisher.GetAll();
listBox1.DisplayMember = "Name";
listBox1.ValueMember = "ID";
}
protected void btnSave_Click(object sender, EventArgs e)
{
ATTPublisher ObjPT;
if (LBPublisher.SelectedIndex == -1)
{
ObjPT = new ATTPublisher(0, txtPublisherName_Rqd.Text, txtLookupAddress_Rqd.Text, "User_Ashok", DateTime.Now.ToString());
}
else
{
ObjPT = new ATTPublisher(int.Parse(this.LBPublisher.SelectedValue), txtPublisherName_Rqd.Text, txtLookupAddress_Rqd.Text, "User_Ashok", DateTime.Now.ToString());
}
List <ATTPublisher> ltPublisher = (List <ATTPublisher>)Session["PublisherTypeList"];
ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]);
try
{
if (LBPublisher.SelectedIndex == -1)
{
if (user.MenuList["4,8,1"] == null || user.MenuList["4,8,1"].PAdd == "N")
{
this.LblStatus.Text = Utilities.PreviledgeMsg + " add Publisher.";
return;
}
Previlege pobj = new Previlege(user.UserName, "4,8,1", int.Parse(((HiddenField)this.Master.FindControl("hdnApplicationID")).Value), Previlege.PrevilegeType.P_ADD);
if (BLLPublisher.SavePublisher(ObjPT, pobj))
{
ltPublisher.Add(ObjPT);
LblStatus.Text = "Publisher Inserted as: " + txtPublisherName_Rqd.Text + ".";
txtPublisherName_Rqd.Text = "";
txtLookupAddress_Rqd.Text = "";
btnSave.Text = "Save";
txtPublisherName_Rqd.Focus();
}
}
else
{
if (user.MenuList["4,8,1"] == null || user.MenuList["4,8,1"].PEdit == "N")
{
this.LblStatus.Text = Utilities.PreviledgeMsg + " add Publisher.";
return;
}
Previlege pobj = new Previlege(user.UserName, "4,8,1", int.Parse(((HiddenField)this.Master.FindControl("hdnApplicationID")).Value), Previlege.PrevilegeType.P_ADD);
if (BLLPublisher.UpdatePublisherType(ObjPT, pobj))
{
ltPublisher[this.LBPublisher.SelectedIndex] = ObjPT;
LblStatus.Text = "Publisher Record Updated...";
btnSave.Text = "Save";
txtPublisherName_Rqd.Text = "";
txtLookupAddress_Rqd.Text = "";
txtPublisherName_Rqd.Focus();
}
}
LBPublisher.DataSource = ltPublisher;
LBPublisher.DataTextField = "PublisherName";
LBPublisher.DataValueField = "PublisherID";
LBPublisher.DataBind();
}
catch (Exception ex)
{
this.LblStatus.Text = ex.Message;
}
}
