public bool SanPham_Insert(Entity.SanPham Data) { try { using (SqlCommand dbCmd = new SqlCommand("sp_Hang_Insert", GetConnection())) { dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add(new SqlParameter("@TenHang", Data.TenHang)); dbCmd.Parameters.Add(new SqlParameter("@TomTat", Data.TomTat)); dbCmd.Parameters.Add(new SqlParameter("@Mota", Data.Mota)); dbCmd.Parameters.Add(new SqlParameter("@image", Data.Image)); dbCmd.Parameters.Add(new SqlParameter("@ChatLieu", Data.ChatLieu)); dbCmd.Parameters.Add(new SqlParameter("@giaMoi", Data.GiaMoi)); dbCmd.Parameters.Add(new SqlParameter("@giaCu", Data.GiaCu)); dbCmd.Parameters.Add(new SqlParameter("@id_Menu", Data.Id_Menu)); dbCmd.Parameters.Add(new SqlParameter("@Soluong", Data.Soluong)); dbCmd.Parameters.Add(new SqlParameter("@Active", Data.Active)); dbCmd.Parameters.Add(new SqlParameter("@image_large", Data.ImageLarge)); dbCmd.ExecuteNonQuery(); } //Clear cache System.Web.HttpContext.Current.Cache.Remove("SanPham"); return(true); } catch { return(false); } }
public List <Entity.SanPham> SanPham_GetByTop(string Top, string Where, string Order) { List <Entity.SanPham> list = new List <Entity.SanPham>(); using (SqlCommand dbCmd = new SqlCommand("sp_Hang_getByTop", GetConnection())) { Entity.SanPham obj = new Entity.SanPham(); dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add(new SqlParameter("@Top", Top)); dbCmd.Parameters.Add(new SqlParameter("@Where", Where)); dbCmd.Parameters.Add(new SqlParameter("@Order", Order)); SqlDataReader dr = dbCmd.ExecuteReader(); dr.Close(); dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { list.Add(obj.SanPhamIDataReader(dr)); } } dr.Close(); obj = null; } return(list); }
public Entity.SanPham SanPhamIDataReader(IDataReader dr) { Entity.SanPham obj = new Entity.SanPham(); obj.Id = (dr["Id"] is DBNull) ? string.Empty : dr["Id"].ToString(); obj.TenHang = (dr["TenHang"] is DBNull) ? string.Empty : dr["TenHang"].ToString(); obj.Image = (dr["Image"] is DBNull) ? string.Empty : dr["Image"].ToString(); obj.ChatLieu = (dr["ChatLieu"] is DBNull) ? string.Empty : dr["ChatLieu"].ToString(); obj.Mota = (dr["Mota"] is DBNull) ? string.Empty : dr["Mota"].ToString(); obj.LuotXem = (dr["LuotXem"] is DBNull) ? string.Empty : dr["LuotXem"].ToString(); obj.GiaMoi = (dr["GiaMoi"] is DBNull) ? string.Empty : dr["GiaMoi"].ToString(); obj.GiaCu = (dr["GiaCu"] is DBNull) ? string.Empty : dr["GiaCu"].ToString(); obj.Id_Menu = (dr["Id_Menu"] is DBNull) ? string.Empty : dr["Id_Menu"].ToString(); obj.Soluong = (dr["Soluong"] is DBNull) ? string.Empty : dr["Soluong"].ToString(); obj.TinhTrang = (dr["TinhTrang"] is DBNull) ? string.Empty : dr["TinhTrang"].ToString(); obj.Active = (dr["Active"] is DBNull) ? string.Empty : dr["Active"].ToString(); obj.ImageLarge = (dr["image_large"] is DBNull) ? string.Empty : dr["image_large"].ToString(); obj.TomTat = (dr["TomTat"] is DBNull) ? string.Empty : dr["TomTat"].ToString(); return(obj); }
protected void btnSave_Top_Click(object sender, EventArgs e) { Entity.SanPham dts = new Entity.SanPham(); tbl_Hang dt = new tbl_Hang(); if (insert == true) { dt.TenHang = txttenhang.Text; dt.id_Menu = int.Parse(ddltennhomhang.SelectedValue); dt.ChatLieu = txtchatlieu.Text; dt.giaMoi = decimal.Parse(txtgiamoi.Text); dt.giaCu = decimal.Parse(txtgiacu.Text); dt.Soluong = int.Parse(txtsoluong.Text); dt.TomTat = txttomtat.Text; if (int.Parse(txtsoluong.Text) > 0) { dt.TinhTrang = "Còn"; } dt.Mota = txtNoidung.Text; if (ful_hinhanhlon.HasFile) { try { string Duoi_filename = Path.GetExtension(ful_hinhanhlon.FileName); string filename = ful_hinhanhlon.FileName.ToString();; if (Duoi_filename == ".jpeg" || Duoi_filename == ".jpg" || Duoi_filename == ".png" || Duoi_filename == ".PNG" || Duoi_filename == ".JPG" || filename == ".JPEG") { ful_hinhanhlon.SaveAs(Server.MapPath("~/images/") + filename); dt.image_large = "images/" + filename; } else { Response.Write("<script>alert('Bạn chỉ được upload jpg,png,jpeg')</script>"); return; } } catch (Exception ex) { } } if (ful_hinhanhnho.HasFile) { try { string Duoi_filename = Path.GetExtension(ful_hinhanhnho.FileName); string filename = ful_hinhanhnho.FileName.ToString();; if (Duoi_filename == ".jpeg" || Duoi_filename == ".jpg" || Duoi_filename == ".png" || Duoi_filename == ".PNG" || Duoi_filename == ".JPG" || filename == ".JPEG") { ful_hinhanhnho.SaveAs(Server.MapPath("~/images/") + filename); dt.image = "images/" + filename; } else { Response.Write("<script>alert('Bạn chỉ được upload jpg,png,jpeg')</script>"); return; } } catch (Exception ex) { } } dt.Active = bool.Parse(ckbActive.Checked == true ? "True" : "False"); //SanPhamService.SanPham_Insert(dts); db.tbl_Hangs.InsertOnSubmit(dt); db.SubmitChanges(); Response.Write("<script>alert('Thêm mới thành công!!!')</script>"); getData(); } else { dts.Id = txtID.Text; dts.TenHang = txttenhang.Text; dts.Id_Menu = ddltennhomhang.SelectedValue; dts.ChatLieu = txtchatlieu.Text; dts.GiaMoi = txtgiamoi.Text; dts.GiaCu = txtgiacu.Text; dts.Soluong = txtsoluong.Text; dts.TomTat = txttomtat.Text; if (int.Parse(txtsoluong.Text) > 0) { dts.TinhTrang = "Còn"; } dts.Mota = txtNoidung.Text; if (ful_hinhanhlon.HasFile) { try { string Duoi_filename = Path.GetExtension(ful_hinhanhlon.FileName); string filename = ful_hinhanhlon.FileName.ToString();; if (Duoi_filename == ".jpeg" || Duoi_filename == ".jpg" || Duoi_filename == ".png" || Duoi_filename == ".PNG" || Duoi_filename == ".JPG" || filename == ".JPEG") { ful_hinhanhlon.SaveAs(Server.MapPath("~/images/") + filename); dts.ImageLarge = "images/" + filename; } else { Response.Write("<script>alert('Bạn chỉ được upload jpg,png,jpeg')</script>"); return; } } catch (Exception ex) { } } else { dts.Image = fileUpLoad_nho; } if (ful_hinhanhnho.HasFile) { try { string Duoi_filename = Path.GetExtension(ful_hinhanhnho.FileName); string filename = ful_hinhanhnho.FileName.ToString();; if (Duoi_filename == ".jpeg" || Duoi_filename == ".jpg" || Duoi_filename == ".png" || Duoi_filename == ".PNG" || Duoi_filename == ".JPG" || filename == ".JPEG") { ful_hinhanhnho.SaveAs(Server.MapPath("~/images/") + filename); dts.Image = "images/" + filename; } else { Response.Write("<script>alert('Bạn chỉ được upload jpg,png,jpeg')</script>"); return; } } catch (Exception ex) { } } else { dts.ImageLarge = fileUpLoad_lon; } dts.Active = ckbActive.Checked == true ? "True" : "False"; SanPhamService.SanPham_Update(dts); Response.Write("<script>alert('Update thành công!!!')</script>"); getData(); } insert = true; pnData.Visible = true; pnInfo.Visible = false; ClearText(); }
public static bool SanPham_Update(Entity.SanPham data) { return(cmb.SanPham_Update(data)); }
public static bool SanPham_Insert(Entity.SanPham data) { return(cmb.SanPham_Insert(data)); }