internal void Addperson(salary student)
{
string cs = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
using (SqlConnection conn = new SqlConnection(cs))
{
using (SqlCommand cmd = new SqlCommand("adddata", conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
conn.Open();
cmd.Parameters.AddWithValue("@name", student.name);
cmd.Parameters.AddWithValue("@employerid", student.employerid);
cmd.Parameters.AddWithValue("@title", student.title);
cmd.Parameters.AddWithValue("@depart", student.depart);
cmd.Parameters.AddWithValue("@accno", student.accno);
cmd.Parameters.AddWithValue("@basicsalary", student.basicsalary);
cmd.Parameters.AddWithValue("@mealallow", student.mealallow);
cmd.Parameters.AddWithValue("@transportallow", student.transportallow);
cmd.Parameters.AddWithValue("@medicalallow", student.medicalallow);
cmd.Parameters.AddWithValue("@tax", student.tax);
cmd.Parameters.AddWithValue("@total", student.total);
cmd.ExecuteNonQuery();
}
}
}
public IActionResult stdlog(salary salary)
{
var test = _context.salary;
var m = new List <salary>();
var i = _context.salary.Where(x => x.id == salary.id && x.name == salary.name).FirstOrDefault();
if (i == null)
{
ViewBag.Login = "******";
}
else
{
ViewBag.Login = "******";
var s = new salary();
s.date = i.date;
s.monthly = i.monthly;
s.monthly = i.monthly;
s.rent = i.rent;
s.bonus = i.bonus;
s.hospital = i.hospital;
s.recieved = i.recieved;
m.Add(s);
return(View("facultydetails", m));
}
return(View());
}
public async Task <IActionResult> salary(salary model)
{
if (ModelState.IsValid)
{
salary lcl_salary = new salary
{
id = model.id,
name = model.name,
date = model.date,
monthly = model.monthly,
rent = model.rent,
bonus = model.bonus,
hospital = model.hospital,
recieved = model.recieved,
};
_context.salary.Add(lcl_salary);
await _context.SaveChangesAsync();
ViewBag.Success = "Data has been successfully saved";
return(View());
}
return(View(model));
}
static void Main(string[] args)
{
// methods
Console.WriteLine(" welcome to the stuff payroll system");
Console.WriteLine("press enter to display salary");
Console.WriteLine("press enter again to display wages");
Console.Write("please enter the button");
int button = int.Parse(Console.ReadLine());
{
//salary class//
salary s1 = new salary();
Console.WriteLine($"your per week salary ${Math.Round(s1.DisplaySalary(), 2)}");
//2 lines//
Console.WriteLine("");
Console.WriteLine("");
}
// wages class//
wages w1 = new wages();
Console.Write("please enter the working hours");
int hours = int.Parse(Console.ReadLine());
Console.WriteLine($"Wages per week ${Math.Round(w1.Displaywages(), 2)}");
Console.ReadLine();
}
public ActionResult update(int id)
{
salaryViewModel studentVM = new salaryViewModel();
salary student = studentVM.print(id);
return(View(student));
}
internal salary print(int id)
{
salary student = new salary();
string cs = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
using (SqlConnection conn = new SqlConnection(cs))
{
using (SqlCommand cmd = new SqlCommand("printdetail", conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
conn.Open();
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
student.id = Convert.ToInt32(reader["id"]);
student.name = reader["Name"].ToString();
student.employerid = reader["employerid"].ToString();
student.title = reader["title"].ToString();
student.depart = reader["depart"].ToString();
student.accno = reader["accno"].ToString();
student.basicsalary = Convert.ToInt32(reader["basicsalary"]);
student.mealallow = Convert.ToInt32(reader["mealallow"]);
student.transportallow = Convert.ToInt32(reader["transportallow"]);
student.medicalallow = Convert.ToInt32(reader["medicalallow"]);
student.tax = Convert.ToInt32(reader["tax"]);
student.total = Convert.ToInt32(reader["medicalallow"]) + Convert.ToInt32(reader["transportallow"]) + Convert.ToInt32(reader["mealallow"]) + Convert.ToInt32(reader["basicsalary"]) - Convert.ToInt32(reader["tax"]);
}
}
return(student);
}
public ActionResult DeleteConfirmed(int id)
{
salary salary = db.salaries.Find(id);
db.salaries.Remove(salary);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void materialButton1_Click(object sender, EventArgs e)
{
using (HamroSuperMarketEntities db = new HamroSuperMarketEntities())
{
salary sal = db.salaries.Where(o => o.id == id).First();
db.Entry(sal).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
public ActionResult Create(salary student)
{
if (ModelState.IsValid)
{
salaryViewModel studentVM = new salaryViewModel();
studentVM.Addperson(student);
return(RedirectToAction("Index"));
}
return(View());
}
public async Task Handle(EmployeePermanentCreatedIntegrationEvent @event)
{
using (LogContext.PushProperty("IntegrationEventContext", $"{@event.Id}-{Program.AppName}"))
{
// _logger.LogInformation("----- Handling integration event: {IntegrationEventId} at {AppName} - ({@IntegrationEvent})", @event.Id, Program.AppName, @event);
var empsalary = new salary(@event.EmpId, 1000.00);
_repository.Add(empsalary);
await _repository.UnitOfWork
.SaveEntitiesAsync();
}
}
static void Main(string[] args)
{
salary s1 = new salary();
s1.AnnualSalary = 80000;
Console.WriteLine($"Your salary is se tat {s1.AnnualSalary}");
Console.WriteLine($"your salary per weekis {s1.DispalySalary()}");
Console.WriteLine("");
Console.WriteLine("i will calculate your wages");
Console.WriteLine("enter a number of hour work:");
int hour = int.Parse(Console.ReadLine());
}
private void SaveSalaryData(object sender, RoutedEventArgs e)
{
try
{
salary uSalary = dbContext.salary.SingleOrDefault(k => k.employeeID == selectedPersonID);
if (uSalary != null)
{
uSalary.baseSalary = Convert.ToDecimal(string.IsNullOrEmpty(baseSalary.Text) ? "0" : baseSalary.Text);
uSalary.dosentBase = Convert.ToDecimal(string.IsNullOrEmpty(dosentBase.Text) ? "0" : dosentBase.Text);
uSalary.professorBase = Convert.ToDecimal(string.IsNullOrEmpty(professorBase.Text) ? "0" : professorBase.Text);
uSalary.academicBase = Convert.ToDecimal(string.IsNullOrEmpty(academicBase.Text) ? "0" : academicBase.Text);
uSalary.scientceDoctorBase = Convert.ToDecimal(string.IsNullOrEmpty(scientceDoctorBase.Text) ? "0" : scientceDoctorBase.Text);
uSalary.scienceCandadateBase = Convert.ToDecimal(string.IsNullOrEmpty(scienceCandidateBase.Text) ? "0" : scienceCandidateBase.Text);
uSalary.dosentPercent = Convert.ToDecimal(string.IsNullOrEmpty(dosentPercent.Text) ? "0" : dosentPercent.Text);
uSalary.professorPercent = Convert.ToDecimal(string.IsNullOrEmpty(professorPercent.Text) ? "0" : professorPercent.Text);
uSalary.academicPercent = Convert.ToDecimal(string.IsNullOrEmpty(academicPercent.Text) ? "0" : academicPercent.Text);
uSalary.scientceDoctorPercent = Convert.ToDecimal(string.IsNullOrEmpty(scientceDoctorPercent.Text) ? "0" : scientceDoctorPercent.Text);
uSalary.scienceCandadatePercent = Convert.ToDecimal(string.IsNullOrEmpty(scienceCandadatePercent.Text) ? "0" : scienceCandadatePercent.Text);
//uSalary.employeeID = selectedPersonID;
}
else
{
salary eSalary = new salary();
eSalary.baseSalary = Convert.ToDecimal(string.IsNullOrEmpty(baseSalary.Text) ? "0" : baseSalary.Text);
eSalary.dosentBase = Convert.ToDecimal(string.IsNullOrEmpty(dosentBase.Text) ? "0" : dosentBase.Text);
eSalary.professorBase = Convert.ToDecimal(string.IsNullOrEmpty(professorBase.Text) ? "0" : professorBase.Text);
eSalary.academicBase = Convert.ToDecimal(string.IsNullOrEmpty(academicBase.Text) ? "0" : academicBase.Text);
eSalary.scientceDoctorBase = Convert.ToDecimal(string.IsNullOrEmpty(scientceDoctorBase.Text) ? "0" : scientceDoctorBase.Text);
eSalary.scienceCandadateBase = Convert.ToDecimal(string.IsNullOrEmpty(scienceCandidateBase.Text) ? "0" : scienceCandidateBase.Text);
eSalary.employeeID = selectedPersonID;
dbContext.salary.Add(eSalary);
}
dbContext.SaveChanges();
// txtStatus.Text = rOrganization.organizationName + " has being added!";
}
catch (DbUpdateException ex)
{
MessageBox.Show("Problem yarandı" + ex.ToString());
}
finally
{
MessageBox.Show("Melumatlar saxlanıldı");
}
}
public ActionResult Edit([Bind(Include = "Salary_Id,Employee_Id,Salary_Amount,Advance_Cut,Total_Pay,Salary_Date")] salary salary)
{
if (ModelState.IsValid)
{
db.Entry(salary).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Employee_Id = new SelectList(db.employees, "Employee_Id", "Employee_Name", salary.Employee_Id);
return(View(salary));
}
private bool updateSalaryDetailFilePath(string salaryId, string salaryDetailFilePath, sys_employeeEntities db)
{
var query = (from s in db.salary
where s.salaryId == salaryId
select s).First();
salary salary = (salary)query;
salary.salaryDetailFilePath = salaryDetailFilePath;
db.SaveChanges();
return(false);
}
public ActionResult addBonus(int user_id, int count, int ded, int bonus, int salary, DateTime da)
{
salary s = new salary();
s.eid = user_id;
s.bonus = bonus;
s.deduction = ded;
s.days = count;
s.month = da.Date;
db.salaries.Add(s);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: salaries/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
salary salary = db.salaries.Find(id);
if (salary == null)
{
return(HttpNotFound());
}
return(View(salary));
}
// GET: salaries/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
salary salary = db.salaries.Find(id);
if (salary == null)
{
return(HttpNotFound());
}
ViewBag.Employee_Id = new SelectList(db.employees, "Employee_Id", "Employee_Name", salary.Employee_Id);
return(View(salary));
}
public void AddSalary(int employee_no, int employee_salary, string from_date, string to_date)
{
salary sal = new salary();
sal.emp_no = employee_no;
sal.salary1 = employee_salary;
sal.from_date = from_date;
sal.to_date = to_date;
var db = new newdataEntities();
db.salaries.Add(sal);
db.SaveChanges();
db.Dispose();
}
private bool addSalaryDetailFilePath(string employeeId, string salaryMonth, string salaryDetailFilePath, sys_employeeEntities db)
{
string salaryId = string.Format("{0}{1}", employeeId, salaryMonth.Substring(0, 7).Replace("/", ""));
salary salary = new salary();
salary.salaryId = salaryId;
salary.employeeId = employeeId;
salary.paymentDate = string.Format("{0}/{1}", salaryMonth.Substring(0, 7), "15");
salary.salaryDetailFilePath = salaryDetailFilePath;//fileName.Substring(fileName.IndexOf(ConstantCommon.SALARYFOLDERPATH));
salary.description = "";
db.salary.Add(salary);
db.SaveChanges();
return(false);
}
public async Task <IHttpActionResult> Deleteemployee(int id)
{
employee employee = await db.employees.FindAsync(id);
if (employee == null)
{
return(NotFound());
}
salary salary_move = await(db.salaries.Where(u => u.employee_id == employee.employee_id).FirstOrDefaultAsync <salary>());;
await db.Database.ExecuteSqlCommandAsync("Delete from salaries where employee_id=" + employee.employee_id);
db.employees.Remove(employee);
await db.SaveChangesAsync();
return(Ok(employee));
}
private void label2_Click(object sender, EventArgs e)
{
if (nepaliCalender1From.engdate > nepaliCalender2To.engdate)
{
var notification = new RetailControls.NotificationMAnager();
notification.show("beging date can not be bigger then finising date", 2000);
return;
}
if (Amountofsalary.Text.Trim() == "")
{
var notification = new RetailControls.NotificationMAnager();
notification.show("please enter the amout", 2000);
return;
}
if (!(Convert.ToDecimal(Amountofsalary.Text) > 0))
{
var notification = new RetailControls.NotificationMAnager();
notification.show("enter the salary'amount in positive value", 2000);
return;
}
try
{
salary sal = new salary();
sal.employee_id = this.id;
sal.form = nepaliCalender1From.engdate;
sal.toto = nepaliCalender2To.engdate;
sal.amount = Convert.ToDecimal(Amountofsalary.Text);
sal.dates = Dashboard.Instance.nepaliCalender1.engdate;
sal.day = nepaliCalender1From.DATESTAMP;
sal.today = nepaliCalender2To.DATESTAMP;
db.salaries.Add(sal);
db.SaveChanges();
var notification = new RetailControls.NotificationMAnager();
notification.show("Salary Added for " + this.name, 2000);
this.Dispose();
}
catch (Exception ex)
{
var notification = new RetailControls.NotificationMAnager();
notification.show("please enter the correct value" + this.name, 2000);
}
}
public ActionResult Index(salary s)
{
if (s.basic > 30000)
{
s.deduction = s.basic * (5.0 / 100);
}
else if (s.basic > 15000)
{
s.deduction = s.basic * (2.0 / 100);
}
else
{
s.deduction = 0;
}
s.otpay = s.othours * s.otrate;
s.netsal = s.basic + s.bonus + s.otpay - s.deduction;
//s.netsal = s.basic + s.bonus +( s.othours* s.otrate) - s.deduction;
return(View(s));
}
public IActionResult Index(salary pay)
{
if (pay.sal > 50000)
{
pay.tax = pay.sal * 10 / 100;
}
else if (pay.sal > 30000)
{
pay.tax = pay.sal * 5 / 100;
}
else
{
pay.tax = 0;
}
pay.net = pay.sal - pay.tax;
return(View(pay));
}
public List <salary> personDetails()
{
List <salary> students = new List <salary>();
string connString = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connString))
{
using (SqlCommand cmd = new SqlCommand("persondata", conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
salary student = new salary();
student.id = Convert.ToInt16(reader["id"]);
student.name = reader["name"].ToString();
student.employerid = reader["employerid"].ToString();
student.title = reader["title"].ToString();
student.depart = reader["depart"].ToString();
student.accno = reader["accno"].ToString();
student.basicsalary = Convert.ToInt32(reader["basicsalary"]);
student.mealallow = Convert.ToInt32(reader["mealallow"]);
student.transportallow = Convert.ToInt32(reader["transportallow"]);
student.medicalallow = Convert.ToInt32(reader["medicalallow"]);
student.tax = Convert.ToInt32(reader["tax"]);
student.total = Convert.ToInt32(reader["medicalallow"]) + Convert.ToInt32(reader["transportallow"]) + Convert.ToInt32(reader["mealallow"]) + Convert.ToInt32(reader["basicsalary"]) + -Convert.ToInt32(reader["tax"]);
students.Add(student);
}
}
}
return(students);
}
public ActionResult All(string ym = "")
{
//ReportSalary
ViewBag.Title = "全部薪資查詢(主管權限)";
if (string.IsNullOrEmpty(ym))
{
ModelState.AddModelError("", "請輸入年度與月份");
View("Index");
}
var ctx = new ApplicationDbContext();
var user = ctx.Users.Where(x => x.UserName == User.Identity.Name).FirstOrDefault();
if (user != null)
{
if (ctx.permList.Where(x => x.workNo == user.workNo && x.mod == "ReportSalary").Count() == 0)
{
return(RedirectToAction("AccessDenied", "Account"));
}
}
int y = Convert.ToInt32(ym.Split('-')[0]);
int m = Convert.ToInt32(ym.Split('-')[1]);
DateTime dtym = new DateTime(y, m, 1);
ViewBag.ym = dtym.ToString("yyyy-MM");
List <salary> sObjList = ctx.salaryList.Where(x => x.year == y && x.month == m).OrderBy(x => x.workNo).ToList <salary>();
List <KeyValuePair <string, int> > fdList = new List <KeyValuePair <string, int> >();
DataTable dt = new DataTable();
if (sObjList.Count > 0)
{
salary sObj = sObjList[0];
JObject jobj = null;
try
{
jobj = JObject.Parse(sObj.jData);
}
catch (Exception ex)
{
jobj = null;
}
if (jobj == null)
{
View("Index");
}
for (int i = 0; i < jobj.Properties().ToList <JProperty>().Count(); i++)
{
string pnm = jobj.Properties().ToList <JProperty>()[i].Name;
if (pnm == "雇主負擔" || pnm == "本人負擔")
{
pnm = "勞保-" + pnm;
}
if (pnm.Split('-').Count() > 1)
{
pnm = pnm.Split('-')[0];
}
KeyValuePair <string, int> fd;
if (fdList.Where(x => x.Key == pnm).Count() > 0)
{
int idx = 0;
for (int itmp = 0; itmp < fdList.Count(); itmp++)
{
if (fdList[itmp].Key == pnm)
{
fd = fdList.Where(x => x.Key == pnm).First();
fd = new KeyValuePair <string, int>(pnm, fd.Value + 1);
fdList[itmp] = fd;
break;
}
}
}
else
{
fd = new KeyValuePair <string, int>(pnm, 1);
fdList.Add(fd);
}
dt.Columns.Add(jobj.Properties().ToList <JProperty>()[i].Name);
}
}
foreach (salary sObj in sObjList)
{
JObject jobj = null;
try
{
jobj = JObject.Parse(sObj.jData);
}
catch (Exception ex)
{
jobj = null;
}
if (jobj != null)
{
DataRow r = dt.NewRow();
for (int i = 0; i < jobj.Properties().ToList <JProperty>().Count(); i++)
{
string pnm = jobj.Properties().ToList <JProperty>()[i].Name;
if (pnm == "勞保-雇主負擔" || pnm == "勞保-本人負擔")
{
r[pnm] = jobj[pnm.Replace("勞保-", "")];
}
else
{
r[pnm] = jobj[pnm];
}
}
dt.Rows.Add(r);
dt.AcceptChanges();
}
}
ViewBag.data = dt;
ViewBag.fdList = fdList;
return(View("Index"));
}
public ActionResult Index(string ym = "")
{
ViewBag.Title = "個人薪資查詢";
if (string.IsNullOrEmpty(ym))
{
ModelState.AddModelError("", "請輸入年度與月份");
return(View());
}
var ctx = new ApplicationDbContext();
var user = ctx.Users.Where(x => x.UserName == User.Identity.Name).FirstOrDefault();
if (user != null)
{
string workNo = user.workNo;
int y = Convert.ToInt32(ym.Split('-')[0]);
int m = Convert.ToInt32(ym.Split('-')[1]);
DateTime dtym = new DateTime(y, m, 1);
ViewBag.ym = dtym.ToString("yyyy-MM");
salary sObj = ctx.salaryList.Where(x => x.year == y && x.month == m && x.workNo == user.workNo).FirstOrDefault();
if (sObj != null)
{
JObject jobj = null;
try
{
jobj = JObject.Parse(sObj.jData);
List <string> removeList = new List <string>();
foreach (JProperty prop in jobj.Properties())
{
if (getHiddenFields().Where(x => prop.Name.Contains(x)).Count() > 0)
{
if (getShowFields().Where(x => prop.Name.Equals(x)).Count() == 0)
{
removeList.Add(prop.Name);
}
}
}
foreach (string propName in removeList)
{
jobj.Remove(propName);
}
}
catch (Exception ex)
{
jobj = null;
}
if (jobj == null)
{
return(View());
}
DataTable dt = new DataTable();
List <KeyValuePair <string, int> > fdList = new List <KeyValuePair <string, int> >();
for (int i = 0; i < jobj.Properties().ToList <JProperty>().Count(); i++)
{
string pnm = jobj.Properties().ToList <JProperty>()[i].Name;
string pnm2 = "";
if (pnm.Split('-').Count() > 1)
{
pnm = pnm.Split('-')[0];
}
KeyValuePair <string, int> fd;
if (fdList.Where(x => x.Key == pnm).Count() > 0)
{
int idx = 0;
for (int itmp = 0; itmp < fdList.Count(); itmp++)
{
if (fdList[itmp].Key == pnm)
{
fd = fdList.Where(x => x.Key == pnm).First();
fd = new KeyValuePair <string, int>(pnm, fd.Value + 1);
fdList[itmp] = fd;
break;
}
}
}
else
{
fd = new KeyValuePair <string, int>(pnm, 1);
fdList.Add(fd);
}
dt.Columns.Add(jobj.Properties().ToList <JProperty>()[i].Name);
}
DataRow r = dt.NewRow();
for (int i = 0; i < jobj.Properties().ToList <JProperty>().Count(); i++)
{
string pnm = jobj.Properties().ToList <JProperty>()[i].Name;
r[pnm] = jobj[pnm];
}
dt.Rows.Add(r);
dt.AcceptChanges();
ViewBag.data = dt;
ViewBag.fdList = fdList;
return(View());
}
}
return(View());
}
public double CalcTax(salary salary)
{
// GET: Salary
public ActionResult Index()
{
salary sal = new salary();
return(View(sal));
}
static void Main(string[] args)
{
double [] salary = new salary[9];
Console.WriteLine("Enter the person's salary");
double inputSalary = Convert.ToDouble(Console.ReadLine());
if (inputSalary != -1)
{
double computedSal = (inputSalary * (0.09)) + 200;
if (computedSal < 300)
{
salary[0] = salary[0] + 1;
}
else if (computedSal < 400)
{
salary[1] = salary[1] + 1;
}
else if (computedSal < 500)
{
salary[2] = salary[2] + 1;
}
else if (computedSal < 600)
{
salary[3] = salary[3] + 1;
}
else if (computedSal < 700)
{
salary[4] = salary[4] + 1;
}
else if (computedSal < 800)
{
salary[5] = salary[5] + 1;
}
else if (computedSal < 900)
{
salary[6] = salary[6] + 1;
}
else if (computedSal < 1000)
{
salary[7] = salary[7] + 1;
}
else
{
salary[8] = salary[8] + 1;
}
}
for (int i = 0; i < salary.Length; i++)
{
// int num = 0;
switch (i)
{
case 0:
Console.WriteLine($"$200-299: {salary[i]}");
break;
case 1:
Console.WriteLine($"$300-399: {salary[i]}");
break;
case 2:
Console.WriteLine($"$400-499: {salary[i]}");
break;
case 3:
Console.WriteLine($"$500-599: {salary[i]}");
break;
case 4:
Console.WriteLine($"$600-699: {salary[i]}");
break;
case 5:
Console.WriteLine($"$700-799: {salary[i]}");
break;
case 6:
Console.WriteLine($"$800-899: {salary[i]}");
break;
case 7:
Console.WriteLine($"$900-999: {salary[i]}");
break;
case 8:
Console.WriteLine($"$1000 and above: {salary[i]}");
break;
default:
Console.WriteLine("invalid");
}
}
Console.WriteLine();
}
public ActionResult Upload(HttpPostedFileBase file)
{
if (file == null)
{
ModelState.AddModelError("", "上傳檔案失敗，請重新執行");
return(View());
}
if (file.ContentLength > 0)
{
string filename = Path.GetFileName(file.FileName);
string ext = Path.GetExtension(file.FileName).Replace(".", "").ToUpper();
if (ext != "XLSX")
{
ModelState.AddModelError("", "請選擇XLSX格式Excel檔案！");
return(View());
}
var ctx = new ApplicationDbContext();
//string path = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "upload", ctx.getLocalTiime().ToString("yyyyMMdd") + ".xlsx");
string path = @"C:\inetpub\upload\" + ctx.getLocalTiime().ToString("yyyyMM");
DirectoryInfo di = new DirectoryInfo(path);
if (di.Exists == false)
{
di.Create();
}
string uploadfile = path + @"\" + ctx.getLocalTiime().ToString("yyyyMMdd") + ".xlsx";
if (System.IO.File.Exists(uploadfile))
{
//System.IO.File.Delete(uploadfile);
}
file.SaveAs(uploadfile);
ExcelPackage pkg = new ExcelPackage(new FileInfo(uploadfile));
ExcelWorkbook bk = pkg.Workbook;
ExcelWorksheet sht = bk.Worksheets[1];
List <string> fieldList = new List <string>();
for (int j = 1; j <= 73; j++)
{
fieldList.Add(sht.Cells[1, j].Text.Replace("\n", "").Replace(" ", ""));
}
for (int i = 2; i <= 65535; i++)
{
if (sht.Cells[i, 1].Text.Trim() == "")
{
break;
}
int year = 0; int month = 0;
string workNo = "";
string[] ym = sht.Cells[i, 3].Text.Split('/');
if (ym.Length == 2)
{
year = Convert.ToInt32(ym[0]);
month = Convert.ToInt32(ym[1]);
}
workNo = sht.Cells[i, 1].Text;
salary sObj = null;
sObj = ctx.salaryList.Where(x => x.year == year && x.month == month && x.workNo == workNo).FirstOrDefault();
if (sObj == null)
{
sObj = new salary
{
id = Guid.NewGuid().ToString(),
year = year,
month = month,
workNo = workNo,
jData = "{}"
};
ctx.salaryList.Add(sObj);
}
JObject jobj = new JObject();
//jobj.Properties().ToList<JProperty>()[1].Name
for (int j = 0; j < fieldList.Count; j++)
{
if (!string.IsNullOrEmpty(fieldList[j]))
{
jobj[fieldList[j]] = sht.Cells[i, j + 1].Text;
}
}
sObj.jData = jobj.ToString();
ctx.SaveChanges();
}
//System.IO.File.Delete(uploadfile);
TempData["msg"] = "上傳完成";
return(View());
}
else
{
ModelState.AddModelError("", "上傳檔案失敗，請重新執行");
return(View());
}
}
