private void updateKip(bool isNewKip)
{
if (txtMaKip.Text.Equals("") || txtTenKip.Text.Equals(""))
{
MessageBox.Show(this, "Mã, tên kíp ko hợp lệ", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
Kip kip = new Kip();
kip.maKip = txtMaKip.Text;
kip.tenKip = txtTenKip.Text;
DBKip dbKip = new DBKip();
string ret = dbKip.addNewKip(kip, isNewKip);
if (ret.Contains("duplicate key"))
{
MessageBox.Show(this, "TRUNG ID", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (ret.Length > 0)
{
MessageBox.Show(this, ret, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
dbKip.updateGridData(dGKip);
resetFeilds();
}
public IHttpActionResult Post(Kip _kip)
{
try
{
using (var db = new DB())
{
using (var transaction = db.Database.BeginTransaction())
{
Kip kip = db.Kips.FirstOrDefault(x => x.makip == _kip.makip);
if (kip != null)
{
return(BadRequest("Mã kip đã tồn tại"));
}
db.Kips.Add(_kip);
db.SaveChanges();
transaction.Commit();
return(Ok(new
{
_kip.makip,
_kip.tenkip,
_kip.trangthai,
_kip.gio,
_kip.phut
}));
}
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IHttpActionResult Detail(string _makip)
{
try
{
using (var db = new DB())
{
Kip kip = db.Kips.FirstOrDefault(x => x.makip == _makip);
if (kip == null)
{
return(BadRequest("Kip không tồn tại"));
}
return(Ok(new
{
kip.makip,
kip.tenkip,
kip.trangthai,
kip.gio,
kip.phut
}));
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IHttpActionResult Delete(string _makip)
{
try
{
using (var db = new DB())
{
using (var transaction = db.Database.BeginTransaction())
{
Kip kip = db.Kips.FirstOrDefault(x => x.makip == _makip);
if (kip == null)
{
return(BadRequest("Kip không tồn tại"));
}
kip.trangthai = (int)Constant.KHOA;
db.SaveChanges();
transaction.Commit();
return(Ok(_makip));
}
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IHttpActionResult Put(Kip _kip)
{
try
{
using (var db = new DB())
{
using (var transaction = db.Database.BeginTransaction())
{
Kip oldKip = db.Kips.FirstOrDefault(x => x.makip == _kip.makip);
if (oldKip == null)
{
return(BadRequest("Mã kip không tồn tại"));
}
oldKip.tenkip = _kip.tenkip;
oldKip.trangthai = _kip.trangthai;
oldKip.gio = _kip.gio;
oldKip.phut = _kip.phut;
db.SaveChanges();
transaction.Commit();
return(Ok(new
{
_kip.makip,
_kip.tenkip,
_kip.trangthai
}));
}
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public static void ProcessKip1(Context ctx)
{
using (var file = new FileStream(ctx.Options.InFile, FileMode.Open, FileAccess.Read))
{
var kip = new Kip(file);
kip.OpenRawFile();
}
}
public static void ProcessKip1(Context ctx)
{
using (var file = new LocalStorage(ctx.Options.InFile, FileAccess.Read))
{
var kip = new Kip(file);
kip.OpenRawFile();
}
}
public string addNewKip(Kip kip, bool isNewKip)
{
DBKetNoi.initializeInstance();
DBKetNoi dbmg = DBKetNoi.getInstance();
SqlConnection con = dbmg.openDatabase();
string newKip = "INSERT KIP (MaKip, TenKip) "
+ " VALUES (@mK, @tK)";
string updateKip = "UPDATE KIP SET MaKip = @mK, TenKip = @tK WHERE MaKip = @mK";
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
if (isNewKip)
{
cmd.CommandText = newKip;
}
else
{
cmd.CommandText = updateKip;
}
cmd.Parameters.AddWithValue("@mK", kip.maKip);
cmd.Parameters.AddWithValue("@tK", kip.tenKip);
string ret = "";
try
{
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Debug.WriteLine("The product name is " + e.Message);
ret = e.Message;
}
dbmg.closeDatabase();
return(ret);
}
