private void SaveRegulation_Click(object sender, RoutedEventArgs e)
{
User currentUser = new User();
currentUser = (User)Application.Current.Properties["UserInfo"];
ChangeRegulation updateFee = new ChangeRegulation();
updateFee.modified = DateTime.Now;
updateFee.id_function = Convert.ToInt32(txtFeeId.Text);
updateFee.value_old = Convert.ToInt32(txtFeeOld.Text);
updateFee.value_apply = Convert.ToInt32(txtFeeExam.Text);
updateFee.date_apply = Convert.ToDateTime(dpApplyDate.SelectedDate);
ChangeRegulation updateNumOfPatient = new ChangeRegulation();
updateNumOfPatient.modified = DateTime.Now;
updateNumOfPatient.id_function = Convert.ToInt32(txtPatientId.Text);
updateNumOfPatient.value_old = Convert.ToInt32(txtPatientOld.Text);
updateNumOfPatient.value_apply = Convert.ToInt32(txtNumOfPatient.Text);
updateNumOfPatient.date_apply = Convert.ToDateTime(dpApplyDate.SelectedDate);
try
{
int id = DataManager.getInstance().updateRegulation(updateFee, updateNumOfPatient, currentUser.id);
MessageBox.Show("Cập nhật thành công!");
LoadRegulation();
}
catch
{
MessageBox.Show("Cập nhật thất bại!");
}
}
static public int updateRegulation(ChangeRegulation updateFee, ChangeRegulation updatePatient, int user_update)
{
int id = Active.update("UPDATE change_reg SET modifled_day = '" + updateFee.modified.ToString("yyyy-MM-dd HH:mm:ss") + "', value_old = '" + updateFee.value_old + "', value_new = '" + updateFee.value_apply + "', user_change = '" + user_update + "', date_apply = '" + updateFee.date_apply.ToString("yyyy-MM-dd HH:mm:ss") + "' where id_function = " + updateFee.id_function + "");
id = Active.update("UPDATE change_reg SET modifled_day = '" + updatePatient.modified.ToString("yyyy-MM-dd HH:mm:ss") + "', value_old = '" + updatePatient.value_old + "', value_new = '" + updatePatient.value_apply + "', user_change = '" + user_update + "', date_apply = '" + updatePatient.date_apply.ToString("yyyy-MM-dd HH:mm:ss") + "' where id_function = " + updatePatient.id_function + "");
return(id);
}
static public List <ChangeRegulation> getAllRegulation()
{
DataTable dt = Active.select(" select * from change_reg ");
List <ChangeRegulation> listRegulation = new List <ChangeRegulation>();
for (int i = 0; i < dt.Rows.Count; i++)
{
ChangeRegulation reg = new ChangeRegulation();
reg.id_function = Convert.ToInt32(dt.Rows[i]["id_function"]);
reg.name_function = dt.Rows[i]["name_function"].ToString();
reg.value_old = Convert.ToInt32(dt.Rows[i]["value_old"]);
reg.date_apply = Convert.ToDateTime(dt.Rows[i]["date_apply"]);
reg.value_apply = Convert.ToInt32(dt.Rows[i]["value_new"]);
listRegulation.Add(reg);
}
return(listRegulation);
}
public int updateRegulation(ChangeRegulation updateFee, ChangeRegulation updatePatient, int user_change)
{
return(DataHelper.updateRegulation(updateFee, updatePatient, user_change));
}
