public void BindCategoryDetail(int categoryCode) { DALCategory obj = new DALCategory(); DataSet ds = obj.Category_GetDetail(categoryCode); txtCategoryName.Text = ds.Tables[0].Rows[0]["CategoryName"].ToString(); }
private void BtnBookUpdate_Click(object sender, EventArgs e) { // Textbox'lardan gelen veriler kontrol ediliyor boş veri varsa uyarı mesajı bırakıyoruz çünkü veritabanında boş verilerin bulunmasını istemiyoruz // EntityBook üzerinde oluşturduğumuz nesnemize gerekli atamaları yaptıktan sonra // Nesnelerimizin kontrolünü yapmak üzere Mantıksal Katmana verilerimizi gönderiyoruz. if (TxtBookName.Text != "" && TxtBookISBN.Text != "" && TxtBookPublisher.Text != "" && TxtBookPage.Text != "" && TxtBookPublishedDate.Text != "" && CmbIsAvailable.SelectedItem.ToString() != "" && cmbBookCat.SelectedItem.ToString() != "" && cmbBookWriter.SelectedItem.ToString() != "") { EntityBook book = new EntityBook(); book.bookID = int.Parse(TxtBookId.Text); book.bookName = TxtBookName.Text; book.bookISBN = TxtBookISBN.Text; book.bookPublisher = TxtBookPublisher.Text; book.bookPage = TxtBookPage.Text; book.bookSummarize = RTxtSummarize.Text; book.bookPublishedDate = TxtBookPublishedDate.Text; book.isBookAvailable = CmbIsAvailable.SelectedItem.ToString(); book.bookCategoryId = DALCategory.CategoryList().FirstOrDefault(n => n.categoryName == cmbBookCat.SelectedItem.ToString()); book.bookWriterId = DALWriter.WriterList().FirstOrDefault(n => n.writerName == cmbBookWriter.SelectedItem.ToString()); LogicBook.LLBookUpdate(book); MessageBox.Show("Kitap Başarılı Bir Şekilde Güncellendi"); TxtBookId.Text = ""; TxtBookName.Text = ""; TxtBookISBN.Text = ""; TxtBookPublisher.Text = ""; TxtBookPage.Text = ""; RTxtSummarize.Text = ""; TxtBookPublishedDate.Text = ""; } else { MessageBox.Show("Alanları Boş Bırakmayınız"); } }
public void BindCategories() { DALCategory obj = new DALCategory(); DataSet ds = obj.Category_GetList(); rptCategories.DataSource = ds.Tables[0]; rptCategories.DataBind(); }
public static CategoryEntity ToBllEntity(this DALCategory category) { return(new CategoryEntity() { Id = category.Id, Name = category.Name }); }
protected void btnSave_Click(object sender, EventArgs e) { Categories c = new Categories(); c.CategoryName = txtCategoryName.Text; DALCategory obj = new DALCategory(); obj.Category_Add(c); }
public static bool LLCategoryUpdate(EntityCategory cat) { if (cat.categoryName != "") { return(DALCategory.CategoryUpdate(cat)); } else { return(false); } }
public static bool LLCategoryDelete(int cat) { if (cat >= 1) { return(DALCategory.CategoryDelete(cat)); } else { return(false); } }
// Logic Layer ana form üzerinden erişilen bir katmandır ve gerekli mantıksal kontrollerin katman olarak geçer // Gerekli kontrolleri başarılı bir şekilde geçen Logic Methodlar Data Access Layerdan uygun methodu çağırarak programın çalışmasına devam edilir public static int LLCategorySave(EntityCategory cat) { if (cat.categoryName != "") { //burada sifreyi sifrele return(DALCategory.CategorySave(cat)); } else { return(-1); } }
protected void btnUpdate_Click(object sender, EventArgs e) { Categories c = new Categories(); c.CategoryCode = Convert.ToInt32(Request.QueryString["c_c_p"]); c.CategoryName = txtCategoryName.Text; DALCategory obj = new DALCategory(); obj.Category_Update(c); Response.Redirect("CategoryList.aspx"); }
private void bookPublishedInfo() { chart5.Titles.Add("Book Publish Info"); chart5.Series["Kitap"].IsValueShownAsLabel = true; //var pd = DALBook.BookList().Where(m => Convert.ToDateTime(m.bookPublishedDate)< localDate); //var bookName = DALBook.BookList().Select(m => m.bookName); foreach (var item in DALCategory.CategoryList()) { int count = DALBook.BookList().Where(m => m.bookCategoryId.categoryId == item.categoryId).Count(); chart5.Series["Kitap"].Points.AddXY(item.categoryName, count); } }
public static DALCategory GetDALEntity(BLLCategory category) { DALCategory result = new DALCategory() { Id = category.Id, Name = category.Name }; foreach (var sphere in category.Sphere) { result.Sphere.Add(SphereMapper.GetDALEntity(sphere)); } return(result); }
protected void btnDelete_Click(object sender, EventArgs e) { foreach (RepeaterItem item in rptCategories.Items) { CheckBox chbSelect = (CheckBox)item.FindControl("chbSelect"); if (chbSelect.Checked) { Label lblCategoryCode = (Label)item.FindControl("lblCategoryCode"); DALCategory obj = new DALCategory(); obj.Category_Delete(Convert.ToInt32(lblCategoryCode.Text)); } } BindCategories(); }
protected void lvCat_ItemCommand(object sender, ListViewCommandEventArgs e) { DAL.DALCategory dALCategory = new DALCategory(); int catParentID = int.Parse(e.CommandArgument.ToString()); if (String.Equals(e.CommandName, "btnProd") && dALCategory.GetCategoriesEnfantImgByParentID(catParentID).Count == 0) { string url = "Produits.aspx?idcat=" + catParentID; Response.Redirect(url); } else { string url = "Categories.aspx?idCat=" + catParentID; Response.Redirect(url); } }
private void ChargeMenu() { StringBuilder stringBuilder = new StringBuilder(); Category category = new Category(); DAL.DALCategory dALCategory = new DALCategory(); HashSet <Category> catparents = new HashSet <Category>(); catparents = dALCategory.GetCategoryParent(); HashSet <Category> catenfants = new HashSet <Category>(); string caret = string.Empty; string classMP = string.Empty; string classMPDT = string.Empty; foreach (Category item in catparents) { catenfants = dALCategory.GetCategoryByParentId(item.Id); if (catenfants.Count - 1 > 0) { caret = "caret"; classMP = "dropdown-toggle"; classMPDT = "dropdown"; } else { caret = string.Empty; classMP = string.Empty; classMPDT = string.Empty; } stringBuilder.Append($"<li class='dropdown'><a runat='server' class='{classMP}' data-toggle='{classMPDT}' href=\"Produits.aspx?idcat=" + item.Id + "\">" + item.Name + $"<span class='{caret}'></span></a>"); if (catenfants.Count - 1 > 0) { stringBuilder.Append("<ul class='dropdown-menu'>"); foreach (var i in catenfants) { stringBuilder.Append("<li class='dropdown-item'><a runat='server'href=\"Produits.aspx?idcat=" + i.Id + "\">" + i.Name + "</a></li>"); } stringBuilder.Append("</ul>"); } } //stringBuilder.Append("<li class='dropdown'><a runat=\"server\" href=\"~/ VotrePanier\">Panier</a></li>"); listcatp.InnerHtml = stringBuilder.ToString(); }
public static DALCategory GetDALEntity(this Category ORMEntity) { if (ORMEntity == null) { throw new ArgumentNullException($"{ORMEntity} is null!"); } var newDALCategory = new DALCategory { Id = ORMEntity.Id, Name = ORMEntity.Name, }; foreach (var sphere in ORMEntity.Sphere) { newDALCategory.Sphere.Add(sphere.GetDALEntity()); } return(newDALCategory); }
public static Category GetORMEntity(this DALCategory DalEntity) { if (DalEntity == null) { throw new ArgumentNullException($"{DalEntity} is null!"); } var newCategory = new Category { Id = DalEntity.Id, Name = DalEntity.Name, }; foreach (var sphere in DalEntity.Sphere) { newCategory.Sphere.Add(sphere.GetORMEntity()); } return(newCategory); }
public bool DeleteCategory(Category category) { DALCategory categoryDAL = new DALCategory(); return(categoryDAL.DeleteCategory(category)); }
public List <CategoryDic> GetCategoryIdName() { return(dbManager.Execute(conn => DALCategory.GetCategoryIdName(conn))); }
public void Create(DALCategory e) { context.Set <Category>().Add(e.GetORMEntity()); }
public bool InsertNewAppData(NewAppData model) { return(dbManager.Execute(conn => DALCategory.InsertNewAppData(conn, model))); }
public int GetMaxModelFloor(NewAppData model) { return(dbManager.Execute(conn => DALCategory.GetMaxModelFloor(conn, model))); }
public bool InsertCategory(CategoryDic model) { return(dbManager.Execute(conn => DALCategory.InsertCategory(conn, model))); }
public List <NewAppData> GetNewAppData() { return(dbManager.Execute(conn => DALCategory.GetNewAppData(conn))); }
public void UpDate(DALCategory e) { context.Entry(e.GetORMEntity()).State = EntityState.Modified; }
public void Delete(DALCategory e) { context.Set <Category>().Attach(e.GetORMEntity()); context.Set <Category>().Remove(e.GetORMEntity()); }
public static List <EntityCategory> LLCategoryList() { return(DALCategory.CategoryList()); }
public List <Category> GetCategoriesByTypeId(int typeId) { DALCategory categoyDAL = new DALCategory(); return(categoyDAL.GetCategoriesByTypeId(typeId)); }
public bool InsertCategory(Category category) { DALCategory categoryDAL = new DALCategory(); return(categoryDAL.InsertCategory(category)); }
public List <Category> GetcategoryList() { DALCategory categoryDAL = new DALCategory(); return(categoryDAL.GetCategoryList()); }
public bool UpdateCategory(Category category) { DALCategory categoryDAL = new DALCategory(); return(categoryDAL.UpdateCategory(category)); }