public int addCatogory(string catogoryName) { try { DTO_Catogory dto_catogory = new DTO_Catogory(); dto_catogory.CatogoryId = dal_catogory.increment(); dto_catogory.CatogoryName = catogoryName; return(dal_catogory.addCatogory(dto_catogory) == true ? 200 : 400); } catch { return(400); } }
public int editCatogory(long catogoryId, string catogoryName) { try { DTO_Catogory dto_catogory = new DTO_Catogory(); dto_catogory.CatogoryId = catogoryId; dto_catogory.CatogoryName = catogoryName; return(dal_catogory.editCatogory(dto_catogory) == true ? 200 : 400); } catch { return(400); } }
public bool editCatogory(DTO_Catogory dto_catogory) { try { openConnect(); SqlCommand cmd = new SqlCommand("stp_editCatogory", conn); //Tên store procedure cmd.CommandType = CommandType.StoredProcedure; //Cho biết đây là store procedure cmd.Parameters.AddWithValue("@madm", dto_catogory.CatogoryId); cmd.Parameters.AddWithValue("@tendm", dto_catogory.CatogoryName); cmd.ExecuteNonQuery(); closeConnect(); //Đóng kết nối return(true); } catch { closeConnect(); return(false); } }