private void button2_Click(object sender, EventArgs e)
{
var fullname = textBoxFullname.Text;
if (fullname == "")
{
MessageBox.Show("Hãy nhập họ tên để thêm !");
}
else
{
TacGia tg = new TacGia()
{
HoTenTG = textBoxFullname.Text,
DiaChi = textBoxAddress.Text,
TieuSu = textBoxBackground.Text,
DienThoai = textBoxPhone.Text,
};
TacGiaDao tgDao = new TacGiaDao();
var res = tgDao.insertAuthor(tg.HoTenTG, tg.DiaChi, tg.TieuSu, tg.DienThoai);
if (res > 0)
{
MessageBox.Show("Thêm tác giả thành công !");
}
bindDataToGrid();
clearAll();
}
}
public ActionResult Edit(TacGia item)
{
if (ModelState.IsValid)
{
if (item.TacGiaID == -1)
{
// add more fields not in database
item.UserModified = item.UserCreated = User.Username;
item.DateModified = item.DateCreated = DateTime.UtcNow;
TacGiaManager.Instance.CreateItem(item);
}
else
{
var existingItem = TacGiaManager.Instance.GetItem(item.TacGiaID);
existingItem.ButDanh = item.ButDanh;
existingItem.Ten = item.Ten;
existingItem.DiaChi = item.DiaChi;
existingItem.Email = item.Email;
existingItem.Phone = item.Phone;
existingItem.UserModified = User.Username;
existingItem.DateModified = DateTime.UtcNow;
TacGiaManager.Instance.UpdateItem(existingItem);
}
return(RedirectToDefaultRoute());
}
else
{
return(View(item));
}
}
public int Update(int id, string tenTacGia, string moTa, int trangThai)
{
var author = db.TacGia.Find(id);
if (author.TenTacGia.Trim().ToUpper() == tenTacGia.Trim().ToUpper())
{
author.MoTa = moTa;
author.TrangThai = trangThai;
db.SaveChanges();
return(1);
}
else
{
TacGia auth = db.TacGia.Where(c => c.TenTacGia.Trim().ToUpper() == tenTacGia.Trim().ToUpper() && c.Id != id).FirstOrDefault();
if (auth != null)
{
return(0);
}
else
{
author.TenTacGia = tenTacGia;
author.MoTa = moTa;
author.TrangThai = trangThai;
db.SaveChanges();
return(1);
}
}
}
public ActionResult Add(TacGia tacgia)
{
if (Session["User"] == null)
{
return(RedirectToAction("Login", "Login"));
}
else
{
var model = new TacGiaDao().CheckTacGia(tacgia.TenTacGia, tacgia.Email);
if (model == false)
{
ModelState.AddModelError("", "Tác Giả Này Đã Tồn Tại");
return(View("Add"));
}
else
{
if (ModelState.IsValid)
{
var dao = new TacGiaDao();
int id = dao.Insert(tacgia);
if (id > 0)
{
return(RedirectToAction("Index", "TacGiaAD"));
}
else
{
ModelState.AddModelError("", "Thêm Mới Thất Bại");
return(View("Add"));
}
}
}
return(View("Index"));
}
}
public ActionResult Edit(TacGia tacgia)
{
if (Session["User"] == null)
{
return(RedirectToAction("Login", "Login"));
}
else
{
var model = new TacGiaDao().CheckTacGia(tacgia.TenTacGia, tacgia.Email);
if (model == false)
{
ModelState.AddModelError("", "Tác Giả Này Đã Tồn Tại");
return(View("Edit"));
}
else
{
if (ModelState.IsValid)
{
var dao = new TacGiaDao();
var result = dao.Update(tacgia);
if (result)
{
return(RedirectToAction("Index", "TacGiaAD"));
}
else
{
ModelState.AddModelError("", "Cập Nhật Khách Hàng Thất Bại");
return(View("Edit"));
}
}
return(View("Index"));
}
}
}
public ActionResult ChinhSuaTacGia(int idTacGia)
{
string mainconn = ConfigurationManager.ConnectionStrings["WEBBANSACH"].ConnectionString;
SqlConnection sqlconn = new SqlConnection(mainconn);
SqlCommand sqlcomm = new SqlCommand("[dbo].[XemChiTietTacGia]");
sqlconn.Open();
sqlcomm.Connection = sqlconn;
sqlcomm.CommandType = CommandType.StoredProcedure;
SqlDataAdapter sd = new SqlDataAdapter(sqlcomm);
sqlcomm.Parameters.AddWithValue("@MaTacGia", idTacGia);
DataTable dt = new DataTable();
sd.Fill(dt);
sqlconn.Close();
TacGia xem = new TacGia();
foreach (DataRow dr in dt.Rows)
{
xem.MaTacGia = Convert.ToInt32(dr["MaTacGia"]);
xem.TenTacGia = Convert.ToString(dr["TenTacGia"]);
xem.DiaChi = Convert.ToString(dr["DiaChi"]);
xem.TieuSu = Convert.ToString(dr["TieuSu"]);
xem.SDT = Convert.ToString(dr["SDT"]);
}
return(View(xem));
}
private void buttonSave_Click(object sender, EventArgs e)
{
if (textBoxAuthorName.Text == "")
{
MessageBox.Show("Hãy nhập tên tác giả !");
}
else
{
var author = new TacGia()
{
HoTenTG = textBoxAuthorName.Text,
DiaChi = textBoxAuthorAddress.Text,
DienThoai = textBoxAuthorPhone.Text,
TieuSu = textBoxAuthorBackground.Text
};
TacGiaDao dao = new TacGiaDao();
var res = dao.insertAuthor(author.HoTenTG, author.DiaChi, author.TieuSu, author.DienThoai);
if (res > 0)
{
MessageBox.Show("Thêm thành công !");
clearAll();
}
else
{
MessageBox.Show("Chưa thêm được !");
}
}
}
/// <summary>
/// Cập nhật thông tin chu kỳ phát hành
/// Author : HoangNM - 16/03/2019 - create
/// </summary>
/// <param name="tacGia">thông tin về tác giả muốn thay đổi</param>
/// <returns>Trả về các thông tin khi cập nhật tác giả, Excetion nếu có lỗi</returns>
public ResponseInfo UpadateTacGia(TacGia tacGia, int id)
{
DbContextTransaction transaction = context.Database.BeginTransaction();
ResponseInfo response = new ResponseInfo();
try
{
context.TacGias.Where(x => x.Id == id && !x.DelFlag)
.Update(x => new TblTacGia
{
TenTacGia = tacGia.TenTacGia,
});
context.SaveChanges();
response.IsSuccess = true;
transaction.Commit();
var errorMsg = new GetErrorMsg().GetMsg((int)MessageEnum.MsgNO.CapNhatDuLieuThanhCong);
response.TypeMsgError = errorMsg.Type;
response.MsgError = errorMsg.Msg;
return(response);
}
catch (Exception e)
{
response.IsSuccess = false;
transaction.Rollback();
throw e;
}
}
/// <summary>
/// Thêm tác giả
/// Author : HoangNM - 16/03/2019 - create
/// </summary>
/// <param name="tacGia">tác giả sẽ thêm</param>
/// <returns>Trả về các thông tin khi thêm tác giả, Excetion nếu có lỗi</returns>
public ResponseInfo ThemTacGia(TacGia tacGia)
{
DbContextTransaction transaction = context.Database.BeginTransaction();
try
{
ResponseInfo response = new ResponseInfo();
int id = context.ChuKyPhatHanhs.Count() == 0 ? 1 : context.ChuKyPhatHanhs.Max(x => x.Id) + 1;
context.TacGias.Add(new TblTacGia
{
TenTacGia = tacGia.TenTacGia
});
context.SaveChanges();
response.ThongTinBoSung1 = id + "";
transaction.Commit();
var errorMsg = new GetErrorMsg().GetMsg((int)MessageEnum.MsgNO.ThemDuLieuThanhCong);
response.TypeMsgError = errorMsg.Type;
response.MsgError = errorMsg.Msg;
return(response);
}
catch (Exception e)
{
transaction.Rollback();
throw e;
}
}
private void btnThem_Click(object sender, EventArgs e)
{
/*fTacGia_Create f = new fTacGia_Create();
* this.Hide();
* f.ShowDialog();
* this.Show();*/
string maTacGia, tenTacGia, diaChi, Sdt, Email, GioiTinh, QuocTich;
maTacGia = maTGMoi;
tenTacGia = txtTenTG.Text;
diaChi = txtDiaChi.Text;
Sdt = txtSDT.Text;
Email = txtEmail.Text;
GioiTinh = cboGioiTinh.Text;
QuocTich = cboQuocTich.Text;
if (!notEmptyFields()) //neu chua nhap day du thong tin
{
MessageBox.Show("Vui lòng điền đầy đủ thông tin", "Waring", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
TacGia TG = new TacGia(maTacGia, tenTacGia, diaChi, Sdt, Email, GioiTinh, QuocTich);
if (!handler.themTacGia(TG)) //Neu them khong thanh cong
{
MessageBox.Show("Mã lĩnh vực đã tồn tại: " + maTacGia, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else //Thanh cong
{
MessageBox.Show("Sucessfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
show(); //load lai table
txtMaTG.Focus(); //set focus
}
}
}
protected void grvTacGiaa_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName != "Page")
{
GridViewRow gvr;
gvr = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
int index = gvr.RowIndex;
if (e.CommandName == "Sua")
{
GridViewRow gvrow = grvTacGia.Rows[index];
typemodal.Value = "TG";
editType.Value = "edit"; //đoạn này
hdId.Value = grvTacGia.DataKeys[index].Value.ToString();
TacGia tg = tgbll.LayTacGia(hdId.Value);
txtTen.Text = tg.HoTenTacGia;
txtMoTa.Text = tg.MoTa;
}
else
if (e.CommandName == "Xoa")
{
GridViewRow gvrow = grvTacGia.Rows[index];
string id = HttpUtility.HtmlDecode(gvrow.Cells[0].Text).ToString();
editType.Value = "edit";
idDelete.Value = id;
Delete.Value = "TG";
LoadTG();
tgbll.Xoa(id);
typemodal.Value = "hide";
LoadTG();
}
}
}
//Xóa tác giả
public bool XoaAuthor(TacGia tg)
{
con1 = con.getConnection();
try
{
con1.Open();
string SQL = string.Format("DELETE FROM TacGia WHERE MaTG =@MaTG");
SqlCommand cmd = new SqlCommand(SQL, con1);
cmd.Parameters.AddWithValue("@MaTG", tg.maTG);
cmd.Parameters.AddWithValue("@TenTG", tg.tenTG);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception)
{
}
finally
{
con1.Close();
}
return(false);
}
//thêm tác giả
public bool themAuthor(TacGia tg)
{
con1 = con.getConnection();
try
{
con1.Open();
string SQL = string.Format("insert into TacGia values(@MaTG, @TenTG)");
SqlCommand cmd = new SqlCommand(SQL, con1);
cmd.Parameters.AddWithValue("@MaTG", tg.maTG);
cmd.Parameters.AddWithValue("@TenTG", tg.tenTG);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception)
{
}
finally
{
// Dong ket noi
con1.Close();
}
return(false);
}
public TacGia GetData(String ma)
{
TacGia tg = new TacGia();
cmd.CommandText = String.Format("Select * from TacGia where MaTG = '{0}' ", ma);
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.OpenConn();
SqlDataReader reader = cmd.ExecuteReader();
int ordMaNV = reader.GetOrdinal("MaTG");
int ordTenNV = reader.GetOrdinal("TenTG");
int ordDiaChi = reader.GetOrdinal("DiaChi");
int ordSDT = reader.GetOrdinal("SDT");
while (reader.Read())
{
tg.MaTG = reader.GetString(ordMaNV);
tg.TenTG = reader.GetString(ordTenNV);
tg.DiaChi = reader.GetString(ordDiaChi);
tg.SDT1 = reader.GetInt32(ordSDT);
}
reader.Close();
con.CloseConn();
}
catch (Exception ex)
{
string mex = ex.ToString();
cmd.Dispose();
con.CloseConn();
}
return(tg);
}
public List <TacGia> getTacGia()
{
string sql = "SELECT * FROM TacGia";
string id, name, text;
List <TacGia> list = new List <TacGia>();
Connect();
try
{
SqlDataReader dr = myExecuteReader(sql);
while (dr.Read())
{
id = dr[0].ToString();
name = dr[1].ToString();
text = dr[2].ToString();
TacGia tg = new TacGia(id, name, text);
list.Add(tg);
}
dr.Close();
return(list);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
Disconnect();
}
}
public IHttpActionResult PutTacGia(string id, TacGia tacGia)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tacGia.IDTacGia)
{
return(BadRequest());
}
db.Entry(tacGia).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!TacGiaExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
private void dgvTacGia_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
var senderGrid = (DataGridView)sender;
if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn && e.RowIndex >= 0)
{
string id = txtIDTacGia.Text;
string name = txtTenTG.Text;
string text = txtGhiChu.Text;
TacGia tg = new TacGia(id, name, text);
bool b = new TacGiaBUS().DeleteTG(tg);
if (b)
{
MessageBox.Show("Xóa Thành Công");
}
Init();
}
}
catch (SqlException ex)
{
MessageBox.Show("Xóa thất bại", ex.Message, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public IHttpActionResult PostTacGia(TacGia tacGia)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.TacGias.Add(tacGia);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (TacGiaExists(tacGia.IDTacGia))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = tacGia.IDTacGia }, tacGia));
}
public ActionResult ChinhSuaTacGia(FormCollection f, int idTacGia, TacGia tacGia)
{
string sTenTacGia = f.Get("TenTacGia").ToString();
string sDiaChi = f["DiaChi"].ToString();
string sSDT = f["SDT"].ToString();
string sTieuSu = f["TieuSu"].ToString();
string mainconn = ConfigurationManager.ConnectionStrings["WEBBANSACH"].ConnectionString;
SqlConnection sqlconn = new SqlConnection(mainconn);
SqlCommand sqlcomm = new SqlCommand("[dbo].[ChinhSuaTacGia]");
sqlconn.Open();
sqlcomm.Connection = sqlconn;
sqlcomm.CommandType = CommandType.StoredProcedure;
sqlcomm.Parameters.AddWithValue("@MaTacGia", idTacGia);
sqlcomm.Parameters.AddWithValue("@TenTacGia", sTenTacGia);
sqlcomm.Parameters.AddWithValue("@DiaChi", sDiaChi);
sqlcomm.Parameters.AddWithValue("@TieuSu", sTieuSu);
sqlcomm.Parameters.AddWithValue("@SDT", sSDT);
SqlDataReader sdr = sqlcomm.ExecuteReader();
return(RedirectToAction("XemTacGia", "Admin"));
}
public bool suaTacGia(TacGia TG)
{
doc = new XmlDocument(); //Tao moi 1 doi tuong XmlDocument
doc.Load(fileName); //Ltoad file xml theo duong dan
list = new List <TacGia>();
loadDataFromDoc(doc, fileName, list);
if (!isExistId(list, TG.MaTacGia)) //Kiem tra ma co ton tai hay khong
{
return(false); //Neu khong tra ve false
}
XmlNodeList tgNode = doc.GetElementsByTagName("TacGia"); //Lay danh sach cac nut linh vuc tu tai lieu
foreach (XmlNode node in tgNode)
{
string maTacGia = node.ChildNodes[0].InnerText; //Lay ra MaLinhVuc cua nut LinhVuc hien tai
if (maTacGia == TG.MaTacGia) //Neu MaLinhVuc cua nut hien tai trung voi MaLinhVuc can sua
{
//Thuc hien sua doi thong tin cua nut nay
node.ChildNodes[0].InnerText = TG.MaTacGia;
node.ChildNodes[1].InnerText = TG.TenTacGia;
node.ChildNodes[2].InnerText = TG.DiaChi;
node.ChildNodes[3].InnerText = TG.Sdt;
node.ChildNodes[4].InnerText = TG.Email;
node.ChildNodes[5].InnerText = TG.GioiTinh;
node.ChildNodes[6].InnerText = TG.QuocTich;
break;
}
}
doc.Save(fileName); // Sau khi sua luu lai file
return(true); //tra ve true khi sua thanh cong
}
public ActionResult Add(TacGia tg)
{
KhachHang kh = new KhachHang();
kh = Session["KhachHang"] as KhachHang;
if (kh == null)
{
return(RedirectToAction("Index", "DangNhap"));
}
else if (kh.LoaiKH == "Khách Hàng")
{
return(RedirectToAction("Index", "Home"));
}
else
{
using (var db = new BookContext())
{
Log log = new Log();
log.TacVu = "Admin";
log.TaiKhoan = kh.TaiKhoan;
log.ThoiGian = DateTime.Now;
log.HanhDong = "Đã thêm tác giả có tên " + tg.TenTacGia;
db.Log.Add(log);
TacGia tacGia = new TacGia();
tacGia.TenTacGia = tg.TenTacGia;
db.TacGia.Add(tg);
db.SaveChanges();
Session["ListTG"] = db.TacGia.Where(i => i.flag == false).ToList();
return(RedirectToAction("Index", "TacGia"));
}
}
}
public ActionResult Update(TacGia tg)
{
KhachHang kh = new KhachHang();
kh = Session["KhachHang"] as KhachHang;
if (kh == null)
{
return(RedirectToAction("Index", "DangNhap"));
}
else if (kh.LoaiKH == "Khách Hàng")
{
return(RedirectToAction("Index", "Home"));
}
else
{
TacGia tacGia = db.TacGia.Find((Session["TG"] as TacGia).MaTacGia);
if (tacGia.TenTacGia != tg.TenTacGia)
{
Log log = new Log();
log.TacVu = "Admin";
log.TaiKhoan = kh.TaiKhoan;
log.ThoiGian = DateTime.Now;
log.HanhDong = "Đã cập nhật tác giả có tên " + tacGia.TenTacGia + " thành " + tg.TenTacGia;
db.Log.Add(log);
}
tacGia.TenTacGia = tg.TenTacGia;
db.SaveChanges();
return(RedirectToAction("Index", "TacGia"));
}
}
public ActionResult Index(TacGia tg, string moTa, HttpPostedFileBase file)
{
var tk = Session["TaiKhoan"] as KhachHang;
if (tk == null)
{
return(View("../Login/Index"));
}
else
{
if (tk.LoaiTK != "Admin")
{
return(View("../Home/Index"));
}
else
{
if (Session["UpdateTG"] == null)
{
var db = new TacGiaDAO();
db.InsertTG(tg, moTa, file);
Session["ListTG"] = null;
return(RedirectToAction("Reset", "TacGia", new { area = "Admin" }));
}
else
{
var db = new TacGiaDAO();
var tg1 = Session["UpdateTG"] as TacGia;
db.UpdateTG(tg1.IdTacGia, tg, moTa, file);
Session["UpdateTG"] = null;
Session["ListTG"] = null;
return(RedirectToAction("Reset", "TacGia", new { area = "Admin" }));
}
}
}
}
public async Task <IActionResult> Edit(int id, TacGia tacGia)
{
if (id != tacGia.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_db.Update(tacGia);
await _db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TacGiaExists(tacGia.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(tacGia));
}
private void cbbMaTG_TextChanged(object sender, EventArgs e)
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
bool tmt = false;
var ListMaTG = from kq in qltv.TacGias select kq.MaTacGia;
foreach (var item in ListMaTG)
{
if (cbbMaTG.Text == item)
{
tmt = true;
}
}
if (tmt == true)
{
TacGia TG = qltv.TacGias.Where(p => p.MaTacGia == cbbMaTG.Text).SingleOrDefault();
var ViTri = from kq in qltv.SangTacs where kq.MaDauSach == QuanLyDauSach.MaDS && kq.MaTacGia == cbbMaTG.Text select kq.ViTriVaiTro;
txbTenTG.Text = TG.TenTacGia;
dTP_NgaySinhTG.Text = TG.NgaySinh.ToString();
txbViTriVaiTro.Text = "";
dTP_NgaySinhTG.Enabled = false;
txbTenTG.Enabled = false;
}
else
{
txbTenTG.Enabled = true;
dTP_NgaySinhTG.Enabled = true;
txbTenTG.Text = "";
txbViTriVaiTro.Text = "";
dTP_NgaySinhTG.Value = DateTime.Now;
}
}
}
/// <summary>
/// thêm thông tin tác giả vào database
/// </summary>
public static void AddTacGia(TacGia TacGia)
{
using (var db = new LiteDatabase(DatabaseConnectionString))
{
db.GetCollection <TacGia>("TacGia").Insert(TacGia);
}
}
public ResponseInfo UpdateTacGia(TacGia data, int id)
{
ResponseInfo response = new ResponseInfo();
var kt = Convert.ToInt64(new GetPermission().GetQuyen("AUTHOR_UPD")) & Convert.ToInt64(Common.Common.GetTongQuyen());
if (kt != 0)
{
try
{
response = new QuanLyTacGiaModel().UpadateTacGia(data, id);
}
catch (Exception e)
{
response.Code = (int)ConstantsEnum.CodeResponse.ServerError;
var errorMsg = new GetErrorMsg().GetMsg((int)MessageEnum.MsgNO.ServerError);
response.TypeMsgError = errorMsg.Type;
response.MsgError = errorMsg.Msg;
response.ThongTinBoSung1 = e.Message;
}
}
else
{
var errorMsg = new GetErrorMsg().GetMsg((int)MessageEnum.MsgNO.BanKhongDuQuyen);
response.TypeMsgError = errorMsg.Type;
response.MsgError = errorMsg.Msg;
}
return(response);
}
public ActionResult DeleteConfirmed(int id)
{
TacGia tacGia = db.TacGia.Find(id);
db.TacGia.Remove(tacGia);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public string Insert(TacGia author)
{
{
db.TacGias.Add(author);
db.SaveChanges();
return(author.MaTacGia);
}
}
public TacGia LayTGTheoMa(string maTacGia)
{
using (QLThuVienEntities ThuVienDS = new QLThuVienEntities())
{
TacGia tacGia = ThuVienDS.TacGias.Find(maTacGia);
return(tacGia);
}
}
