public bool updateEmployee(ref string err, int id, string name, DateTime bDay, DateTime stDay, string salary)
{
return(database.ExNonQueryData(ref err, "sp_update_em", CommandType.StoredProcedure, new SqlParameter("@id", id), new SqlParameter("@name", name),
new SqlParameter("@bday", bDay),
new SqlParameter("@stday", stDay),
new SqlParameter("@salary", salary)));
}
public bool AddContractExcuNonQue(ref string err, string no_num, string name_per, string id_code, string address,
string phone, DateTime no_day, DateTime sign_day, int nu_book, string des, string ty_name, string type, int price, string sig_person, string note, int year_bo)
{
return(data.ExNonQueryData(ref err, "add_contract", CommandType.StoredProcedure, new SqlParameter("@no_num", no_num),
new SqlParameter("@name_per", name_per),
new SqlParameter("@id_code", id_code),
new SqlParameter("@address", address),
new SqlParameter("@phone", phone),
new SqlParameter("@no_day", no_day),
new SqlParameter("@sign_day", sign_day),
new SqlParameter("@nu_book", nu_book),
new SqlParameter("@des", des),
new SqlParameter("@ty_name", ty_name),
new SqlParameter("@type", type),
new SqlParameter("@price", price),
new SqlParameter("@sig_person", sig_person),
new SqlParameter("@note", note),
new SqlParameter("@year_bo", year_bo)));
}
public bool deleteCustomer(ref string err, string id_code)
{
return(data.ExNonQueryData(ref err, "sp_delete_customer", CommandType.StoredProcedure, new SqlParameter("@id_code", id_code)));
}