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();
}
