public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } insurance insurance = db.insurances.Find(id); if (insurance == null) { return(HttpNotFound()); } ViewBag.gender = new SelectList(db.Tables, "gender", "gender"); var alist = this.db.master_file.OrderBy(e => e.employee_no).ToList(); var afinallist = new List <master_file>(); foreach (var file in alist) { if (afinallist.Count == 0) { afinallist.Add(file); } if (!afinallist.Exists(x => x.employee_no == file.employee_no)) { afinallist.Add(file); } } this.ViewBag.employee_no = new SelectList(afinallist, "employee_id", "employee_no"); ViewBag.employee_no1 = new SelectList(afinallist.OrderBy(e => e.employee_name), "employee_id", "employee_name"); return(View(insurance)); }
public ActionResult DeleteConfirmed(int id) { insurance insurance = db.insurances.Find(id); db.insurances.Remove(insurance); db.SaveChanges(); return(RedirectToAction("Index")); }
public IActionResult Create(insurance insurance, IFormFile image, string returnUrl = null) { if (ModelState.IsValid) { repository.AddEntity(insurance, image); return(RedirectToLocal(returnUrl)); } ViewData["ReturnUrl"] = returnUrl; return(View(insurance)); }
private void ImportPatients() { List <string> data = File.ReadLines(@"F:\ЯндексДиск\работяга\Четвёртый курс\Второй семак\WSR\WSR_Laboratory\ImportData\patients.txt").ToList(); data.ForEach((item) => { string[] itemData = item.Split('\t'); string InsuranceName = itemData[14]; string InsuranceAddress = itemData[15]; insurance insurance = Laboratory.GetContext().insurance.Where(p => p.name == InsuranceName && p.address == InsuranceAddress).FirstOrDefault(); if (insurance == null) { insurance = new insurance(); insurance.name = itemData[14]; insurance.address = itemData[15]; insurance.inn = decimal.Parse(itemData[16]); insurance.payment_account = decimal.Parse(itemData[18]); insurance.bik = decimal.Parse(itemData[19]); Laboratory.GetContext().insurance.Add(insurance); Laboratory.GetContext().SaveChanges(); } user user = new user(); user.login = itemData[1]; user.password = itemData[2]; user.id_user_type = 5; Laboratory.GetContext().user.Add(user); patient patient = new patient(); patient.full_name = itemData[0]; patient.email = itemData[4]; patient.social_number = decimal.Parse(itemData[5]); patient.ein = itemData[6]; patient.social_type = itemData[7] == "oms"; patient.phone = itemData[8]; patient.passport_series = decimal.Parse(itemData[9]); patient.passport_number = decimal.Parse(itemData[10]); patient.birthday = DateTimeOffset.FromUnixTimeMilliseconds(long.Parse(itemData[11].Replace("-", ""))).DateTime; patient.country = itemData[13]; patient.user = user; patient.insurance = insurance; Laboratory.GetContext().patient.Add(patient); history history = new history(); history.user = user; history.ip = itemData[17]; history.login = user.login; history.has_entered = true; history.date_time = DateTime.Now; Laboratory.GetContext().history.Add(history); }); Laboratory.GetContext().SaveChanges(); }
public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } insurance insurance = db.insurances.Find(id); if (insurance == null) { return(HttpNotFound()); } return(View(insurance)); }
public IActionResult Edit(int id, insurance insurance, IFormFile image, string returnUrl = null) { if (id != insurance.id) { return(NotFound()); } if (ModelState.IsValid) { this.repository.UpdateEntity(insurance, image); return(RedirectToLocal(returnUrl)); } ViewData["ReturnUrl"] = returnUrl; return(View(insurance)); }
public ActionResult ImportIncl() { if (this.Request.Files["FileUpload1"].ContentLength > 0) { var extension = Path.GetExtension(this.Request.Files["FileUpload1"].FileName).ToLower(); string query = null; var connString = string.Empty; string[] validFileTypes = { ".csv" }; var path1 = string.Format( "{0}/{1}", this.Server.MapPath("~/Content/Uploads"), this.Request.Files["FileUpload1"].FileName); if (!Directory.Exists(path1)) { Directory.CreateDirectory(this.Server.MapPath("~/Content/Uploads")); } var alist = this.db.master_file.OrderBy(e => e.employee_no).ThenByDescending(x => x.date_changed) .ToList(); var afinallist = new List <master_file>(); foreach (var file in alist) { if (afinallist.Count == 0) { afinallist.Add(file); } if (!afinallist.Exists(x => x.employee_no == file.employee_no)) { afinallist.Add(file); } } if (validFileTypes.Contains(extension)) { if (System.IO.File.Exists(path1)) { System.IO.File.Delete(path1); } this.Request.Files["FileUpload1"].SaveAs(path1); if (extension == ".csv") { var dt = Utility.ConvertCSVtoDataTable(path1); this.ViewBag.Data = dt; if (dt.Rows.Count > 0) { var leavecheck = this.db.contracts.ToList(); var pro = new insurance(); foreach (DataRow dr in dt.Rows) { foreach (DataColumn column in dt.Columns) { if (dr[column] == null || dr[column].ToString() == " ") { goto e; } if (column.ColumnName == "Card no") { var dtt = dr[column].ToString(); int.TryParse(dtt, out var a); pro.card_no = a; } if (column.ColumnName == "Dependency") { var dtt = dr[column].ToString(); pro.dependency = dtt; } if (column.ColumnName == "Marital Status") { var dtt = dr[column].ToString(); pro.marital_status = dtt; } if (column.ColumnName == "Annual Primium") { var dtt = dr[column].ToString(); int.TryParse(dtt, out var a); pro.annual_primium = a; } if (column.ColumnName == "Invoice No") { var dtt = dr[column].ToString(); int.TryParse(dtt, out var a); pro.invoice_no = a; } if (column.ColumnName == "Credit Amt") { var dtt = dr[column].ToString(); int.TryParse(dtt, out var a); pro.credit_amt = a; } if (column.ColumnName == "Deletion Date") { var dtt = dr[column].ToString(); DateTime.TryParse(dtt, out var a); pro.deletion_date = a; } if (column.ColumnName == "employee_no") { int.TryParse(dr[column].ToString(), out var idm); if (idm != 0) { var epid = afinallist.Find(x => x.employee_no == idm); if (epid == null) { goto e; } pro.employee_no = epid.employee_id; var dob = epid.dob.Value; var age = 0; age = DateTime.Now.DayOfYear - dob.Year; if (DateTime.Now.DayOfYear < dob.DayOfYear) { age = age - 1; } pro.age = age; } } } this.db.insurances.Add(pro); this.db.SaveChanges(); e :; } } } } } else { this.ViewBag.Error = "Please Upload Files in .csv format"; } return(this.View()); }
public ActionResult Edit([Bind(Include = "id,employee_no,card_no,dob,age,gender,dependency,marital_status,nationality,eid_no,pasport_no,uid_no,emitae_visa_issue,annual_primium,deletion_date,invoice_no,credit_amt")] insurance insurance, HttpPostedFileBase fileBase) { string serverfile; if (fileBase != null) { var a = db.master_file.Find(insurance.employee_no); var imgname = System.IO.Path.GetFileName(fileBase.FileName); var fileexe = System.IO.Path.GetExtension(fileBase.FileName); DirectoryInfo filepath = new DirectoryInfo("D:/HR/img/insurance/" + fileexe); serverfile = "D:/HR/img/insurance/" + a.employee_no;/*+ "/"+ passport.employee_no + fileexe;*/ filepath = Directory.CreateDirectory(serverfile); int i = 0; do { serverfile = "D:/HR/img/insurance/" + a.employee_no + "/" + a.employee_no + "_" + i + fileexe; i++; } while (System.IO.File.Exists(serverfile = "D:/HR/img/insurance/" + a.employee_no + "/" + a.employee_no + "_" + i + fileexe)); fileBase.SaveAs(serverfile); } else { serverfile = null; } if (ModelState.IsValid) { var img = new insurance(); img.employee_no = insurance.employee_no; img.card_no = insurance.card_no; img.age = insurance.age; img.dependency = insurance.dependency; img.marital_status = insurance.marital_status; img.annual_primium = insurance.annual_primium; img.deletion_date = insurance.deletion_date; img.invoice_no = insurance.invoice_no; img.credit_amt = insurance.credit_amt; img.imgpath = serverfile; db.insurances.Add(img); img.changed_by = User.Identity.Name; img.date_changed = DateTime.Now; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.gender = new SelectList(db.Tables, "gender", "gender"); var alist = this.db.master_file.OrderBy(e => e.employee_no).ToList(); var afinallist = new List <master_file>(); foreach (var file in alist) { if (afinallist.Count == 0) { afinallist.Add(file); } if (!afinallist.Exists(x => x.employee_no == file.employee_no)) { afinallist.Add(file); } } this.ViewBag.employee_no = new SelectList(afinallist, "employee_id", "employee_no"); ViewBag.employee_no1 = new SelectList(afinallist.OrderBy(e => e.employee_name), "employee_id", "employee_name"); return(View(insurance)); }