public Boolean SuaPB(PhongBan pb) { SqlConnection conn = getConnection(); conn.Open(); try { string sqlSua = "DECLARE @dem int select @dem = COUNT(MaPB) FROM PhongBan WHERE MaPB = @MaPB " + "IF @dem != 0 UPDATE PhongBan SET TenPB = @TenPB , NgayThanhLap = @NgayThanhLap WHERE MaPB = @MaPB else raiserror('',16,1)"; SqlCommand cmd = new SqlCommand(sqlSua, conn); cmd.Parameters.AddWithValue("MaPB", pb.MaPB); cmd.Parameters.AddWithValue("TenPB", pb.TenPB); cmd.Parameters.AddWithValue("NgayThanhLap", pb.NgayThanhLap); cmd.ExecuteNonQuery(); } catch (Exception) { return(false); } finally { conn.Close(); } return(true); }
public bool AddPhongBan(PhongBan phongBan) { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@TenPhongBan", phongBan.TenPhongBan); parameters.Add("@IsDelete", phongBan.IsDeleted); SqlMapper.Execute(con, "AddPhongBan", param: parameters, commandType: CommandType.StoredProcedure); return(true); }
public int Insert(PhongBan obj) { MySqlParameter[] para = { new MySqlParameter("idPB", obj.IDPhongBan), new MySqlParameter("tenPB", obj.namePhongBan) }; return(db.ExecuteSQL("phongban_Insert", para)); }
public bool CreatePhongBan(PhongBan phongBan) { try { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@MaPB", phongBan.MaPB); parameters.Add("@TenPB", phongBan.TenPB); SqlMapper.Execute(con, "CreatePhongBan", param: parameters, commandType: CommandType.StoredProcedure); return(true); } catch (Exception ex) { throw ex; } }
public bool Sua(PhongBan pb) { try { string query = @" UPDATE dbo.PhongBan set tenphongban = N'" + pb.Ten + "',manql = '" + pb.MaQL + "', diadiem = N'" + pb.DiaDiem + "' where maphong ='" + pb.Ma + "'"; OpenConection(); ExecuteQueries(query); CloseConnection(); return(true); } catch (Exception ex) { SetEx(ex); return(false); } }
public bool UpdatePhongBan(PhongBan phongBan) { try { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@IDPhongBan", phongBan.IDPhongBan); parameters.Add("@TenPhongBan", phongBan.TenPhongBan); //parameters.Add("@UserEmail", phongBan.IsDeleted); SqlMapper.Execute(con, "AddPhongBan", param: parameters, commandType: CommandType.StoredProcedure); return(true); } catch (Exception ex) { throw ex; } }
public bool Them(PhongBan pb) { try { string query = @"INSERT INTO dbo.PhongBan( MaPhong ,TenPhongBan , MaNQL ,DiaDiem) VALUES ( '" + pb.Ma + "',N'" + pb.Ten + "', '" + pb.MaQL + "',N'" + pb.DiaDiem + "')"; OpenConection(); ExecuteQueries(query); CloseConnection(); return(true); } catch (Exception ex) { SetEx(ex); return(false); } }
public Boolean ThemPB(PhongBan pb) { SqlConnection conn = getConnection(); conn.Open(); try { string sqlThem = "INSERT INTO PhongBan VALUES(@MaPB , @TenPB , @NgayThanhLap)"; SqlCommand cmd = new SqlCommand(sqlThem, conn); cmd.Parameters.AddWithValue("MaPB", pb.MaPB); cmd.Parameters.AddWithValue("TenPB", pb.TenPB); cmd.Parameters.AddWithValue("NgayThanhLap", pb.NgayThanhLap); cmd.ExecuteNonQuery(); } catch (Exception) { return(false); } finally { conn.Close(); } return(true); }
partial void DeletePhongBan(PhongBan instance);
partial void UpdatePhongBan(PhongBan instance);
partial void InsertPhongBan(PhongBan instance);
public void Update(PhongBan obj) { db.Update("update phongban set TenPB = '" + obj.namePhongBan + "' Where MaPB = '" + obj.IDPhongBan + "'"); }