public void btnDeleteService_Click(object sender, EventArgs e)
{
try
{
Service_DTO service = new Service_DTO();
service.ServiceID = dtgvServiceInfoList.CurrentRow.Cells["ServiceID"].Value.ToString();
service.ServiceName = txtServiceName.Text;
if (txtServiceID.Text == "" || txtServiceName.Text == "" || txtServicePrice.Text == "")
{
XtraMessageBox.Show("You have to choose at least one service to delete!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
ClearDisplay();
return;
}
if (Service_BUS.DeleteService(service))
{
LoadServiceList();
XtraMessageBox.Show("Service Info has been deleted sucessfully!", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearDisplay();
return;
}
}
catch
{
XtraMessageBox.Show("Delete Info Failed!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
//@Description:
// Chỉnh sửa 1 dịch vụ bằng id
//@Parameter
// Service_DTO Service --------Tham số nhập là 1 dịch vụ
// int id -------- Mã dịch vụ
//@Proc:
//
//@Return:
// boolean ------------Thành công trả về true, thất bại trả về false;
public bool Edit_Service(Service_DTO service)
{
string query = "exec USP_EditService @id_service , @name_service , @price , @unit";
int x = Connect.Instance.ExecuteNonQuery(query, new object[] { service.Id_service, service.Name_service, service.Price, service.Unit });
return(x == 1);
}
public static List <Service_DTO> LoadService()
{
List <Service_DTO> listService = new List <Service_DTO>();
SqlConnection con = DataProvider.OpenConnection();
SqlCommand cmd = new SqlCommand("[JEWELRYSTOREMGMT].[dbo].[usp_getServiceList]", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count == 0)
{
return(null);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
Service_DTO service = new Service_DTO();
service.ServiceID = dt.Rows[i]["ServiceID"].ToString();
service.ServiceName = dt.Rows[i]["ServiceName"].ToString();
service.ServicePrice = float.Parse(dt.Rows[i]["ServicePrice"].ToString());
listService.Add(service);
}
DataProvider.CloseConnection(con);
return(listService);
}
private async void btn_enable_Click(object sender, RoutedEventArgs e)
{
progress_bar.Visibility = Visibility.Visible;
progress_bar2.Visibility = Visibility.Visible;
DataGridCellInfo temp = list_servicenotactive.SelectedCells[0];
Service_DTO service = temp.Item as Service_DTO;
string outlet_name = cb_outlet.SelectedItem.ToString();
int outlet_id = -1;
foreach (Outlet_DTO temp1 in list)
{
if (temp1.outlet_name == outlet_name)
{
outlet_id = temp1.outlet_id;
break;
}
}
DeactiveRequest deactive = new DeactiveRequest();
deactive.service_id = service.service_id;
deactive.outlet_id = outlet_id;
bool result = await RestAPI.PostServiceHandle(deactive, "active");
Start_State(cb_outlet.SelectedIndex);
}
public static bool UpdateService(Service_DTO service)
{
SqlConnection con = DataProvider.OpenConnection();
SqlCommand cmd = new SqlCommand("[JEWELRYSTOREMGMT].[dbo].[usp_updateService]", con);
try
{
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter("@ServiceID", service.ServiceID);
cmd.Parameters.Add(p);
p = new SqlParameter("@ServiceName", service.ServiceName);
cmd.Parameters.Add(p);
p = new SqlParameter("@ServicePrice", service.ServicePrice);
cmd.Parameters.Add(p);
cmd.ExecuteNonQuery();
DataProvider.CloseConnection(con);
return(true);
}
catch
{
DataProvider.CloseConnection(con);
return(false);
}
}
private void btnAddService_Click(object sender, EventArgs e)
{
try
{
Service_DTO service = new Service_DTO();
service.ServiceID = txtServiceID.Text;
service.ServiceName = txtServiceName.Text;
service.ServicePrice = float.Parse(txtServicePrice.Text);
if (txtServiceID.Text == "" || txtServiceName.Text == "" || txtServicePrice.Text == "")
{
XtraMessageBox.Show("You have to fullfill service information!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
ClearDisplay();
return;
}
if (Service_BUS.InsertService(service))
{
XtraMessageBox.Show("Service Info has been inserted sucessfully!", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadServiceList();
ClearDisplay();
return;
}
}
catch
{
XtraMessageBox.Show("Insert Info Failed!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
//@Description:
// Thêm vào 1 dịch vụ
//@Parameter
// Service_DTO Service --------Tham số nhập là 1 dịch vụ
//@Proc:
//
//@Return:
// boolean ------------Thành công trả về true, thất bại trả về false;
public bool Add_Service(Service_DTO service)
{
string query = "exec USP_InsertService @name_service , @price , @unit";// exec USP_InsertStuff @name = value , @price = value , @unit =value
int x = Connect.Instance.ExecuteNonQuery(query, new object[] { service.Name_service, service.Price, service.Unit });
return(x == 1);
}
public static async Task <Service_DTO> GetServiceDetail(string service_id)
{
Service_DTO service = new Service_DTO();
string api = "/api/service/" + service_id;
try
{
HttpClient client = new HttpClient();
client = RestAPI.Get_HttpClient_Token();
var response = new HttpResponseMessage();
response = await client.GetAsync(api).ConfigureAwait(false);
if (response.IsSuccessStatusCode)
{
var result = response.Content.ReadAsStringAsync().Result;
service = JsonConvert.DeserializeObject <Service_DTO>(result);
response.Dispose();
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(service);
}
private void list_serviceactive_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
DataGridCellInfo temp = list_serviceactive.SelectedCells[0];
Service_DTO service = temp.Item as Service_DTO;
MessageBox.Show(service.service_name);
}
private void fEdit_Service_Load(object sender, EventArgs e)
{
Service_DTO service_info = Service_BUS.Instance.Get_Info(this.Id_service);
txt_1.Text = service_info.Name_service;
txt_2.Text = service_info.Price.ToString();
txt_3.Text = service_info.Unit;
}
//@Description:
// Bắt lỗi hàm Thêm vào 1 dịch vụ
//@Parameter
// Service_DTO Service --------Tham số nhập là 1 dịch vụ
//@Proc:
//
//@Call:
// Service_DAO.Instance.Add_Service(service);
//@Return:
// boolean ------------Thành công trả về true, thất bại trả về false;
public bool Add_Service(Service_DTO service)
{
try
{
return(Service_DAO.Instance.Add_Service(service));
}
catch
{
throw new Exception("Error!");
}
}
//@Description:
// Lấy ra thông tin của dịch vụ bằng id
//@Parameter
// string id_Service
//@Proc:
//
//@Return:
// Service_DTO --- Trả về 1 dịch vụ
public Service_DTO Get_Info(int id_service)
{
string query = "exec USP_GetInfoService @id_service";
DataTable table = Connect.Instance.ExecuteQuery(query, new object[] { id_service });
Service_DTO service = null;
foreach (DataRow item in table.Rows)
{
service = new Service_DTO(item);
}
return(service);
}
private Service_DTO Set_Service()
{
Service_DTO ser = new Service_DTO();
if (this.id_service != 0)
{
ser.Id_service = this.Id_service;
}
ser.Name_service = txt_1.Text;
ser.Price = decimal.Parse(txt_2.Text);
ser.Unit = txt_3.Text;
return(ser);
}
//@Description:
// Tìm kiếm dịch vụ
//@Parameter
// String keyword
// int type_search ------- tìm kiếm theo mã hay tên, (bên dưới là chú thích loại tìm kiếm)
//@Proc:
//
//@Call:
// this.Del_Service(int id)
//@Return:
// List<Service_DTO> ------------ Trả về danh sách thỏa mãn
public List <Service_DTO> Search_Service(String keyword, int type)
{
string query = "exec USP_SearchService @keyword , @type";
DataTable table = Connect.Instance.ExecuteQuery(query, new object[] { keyword, type });
List <Service_DTO> list_Service = new List <Service_DTO>();
foreach (DataRow item in table.Rows)
{
Service_DTO service = new Service_DTO(item);
list_Service.Add(service);
}
return(list_Service);
}
//@Description:
// Lấy ra danh sách dịch vụ trong bảng
//@Parameter
// nope
//@Proc:
//
//@Return:
// List<Service_DTO> --- Trả về 1 danh sách các dịch vụ
public List <Service_DTO> Get_List()
{
string query = "exec USP_GetListService";
DataTable table = Connect.Instance.ExecuteQuery(query);
List <Service_DTO> list_service = new List <Service_DTO>();
foreach (DataRow item in table.Rows)
{
Service_DTO service = new Service_DTO(item);
list_service.Add(service);
}
return(list_service);
}
private void btn_ok_Click(object sender, EventArgs e)
{
bool flat = true;
if (txt_nameservice.Text == "")
{
lb_error_name.Text = "The \"Username\" is not empty";
flat = false;
}
if (txt_price.Text == "")
{
lb_error_price.Text = "The \"Price\" is not empty";
flat = false;
}
if (txt_unit.Text == "")
{
lb_error_unit.Text = "The \"Unit\" is not empty";
flat = false;
}
if (flat == true)
{
Service_DTO service = new Service_DTO();
service.Name_service = txt_nameservice.Text;
service.Price = decimal.Parse(txt_price.Text);
service.Unit = txt_unit.Text;
if (Service_BUS.Instance.Add_Service(service))
{
MessageBox.Show("Add Successful");
this.Close();
}
else
{
MessageBox.Show("False");
}
}
}
public static bool DeleteService(Service_DTO service)
{
SqlConnection con = DataProvider.OpenConnection();
SqlCommand cmd = new SqlCommand("[JEWELRYSTOREMGMT].[dbo].[usp_deleteService]", con);
try
{
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter("@ServiceID", service.ServiceID);
cmd.Parameters.Add(p);
cmd.ExecuteNonQuery();
DataProvider.CloseConnection(con);
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Notification", MessageBoxButtons.OK, MessageBoxIcon.Error);
DataProvider.CloseConnection(con);
return(false);
}
}
public static bool InsertService(Service_DTO service)
{
return(Service_DAL.InsertService(service));
}
public static bool DeleteService(Service_DTO service)
{
return(Service_DAL.DeleteService(service));
}
public static bool UpdateService(Service_DTO service)
{
return(Service_DAL.UpdateService(service));
}