private BacSy Bindbacsy(ref BacSy bacsy, Excel.Row row)
{
//
//Bindding Cac thong tin
//
var tenbacsy = row.Cells[0] != null ? row.Cells[0].Text.Trim() : string.Empty;
if (!String.IsNullOrWhiteSpace(tenbacsy))
{
bacsy.TenBacSy = tenbacsy;
}
//
var sodienthoai = row.Cells[2] != null ? row.Cells[2].Text.Trim() : string.Empty;
if (!String.IsNullOrWhiteSpace(sodienthoai))
{
bacsy.DienThoai = sodienthoai;
}
//
var diachi = row.Cells[1] != null ? row.Cells[1].Text.Trim() : string.Empty;
if (!String.IsNullOrWhiteSpace(diachi))
{
bacsy.DiaChi = diachi;
}
//
var email = row.Cells[3] != null ? row.Cells[3].Text.Trim() : string.Empty;
if (!String.IsNullOrWhiteSpace(email))
{
bacsy.Email = email;
}
return(bacsy);
}
// [Audit]
public async Task <ActionResult> Delete(int id)
{
var maNhaThuoc = this.GetNhaThuoc().MaNhaThuoc;
BacSy bacSy =
await
unitOfWork.BacSyRespository.GetMany(e => e.MaBacSy == id && e.NhaThuoc.MaNhaThuoc == maNhaThuoc)
.FirstAsync();
if (bacSy != null)
{
try
{
unitOfWork.BacSyRespository.Delete(bacSy);
unitOfWork.Save();
}
catch (Exception e)
{
ViewBag.Message = "Không thể xóa bác sỹ: " + bacSy.TenBacSy +
"<br/> Nguyên nhân có thể là do bác sỹ đó đã được sử dụng";
ViewBag.FullMessage = e.Message;
return(View("Error"));
}
}
return(RedirectToAction("Index"));
}
// [Audit]
public async Task <ActionResult> Create([Bind(Include = "MaBacSy,TenBacSy,DiaChi,DienThoai,Email")] BacSy bacSy)
{
if (ModelState.IsValid)
{
try
{
var maNhaThuoc = this.GetNhaThuoc().MaNhaThuoc;
var itemExist = unitOfWork.BacSyRespository.Get(c => c.MaNhaThuoc == maNhaThuoc && c.TenBacSy.Trim().Equals(bacSy.TenBacSy.Trim(), StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
if (itemExist != null)
{
ModelState.AddModelError("TenBacSy", "Tên bác sỹ này đã tồn tại. Vui lòng nhập tên bác sỹ khác.");
}
else
{
bacSy.NhaThuoc = unitOfWork.NhaThuocRepository.GetById(this.GetNhaThuoc().MaNhaThuoc);
bacSy.Created = DateTime.Now;
bacSy.CreatedBy = unitOfWork.UserProfileRepository.GetById(WebSecurity.GetCurrentUserId);
unitOfWork.BacSyRespository.Insert(bacSy);
unitOfWork.Save();
return(RedirectToAction("Index"));
}
}
catch (Exception e)
{
ModelState.AddModelError("TenBacSy", e.Message);
}
}
return(View(bacSy));
}
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var maNhaThuoc = this.GetNhaThuoc().MaNhaThuoc;
BacSy bacSy =
await
unitOfWork.BacSyRespository.GetMany(e => e.MaBacSy == id && e.NhaThuoc.MaNhaThuoc == maNhaThuoc)
.FirstAsync();
if (bacSy == null)
{
return(HttpNotFound());
}
return(View(bacSy));
}
private void btnLuuThongTin_Click(object sender, EventArgs e)
{
if (tbMaBN.Text == "" || tbCMND.Text == "" || tbCMND.Text == "" || tbCMND.Text == "")
{
MessageBox.Show("Vui lòng nhập đủ thông tin !");
}
else
{
BenhNhan bn = new BenhNhan();
bn.msbn = tbMaBN.Text;
bn.scmnd = tbCMND.Text;
bn.hoten = tbHoTen.Text;
bn.diachi = tbDiaChi.Text;
KhamBenh kb = new KhamBenh();
kb.msbacsy = "REREW";
kb.msbn = tbMaBN.Text;
kb.ghichu = "";
BacSy bs = new BacSy();
bs.msbacsy = "REREW";
bs.hotenbacsy = "Quang";
db.BenhNhans.InsertOnSubmit(bn);
// db.BacSies.InsertOnSubmit(bs);
db.SubmitChanges();
db.KhamBenhs.InsertOnSubmit(kb);
db.SubmitChanges();
string message = "ok";
MessageQueueTransaction transaction = new MessageQueueTransaction();
transaction.Begin();
queue.Send(message, transaction);
transaction.Commit();
MessageBox.Show("Thêm thành công !");
}
}
//public ActionResult Upload(HttpPostedFileBase uploadFile)
//{
// var strValidations = new StringBuilder(string.Empty);
// try
// {
// if (uploadFile.ContentLength > 0)
// {
// string filePath = Path.Combine(HttpContext.Server.MapPath("../Uploads"),
// Path.GetFileName(uploadFile.FileName));
// uploadFile.SaveAs(filePath);
// var ds = new DataSet();
// //A 32-bit provider which enables the use of
// string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath +
// ";Extended Properties=Excel 12.0;";
// var maNhaThuoc = this.GetNhaThuoc().MaNhaThuoc;
// using (var conn = new OleDbConnection(connectionString))
// {
// conn.Open();
// using (var dtExcelSchema = conn.GetSchema("Tables"))
// {
// string sheetName = dtExcelSchema.Rows[0]["TABLE_NAME"].ToString();
// string query = "SELECT * FROM [" + sheetName + "]";
// var adapter = new OleDbDataAdapter(query, conn);
// //DataSet ds = new DataSet();
// adapter.Fill(ds, "Items");
// if (ds.Tables.Count > 0)
// {
// if (ds.Tables[0].Rows.Count > 0)
// {
// for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
// {
// var row = ds.Tables[0].Rows[i];
// var tenbacsy = row[0].ToString().Trim();
// var sodienthoai = row[2].ToString().Trim();
// if (!String.IsNullOrWhiteSpace(tenbacsy))
// {
// var bacsy = new BacSy();
// if (!String.IsNullOrWhiteSpace(sodienthoai))
// {
// bacsy = unitOfWork.BacSyRespository.GetMany(x => x.NhaThuoc.MaNhaThuoc == maNhaThuoc && x.TenBacSy == tenbacsy && x.DienThoai == sodienthoai).FirstOrDefault();
// }
// else
// {
// bacsy =unitOfWork.BacSyRespository.GetMany(x => x.NhaThuoc.MaNhaThuoc == maNhaThuoc && x.TenBacSy == tenbacsy).FirstOrDefault();
// }
// //Check if thuoc already exist
// if (bacsy != null)
// {
// Bindbacsy(ref bacsy, row);
// }
// else
// {
// bacsy = new BacSy()
// {
// MaBacSy = 0,
// NhaThuoc = unitOfWork.NhaThuocRepository.GetById(maNhaThuoc),
// Created = DateTime.Now,
// CreatedBy = unitOfWork.UserProfileRepository.GetById(WebSecurity.GetCurrentUserId)
// };
// unitOfWork.BacSyRespository.Insert(Bindbacsy(ref bacsy, row)) ;
// }
// }
// }
// unitOfWork.Save();
// }
// }
// }
// }
// }
// }
// catch (Exception ex)
// {
// ViewBag.Message = ex.Message;
// return View("Error");
// }
// return RedirectToAction("Index");
//}
// [Audit]
public ActionResult Upload(HttpPostedFileBase uploadFile)
{
var strValidations = new StringBuilder(string.Empty);
try
{
if (uploadFile.ContentLength > 0)
{
string filePath = Path.Combine(HttpContext.Server.MapPath("../Uploads"),
Path.GetFileName(uploadFile.FileName));
uploadFile.SaveAs(filePath);
int totalupdated = 0;
int totaladded = 0;
int totalError = 0;
string message = "<b>Thông tin bác sỹ ở dòng số {0} bị lỗi:</b><br/> {1}";
UploadObjectInfo info = new UploadObjectInfo();
var maNhaThuoc = this.GetNhaThuoc().MaNhaThuoc;
foreach (var worksheet in Workbook.Worksheets(filePath))
{
for (int i = 1; i < worksheet.Rows.Count(); i++)
{
var row = worksheet.Rows[i];
var msg = ValidateDataImport(row);
if (!string.IsNullOrEmpty(msg))
{
if (msg == Constants.Params.msgOk)
{
var tenbacsy = row.Cells[0].Text.Trim();
var sodienthoai = row.Cells[2] != null ? row.Cells[2].Text.Trim() : string.Empty;
if (!String.IsNullOrWhiteSpace(tenbacsy))
{
var bacsy = new BacSy();
if (!String.IsNullOrWhiteSpace(sodienthoai))
{
bacsy = unitOfWork.BacSyRespository.GetMany(x => x.NhaThuoc.MaNhaThuoc == maNhaThuoc && x.TenBacSy == tenbacsy && x.DienThoai == sodienthoai).FirstOrDefault();
}
else
{
bacsy = unitOfWork.BacSyRespository.GetMany(x => x.NhaThuoc.MaNhaThuoc == maNhaThuoc && x.TenBacSy == tenbacsy).FirstOrDefault();
}
//Check if thuoc already exist
if (bacsy != null)
{
Bindbacsy(ref bacsy, row);
totalupdated++;
}
else
{
bacsy = new BacSy()
{
MaBacSy = 0,
NhaThuoc = unitOfWork.NhaThuocRepository.GetById(maNhaThuoc),
Created = DateTime.Now,
CreatedBy = unitOfWork.UserProfileRepository.GetById(WebSecurity.GetCurrentUserId)
};
unitOfWork.BacSyRespository.Insert(Bindbacsy(ref bacsy, row));
totaladded++;
}
}
}
else
{
info.ErrorMsg.Add(string.Format(message, i, msg));
totalError++;
}
}
}
unitOfWork.Save();
info.Title = "Thông tin upload bác sỹ";
info.TotalUpdated = totalupdated;
info.TotalAdded = totaladded;
info.TotalError = totalError;
Session["UploadMessage"] = info;
return(RedirectToAction("index", "Upload"));
}
}
}
catch (Exception ex)
{
ViewBag.Message = "";
ViewBag.FullMessage = ex.Message;
return(View("Error"));
}
return(RedirectToAction("Index"));
}
