/// <summary> /// JSON data format of {"category" : "1", "data" : "xxx"} /// where xxx depends of category: /// NewOpenJob - job id, app should regconize and go to the open job page (partner) /// OrderCreated - order id, app should regconize and go to order status page (consumer) /// OrderStatusUpdate - order id, app should regconize and go to order status page (consumer) /// RatingUpdate - job id, app should open the job details page on the delivery (partner) /// JobAssigned - job id, app should open the job details page on the delivery (driver) /// </summary> /// <param name="category"></param> /// <returns></returns> public static object ConstructExtraData(ECategories category, string data) { return(new ExtraData() { category = ((int)category).ToString(), data = data }); }
/// <summary> /// Devuelve todas las categorias /// </summary> /// <returns></returns> public List <ECategories> GetAll() { List <ECategories> res = new List <ECategories>(); try { using (var db = new DataAccess.Models.NewsDBContext()) { var query = (from x in db.Categories select x).ToList(); if (query.Any()) { foreach (var i in query) { ECategories e = new ECategories(); e.IdCategory = i.IdCategory; e.Name = i.Name; e.Description = i.Description; res.Add(e); } } } } catch (Exception) { throw; } return(res); }
public string UpdateECategories(string companyCode, string json) { clsDataAccessor dataAccessor = new clsDataAccessor(); dataAccessor.connectionstring = dataAccessor.getConnectionString_Vapt(dataAccessor, companyCode); ECategories EC = new ECategories(); var serializer = new System.Web.Script.Serialization.JavaScriptSerializer(); string response = ""; /* json = @"{ * ""cat_id"":""12122222"", * ""cat_code"":""Testing181212"", * ""cat_descp"":""test"", * ""cat_otherlanguage"":"""", * ""cat_createdate"":""2019-11-07"", * }"; * * passing value : * {"eCategory":[{"cat_id":"1","cat_code":"Bird’s Nest & Snow Jelly","cat_descp":"Bird’s Nest & Snow Jelly","cat_otherlanguage":"","cat_createdate":"2019-11-13"}, * {"cat_id":"2","cat_code":"Dried Bird’s Nest","cat_descp":"Dried Bird’s Nest","cat_otherlanguage":"","cat_createdate":"2019-11-13"}]} */ try { EC = serializer.Deserialize <ECategories>(json); } catch (Exception ex) { return(ex.ToString()); } response = dataAccessor.updateECateoriesData(EC); return(response); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { return; } if (Request.QueryString["ID"] != null) { ECategories category = new ECategories(); category.ID = int.Parse(Request.QueryString["ID"]); bool sonuc = BLLCategories.Delete(category); if (sonuc) { Response.Write("<script>alert('Harika! Silindi!')</script>"); } else { Response.Write("<script>alert('Hay Aksi! Silinemedi!')</script>"); } } rptKategoriler.DataSource = BLLCategories.GetAll(); rptKategoriler.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>"); } } }
public IActionResult Update([FromBody] ECategories e) { var res = daCategories.Update(e); if (res) { return(Ok()); } return(BadRequest()); }
public static void Delete(ECategories category) { SqlCommand cmd = new SqlCommand("spCategories_Delete", Baglanti.conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("categoryID", category.ID); Baglanti.conn.Open(); cmd.ExecuteNonQuery(); Baglanti.conn.Close(); }
public void Create() { DA.Business.DaCategories _da = new DA.Business.DaCategories(); ECategories e = new ECategories(); e.Name = "Categoria Prueba"; e.Description = "Descri Prueba"; var res = _da.Create(e); Assert.IsNotNull(res); }
public static void InsertNewCategory(ECategories category) { SqlCommand cmd = new SqlCommand("spCategories_Insert", Baglanti.conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Name", category.Name); cmd.Parameters.AddWithValue("@Description", category.Description); Baglanti.conn.Open(); cmd.ExecuteNonQuery(); Baglanti.conn.Close(); }
public static bool InsertNewCategory(ECategories category) { if (category.Name == "") { return(false); } else { DALCategories.InsertNewCategory(category); return(true); } }
protected void Page_Load(object sender, EventArgs e) { int categoryID = Convert.ToInt32(Request.QueryString["categoryID"].ToString()); ECategories category = new ECategories(); category = BLLCategories.GetIdOnly(categoryID); if (!IsPostBack) { txtTurAdi.Text = category.Name; TxtTurAciklamasi.Text = category.Description; } }
public IActionResult Create([FromBody] ECategories e) { if (ModelState.IsValid) { var res = daCategories.Create(e); if (res != 0) { return(new CreatedAtRouteResult("CreatedCategory", new { id = res }, e)); } return(BadRequest("Error en la creacion")); } return(BadRequest(ModelState)); }
public ECategories Get(int id) { ECategories res = new ECategories(); try { var q = (from x in db.Categories select x).FirstOrDefault(); res.Description = q.Description; res.Name = q.Name; } catch (Exception) { throw; } return(res); }
public bool Update(ECategories e) { bool res = false; try { var query = (from x in db.Categories where x.IdCategory == e.IdCategory select x).FirstOrDefault(); query.Name = e.Name; query.Description = e.Description; db.Categories.Update(query); db.SaveChanges(); res = true; } catch (Exception) { throw; } return(res); }
public int Create(ECategories e) { int res = 0; try { DataAccess.Models.Categories obj = new Categories(); obj.Name = e.Name; obj.Description = e.Description; db.Categories.Add(obj); db.SaveChanges(); res = obj.IdCategory; } catch (Exception) { throw; } return(res); }
public static List <ECategories> GetAll() { SqlCommand cmd = new SqlCommand("spCategories_GetAll", Baglanti.conn); Baglanti.conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); List <ECategories> cliste = new List <ECategories>(); while (dr.Read()) { ECategories c = new ECategories(); c.ID = Convert.ToInt32(dr["ID"]); c.Name = dr["Name"].ToString(); c.Description = dr["Description"].ToString(); cliste.Add(c); } dr.Close(); Baglanti.conn.Close(); return(cliste); }
public static ECategories GetIdOnly(int categoryID) { SqlCommand cmd = new SqlCommand("spCategories_GetIdOnly", Baglanti.conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CategoryID", categoryID); Baglanti.conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); ECategories category = new ECategories(); while (dr.Read()) { category.ID = Convert.ToInt32(dr["ID"]); category.Name = dr["Name"].ToString(); category.Description = dr["Description"].ToString(); } dr.Close(); Baglanti.conn.Close(); return(category); }
/// <summary> /// update a category created /// </summary> /// <param name="e"></param> /// <returns></returns> public bool Update(ECategories e) { bool res = false; try { using (var db = new DataAccess.Models.NewsDBContext()) { var query = (from x in db.Categories where x.IdCategory == e.IdCategory select x).FirstOrDefault(); query.Name = e.Name; query.Description = e.Description; db.Categories.Update(query); db.SaveChanges(); res = true; } } catch (Exception) { throw; } return(res); }
protected void btnKaydet_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(txtTurAdi.Text)) { List <ECategories> categoryList = BLLCategories.GetAll(); categoryList = (from l in categoryList where l.Name.Trim().ToLower().Equals(txtTurAdi.Text.Trim().ToLower()) select l).ToList(); if (categoryList.Count == 0) { ECategories kategori = new ECategories(); kategori.Name = txtTurAdi.Text; kategori.Description = TxtTurAciklamasi.Text; if (BLLCategories.InsertNewCategory(kategori)) { Response.Write("<script>alert('Tür 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 tür zaten kayıtlı!')</script>"); } txtTurAdi.Text = String.Empty; TxtTurAciklamasi.Text = String.Empty; txtTurAdi.Focus(); } else { Response.Write("<script>alert('Tür adı boş geçilemez!')</script>"); } }
/// <summary> /// Retornar una categoria por su ID /// </summary> /// <param name="id"></param> /// <returns></returns> public ECategories Get(int id) { ECategories res = new ECategories(); try { using (var db = new DataAccess.Models.NewsDBContext()) { var q = (from x in db.Categories where x.IdCategory == id select x).FirstOrDefault(); if (q != null) { res.IdCategory = q.IdCategory; res.Name = q.Name; res.Description = q.Description; } } } catch (Exception) { throw; } return(res); }
private void btnSil_Click(object sender, EventArgs e) { if (lstTurler.SelectedItems.Count > 0) { int silinecekKategoriID = (int)lstTurler.SelectedValue; DialogResult result = MessageBox.Show("Silmek istediğinize emin misiniz ?", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (result == DialogResult.Yes) { ECategories category = new ECategories(); category.ID = silinecekKategoriID; if (BLLCategories.Delete(category)) { MessageBox.Show("Silme işleminiz başarıyla tamamlanmıştır."); lstTurler.DataSource = BLLCategories.GetAll(); } } } else { MessageBox.Show("Lütfen silmek istediğiniz türü seçiniz!"); } }
public List <ECategories> GetAll() { List <ECategories> res = new List <ECategories>(); try { var query = (from x in db.Categories select x).ToList(); if (query.Any()) { foreach (var i in query) { ECategories e = new ECategories(); e.Name = i.Name; e.Description = i.Description; res.Add(e); } } } catch (Exception ex) { throw; } return(res); }
private void btnKaydet_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(txtTurAdi.Text)) { List <ECategories> categoryList = BLLCategories.GetAll(); categoryList = (from l in categoryList where l.Name.Trim().ToLower().Equals(txtTurAdi.Text.Trim().ToLower()) select l).ToList(); if (categoryList.Count == 0) { ECategories kategori = new ECategories(); kategori.Name = txtTurAdi.Text; kategori.Description = TxtTurAciklamasi.Text; if (BLLCategories.InsertNewCategory(kategori)) { MessageBox.Show("Kategori kayıt işlemi başarıyla gerçekleşmiştir!"); lstTurler.DataSource = BLLCategories.GetAll(); txtTurAdi.Clear(); TxtTurAciklamasi.Clear(); } } else { MessageBox.Show("Kaydetmek istediğiniz tür zaten kayıtlıdır!"); txtTurAdi.Clear(); TxtTurAciklamasi.Clear(); } } else { MessageBox.Show("Tür adı boş geçilemez!"); } }
protected void btnGuncelle_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(txtTurAdi.Text)) { ECategories guncellenecek = new ECategories(); guncellenecek.ID = int.Parse(Request.QueryString["categoryID"]); guncellenecek.Name = txtTurAdi.Text; guncellenecek.Description = TxtTurAciklamasi.Text; bool sonuc = BLLCategories.Update(guncellenecek); if (sonuc) { Response.Write("<script>alert('Harika! Güncellendi!');</script>"); Response.Redirect("Kategoriler.aspx?scs=1"); } else { Response.Write("<script>alert('Hay Aksi! Hata Oluştu!')</script>"); } } else { Response.Write("<script>alert('Tür adı boş geçilemez!')</script>"); } }
public static bool Update(ECategories category) { DALCategories.Update(category); return(true); }
public static bool Delete(ECategories category) { DALCategories.Delete(category); return(true); }
protected override void Seed(DatabaseContext context) { EUser admin = new EUser() { Name = "Sinan", Surname = "Tok", Email = "*****@*****.**", ActiveGuid = Guid.NewGuid(), IsActive = true, IsAdmin = true, Gender = "Erkek", Birthday = DateTime.Now.AddYears(-22), Username = "******", Password = "******", ProfileImageFileName = "user.jpg", CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now.AddMinutes(5), ModifiedUser = "******" }; EUser standartUser = new EUser() { Name = "Ada", Surname = "Adale", Email = "*****@*****.**", ActiveGuid = Guid.NewGuid(), IsActive = true, IsAdmin = false, Gender = "Kadın", Birthday = DateTime.Now.AddYears(-22), Username = "******", Password = "******", ProfileImageFileName = "user.jpg", CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now.AddMinutes(5), ModifiedUser = "******" }; context.EUsers.Add(admin); context.EUsers.Add(standartUser); context.SaveChanges(); ECategories eCategories1 = new ECategories() { Title = "Cüzdan", Description = "El Yapımı Cüzdan", CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now, ModifiedUser = "******" }; ECategories eCategories2 = new ECategories() { Title = "Kartlık", Description = "El Yapımı kartlık", CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now, ModifiedUser = "******" }; context.ECategories.Add(eCategories1); context.ECategories.Add(eCategories2); context.SaveChanges(); EProducts eProducts1 = new EProducts() { Name = "Legos Cüzdan", Description = "Minimal tasarımı ile el yapımı cüzdan", Price = 1200, Stock = 500, IsApproved = true, Category = eCategories1, CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now, IsFront = true, ModifiedUser = "******", ImageFileName = "legos.jpeg" }; EProducts eProducts2 = new EProducts() { Name = "Legos Kartlık", Description = "Minimal tasarımı ile el yapımı cüzdan", Price = 1200, Stock = 500, IsApproved = true, Category = eCategories1, CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now, IsFront = true, ModifiedUser = "******", ImageFileName = "legos.jpeg" }; context.EProducts.Add(eProducts1); context.EProducts.Add(eProducts2); context.SaveChanges(); EOrders eOrders = new EOrders() { Description = "First Order", IsApproved = true, OrderDate = DateTime.Now, TotalMoney = 2400, UserId = "1", }; EOrdersDetail eOrdersDetail = new EOrdersDetail() { Order = eOrders, Products = eProducts1 }; EOrdersDetail eOrdersDetail2 = new EOrdersDetail() { Order = eOrders, Products = eProducts2 }; context.EOrders.Add(eOrders); context.SaveChanges(); context.EOrdersDetail.Add(eOrdersDetail); context.EOrdersDetail.Add(eOrdersDetail2); context.SaveChanges(); }