public int themlsp(LOAI_SAN_PHAM lsp)
{
if (ad.themLsp(lsp) == 0)
{
return(0);
}
else
{
return(1);
}
}
public bool XoaLoaiSP(string ma)
{
try
{
LOAI_SAN_PHAM p = sp.LOAI_SAN_PHAMs.Where(t => t.MALOAI == ma).FirstOrDefault();
sp.LOAI_SAN_PHAMs.DeleteOnSubmit(p);
sp.SubmitChanges();
return(true);
}
catch { return(false); }
}
public bool SuaTTLoaiSanPham(LOAI_SAN_PHAM p)
{
try
{
LOAI_SAN_PHAM k = sp.LOAI_SAN_PHAMs.Where(t => t.MALOAI == p.MALOAI).FirstOrDefault();
k = p;
sp.SubmitChanges();
return(true);
}
catch { return(false); }
}
public bool ThemLoaiSP(LOAI_SAN_PHAM loai)
{
try
{
sp.LOAI_SAN_PHAMs.InsertOnSubmit(loai);
sp.SubmitChanges();
return(true);
}
catch {
return(false);
}
}
public bool KTKhoaLoaiSP(string ma)
{
LOAI_SAN_PHAM loai = sp.LOAI_SAN_PHAMs.Where(t => t.MALOAI == ma).FirstOrDefault();
if (loai == null)
{
return(true);
}
else
{
return(false);
}
}
private void btnSua_Click(object sender, EventArgs e)
{
LOAI_SAN_PHAM p = new LOAI_SAN_PHAM();
int index = dataLoaiSP.CurrentCell.RowIndex;
//if (kh.IsNumber(p.SDTKH))
//{
if (qlkho.SuaTTLoaiSanPham(p))
{
MessageBox.Show("Cập nhật thông tin thành công");
}
else
{
MessageBox.Show("Cập nhật thông tin thất bại");
}
dataLoaiSP.DataSource = qlkho.LoadDLLoaiSP();
}
public HttpResponseMessage Create(HttpRequestMessage request, LOAI_SAN_PHAM loaiSanPhamModel)
{
return(CreateHttpResponse(request, () =>
{
HttpResponseMessage response = null;
if (ModelState.IsValid)
{
request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
else
{
var loaiSanPham = _loaiSanPhamService.Add(loaiSanPhamModel);
_loaiSanPhamService.SaveChange();
response = request.CreateResponse(HttpStatusCode.Created, loaiSanPham);
}
return response;
}));
}
public int themlsp(LOAI_SAN_PHAM lsp)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter("@MaLoaiSanPhams", SqlDbType.NVarChar, 20),
new SqlParameter("@TenLoaiSanPham", SqlDbType.NVarChar, 100),
new SqlParameter("@MoTa", SqlDbType.NVarChar, 350),
};
parm[0].Value = lsp.MaLoaiSanPham ?? DBNull.Value.ToString();
parm[1].Value = lsp.tenloaisanpham;
parm[2].Value = lsp.MoTa;
try
{
DataAccessHelper.ExecuteNonQuery(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "Insert_Auto_Product_Type", parm);
return(1);
}
catch
{
return(0);
}
}
public IList <LOAI_SAN_PHAM> GetAllLSPInAdmin(string page, string size) // in admin in shoping left -->inner
// in shoping
{
DataTable dt = new DataTable();
string cmdText = string.Format(@"Select LSP.*, Count(SP.MaLoaiSanPham) as 'Số lượng' From [dbo].[LOAI_SAN_PHAM] LSP
left join [dbo].[SAN_PHAM] SP
On LSP.MaLoaiSanPham = SP.MaLoaiSanPham
Group By LSP.MaLoaiSanPham, LSP.TenLoaiSanPham, LSP.MoTa
order by LSP.MaLoaiSanPham Desc Offset {1}*({0}-1) Rows Fetch Next {1} Rows Only" , page, size);
dt = DataAccessHelper.log(cmdText);
List <LOAI_SAN_PHAM> li = new List <LOAI_SAN_PHAM>();
foreach (DataRow dr in dt.Rows)
{
LOAI_SAN_PHAM lsp = new LOAI_SAN_PHAM();
lsp.maloaisanpham = dr[0].ToString();
lsp.tenloaisanpham = dr[1].ToString();
lsp.mota = dr[2].ToString();
lsp.soLuong = int.Parse(dr[3].ToString());
li.Add(lsp);
}
return(li);
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (txtLoaiSP.Text == "")
{
MessageBox.Show("bạn chưa nhập loại sản phẩm");
txtLoaiSP.Focus();
return;
}
LOAI_SAN_PHAM loai = new LOAI_SAN_PHAM();
loai.MALOAI = txtMaLoaiSP.Text;
loai.TENLOAI = txtLoaiSP.Text;
loai.MOTALSP = txtMoTa.Text;
if (qlkho.KTKhoaLoaiSP(txtMaLoaiSP.Text.Trim()))
{
if (qlkho.ThemLoaiSP(loai))
{
dataLoaiSP.DataSource = qlkho.LoadDLLoaiSP();
pnNhapLoaiSP.Enabled = false;
btnLuu.Enabled = false;
txtLoaiSP.Text = string.Empty;
txtMoTa.Text = string.Empty;
MessageBox.Show("Thêm thành công");
}
else
{
MessageBox.Show("Thêm thất bại");
}
}
else
{
MessageBox.Show("Trùng mã sản phẩm");
txtMaLoaiSP.Text = qlkho.MaLoaiSP();
}
}
public int themLsp(LOAI_SAN_PHAM lsp)
{
return(ad.themlsp(lsp));
}
public void Update(LOAI_SAN_PHAM loaiSanPham)
{
_loaiSanPhamRepository.Update(loaiSanPham);
}
public LOAI_SAN_PHAM Add(LOAI_SAN_PHAM loaiSanPham)
{
return(_loaiSanPhamRepository.Add(loaiSanPham));
}
