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