SqlCommand setData(SqlCommand cmd, MaKhuyenMai codesTarget) { cmd.Parameters.Add("@MaKM", SqlDbType.VarChar).Value = codesTarget.MaKM; cmd.Parameters.Add("@TiLe", SqlDbType.Float).Value = codesTarget.TiLe; cmd.Parameters.Add("@TrangThai", SqlDbType.NVarChar).Value = codesTarget.TrangThai; return(cmd); }
public MaKhuyenMai getCodes(string key) { if (connection.State == ConnectionState.Closed || connection.State == ConnectionState.Broken) { connection.Open(); } //Kiểm tra thông tin đăng nhập string cmdsql = "SELECT * FROM MaKhuyenMai Where MaKM='" + key + "' "; SqlCommand myCommand = new SqlCommand(cmdsql, connection); DataTable dataTable = new DataTable(); try { SqlDataReader sqlDataReader = myCommand.ExecuteReader(); dataTable.Load(sqlDataReader); MaKhuyenMai Target = Infrastructure.Encode.ConvertToNumberale <MaKhuyenMai>(dataTable).FirstOrDefault(); return(Target); } catch { return(null); } finally { connection.Close(); } }
public MaKhuyenMai UpdateCode(MaKhuyenMai Target) { var CodetoEdit = getCodes(Target.MaKM); _entities.Entry(CodetoEdit).CurrentValues.SetValues(Target); _entities.SaveChanges(); return(Target); }
public bool DeleteCode(MaKhuyenMai Target) { try { _repository.DeleteCode(Target); } catch { return(false); } return(true); }
public bool deleteCode(MaKhuyenMai target) { try { _codesrepository.DeleteCode(target); } catch { return(false); } return(true); }
public MaKhuyenMai UpdateCode(MaKhuyenMai Target) { var CodetoEdit = getCodes(Target.MaKM); if (!CodetoEdit.Equals(Target)) { CodetoEdit.TiLe = Target.TiLe; CodetoEdit.TrangThai = Target.TrangThai; } _entities.SaveChanges(); return(Target); }
private bool ValidateCode(MaKhuyenMai codetoValidate) { _validationDictionary.Clear(); if (codetoValidate.MaKM.Length == 0) { _validationDictionary.AddError("MaKM", "Vui lòng nhập mã khuyến mãi"); } if (codetoValidate.TiLe < 0 || codetoValidate.TiLe > 100) { _validationDictionary.AddError("TiLe", "Vui lòng nhập tỉ lệ hợp lệ"); } return(_validationDictionary.IsValid); }
public bool CreateCode(MaKhuyenMai Target) { if (!ValidateCode(Target)) { return(false); } try { _repository.CreateCode(Target); } catch { return(false); } return(true); }
public void DeleteCode(MaKhuyenMai Target) { if (connection.State == ConnectionState.Closed || connection.State == ConnectionState.Broken) { connection.Open(); } SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Delete_MaKhuyenMai"; cmd.Parameters.Add("@MaKM", SqlDbType.VarChar).Value = Target.MaKM; cmd.Connection = connection; cmd.ExecuteNonQuery(); connection.Close(); }
public MaKhuyenMai CreateCode(MaKhuyenMai Target) { if (connection.State == ConnectionState.Closed || connection.State == ConnectionState.Broken) { connection.Open(); } SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Insert_MaKhuyenMai"; cmd = setData(cmd, Target); cmd.Connection = connection; cmd.ExecuteNonQuery(); connection.Close(); return(Target); }
private void button1_Click(object sender, EventArgs e) { errProdive.Clear(); if (checkRatio()) { return; } MaKhuyenMai Target = GetCodes(); var CodetoEdit = _service.getCodes(Target.MaKM); if (CodetoEdit == null) { _service.CreateCode(Target); } else { _service.UpdateCode(Target); } View(); ViewErrors(); }
private void btnAddcode_Click(object sender, EventArgs e) { float tongtien = float.Parse(_service.getBill(txtIDBilltoDetail.Text).TongTien.ToString()); if (txtCode.Text.Length == 5) { CodeSales = _service.getCode(txtCode.Text); } else { errProdive.SetError(txtCode, "Mã nhập chưa đúng vui lòng kiểm tra lại"); } if (CodeSales == null) { errProdive.SetError(txtCode, "Mã nhập chưa đúng vui lòng kiểm tra lại"); } else { errProdive.Clear(); txtTotalPayed.Text = (tongtien - tongtien / 100 * CodeSales.TiLe).ToString(); txtPayment_TextChanged(sender, e); } }
public MaKhuyenMai CreateCode(MaKhuyenMai Target) { _entities.MaKhuyenMais.Add(Target); _entities.SaveChanges(); return(Target); }
public void DeleteCode(MaKhuyenMai Target) { _entities.MaKhuyenMais.Remove(getCodes(Target.MaKM)); _entities.SaveChanges(); }