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