public JsonResult Create(string para01, string para02, string para03)
{
string employee_id = para01;
string expense_id = para02;
string date = para03;
SALARY newSalary = new SALARY();
newSalary.EXPENSE_ID = expense_id;
newSalary.EMPLOYEE_ID = employee_id;
newSalary.SALARY_DATE = Convert.ToDateTime(date);
EMPLOYEE myEmployee = db.EMPLOYEE.Find(employee_id);
EXPENSE myExpense = db.EXPENSE.Find(expense_id);
myExpense.MONEY = myExpense.MONEY + myEmployee.SALARY;
db.Entry(myExpense).State = EntityState.Modified;
db.SALARY.Add(newSalary);
db.SaveChanges();
var list = db.SALARY.Include(s => s.EMPLOYEE).Include(s => s.EXPENSE).Select(n => new { EMPLOYEE_ID = n.EMPLOYEE_ID, EMPLOYEE_NAME = n.EMPLOYEE.EMPLOYEE_NAME, SALARY_DATE = n.SALARY_DATE, SALARY = n.EMPLOYEE.SALARY, EXPENSE_ID = n.EXPENSE_ID });
return(Json(new { code = 0, msg = "", count = 1000, data = list }, JsonRequestBehavior.AllowGet));
}
public string test(string para01, string para02, string para03)
{
string employee_id = para01;
string expense_id = para02;
SALARY mySalary = db.SALARY.Find(expense_id, employee_id);
if (mySalary != null)
{
return("1");
}
EXPENSE myExpense = db.EXPENSE.Find(expense_id);
if (myExpense == null)
{
return("2");
}
EMPLOYEE myEmployee = db.EMPLOYEE.Find(employee_id);
if (myEmployee == null)
{
return("3");
}
return("4");
}
public static void UpdateSalary(SALARY salary, bool control)
{
SalaryDAO.UpdateSalary(salary);
if (control)
{
EmployeeDAO.UpdateEmployee(salary.EmployeeID, salary.Amount);
}
}
public ActionResult DeleteConfirmed(string id)
{
SALARY sALARY = db.SALARY.Find(id);
db.SALARY.Remove(sALARY);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static void AddSalary(SALARY salary)
{
try
{
db.SALARies.InsertOnSubmit(salary);
db.SubmitChanges();
}catch (Exception ex)
{
throw ex;
}
}
public ActionResult Edit([Bind(Include = "EXPENSE_ID,EMPLOYEE_ID,SALARY_DATE")] SALARY sALARY)
{
if (ModelState.IsValid)
{
db.Entry(sALARY).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.EMPLOYEE_ID = new SelectList(db.EMPLOYEE, "EMPLOYEE_ID", "EMPLOYEE_NAME", sALARY.EMPLOYEE_ID);
ViewBag.EXPENSE_ID = new SelectList(db.EXPENSE, "EXPENSE_ID", "TYPE", sALARY.EXPENSE_ID);
return(View(sALARY));
}
public static void DeleteSalary(int salaryID)
{
try
{
SALARY sl = db.SALARY.First(x => x.ID == salaryID);
db.SALARY.DeleteOnSubmit(sl);
db.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public static void DeleteSalary(int salaryID)
{
try
{
SALARY salary = db.SALARies.First(x => x.ID == salaryID);
db.SALARies.DeleteOnSubmit(salary);
db.SubmitChanges();
}
catch (Exception)
{
throw;
}
}
// GET: SALARies/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SALARY sALARY = db.SALARY.Find(id);
if (sALARY == null)
{
return(HttpNotFound());
}
return(View(sALARY));
}
static void Main(string[] args)
{
int NUMBER, HOURS;
double VALOR_HORA, SALARY;
NUMBER = int.Parse(Console.ReadLine());
HOURS = int.Parse(Console.ReadLine());
VALOR_HORA = double.Parse(Console.ReadLine(), CultureInfo.InvariantCulture);
SALARY = HOURS * VALOR_HORA;
Console.WriteLine("NUMBER = " + NUMBER);
Console.WriteLine("SALARY = U$ " + SALARY.ToString("F2"), CultureInfo.InvariantCulture);
}
public static void UpdateSalary(SALARY salary, bool control)
{
try
{
SALARY sl = db.SALARies.First(x => x.ID == salary.ID);
sl.Amount = salary.Amount;
sl.Year = salary.Year;
sl.MonthID = salary.MonthID;
db.SubmitChanges();
}catch (Exception ex)
{
throw ex;
}
}
static void uri1008()
{
int NUMBER, quantidadeHoraTrabalho;
double ganhoHora, SALARY;
NUMBER = int.Parse(Console.ReadLine());
quantidadeHoraTrabalho = int.Parse(Console.ReadLine());
ganhoHora = double.Parse(Console.ReadLine());
SALARY = quantidadeHoraTrabalho * ganhoHora;
Console.WriteLine("NUMBER = " + NUMBER);
Console.WriteLine("SALARY = U$ " + SALARY.ToString("f2"));
Console.ReadLine();
}
// GET: SALARies/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SALARY sALARY = db.SALARY.Find(id);
if (sALARY == null)
{
return(HttpNotFound());
}
ViewBag.EMPLOYEE_ID = new SelectList(db.EMPLOYEE, "EMPLOYEE_ID", "EMPLOYEE_NAME", sALARY.EMPLOYEE_ID);
ViewBag.EXPENSE_ID = new SelectList(db.EXPENSE, "EXPENSE_ID", "TYPE", sALARY.EXPENSE_ID);
return(View(sALARY));
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtYear.Text.Trim() == "")
{
MessageBox.Show("year is empty");
}
else if (txtSalary.Text.Trim() == "")
{
MessageBox.Show("Salary is empty");
}
else if (cmbMonth.SelectedIndex == -1)
{
MessageBox.Show("Select a month");
}
else
{
bool control = false;
if (!isUpdate)
{
if (salary.EmployeeID == 0)
{
MessageBox.Show("please select an employee from table");
}
else
{
salary.Year = Convert.ToInt32(txtYear.Text);
salary.MonthID = Convert.ToInt32(cmbMonth.SelectedValue);
salary.Amount = Convert.ToInt32(txtSalary.Text);
if (salary.Amount > oldsalary)
{
control = true;
}
SalaryBLL.AddSalary(salary, control);
MessageBox.Show("Salary was added");
cmbMonth.SelectedIndex = -1;
salary = new SALARY();
}
}
else
{
DialogResult result = MessageBox.Show("Are you sure?", "title", MessageBoxButtons.YesNo);
if (DialogResult.Yes == result)
{
SALARY salary = new SALARY();
salary.ID = detail.SalaryID;
salary.EmployeeID = detail.EmployeeID;
salary.Year = Convert.ToInt32(txtYear.Text);
salary.MonthID = Convert.ToInt32(cmbMonth.SelectedValue);
salary.Amount = Convert.ToInt32(txtSalary.Text);
if (salary.Amount > detail.oldSalary)
{
control = true;
}
SalaryBLL.UpdateSalary(salary, control);
MessageBox.Show("Salary was Uptaded");
this.Close();
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtYear.Text.Trim() == "")
{
MessageBox.Show("Please fill the year");
}
else if (cmbMonth.SelectedIndex == -1)
{
MessageBox.Show("Please select month");
}
else if (txtSalary.Text.Trim() == "")
{
MessageBox.Show("Please fill the salary");
}
else if (txtUserNo.Text.Trim() == "")
{
MessageBox.Show("Please select the employee");
}
else
{
bool control = false;
if (!isUpdated)
{
if (salary.EmployeeID == 0)
{
MessageBox.Show("Please select the employee from the table");
}
else
{
salary.Year = Convert.ToInt32(txtYear.Text);
salary.MonthID = Convert.ToInt32(cmbMonth.SelectedValue);
salary.Amount = Convert.ToInt32(txtSalary.Text);
if (salary.Amount > oldSalary)
{
control = true;
}
SalaryBLL.AddSalary(salary, control);
MessageBox.Show("Salary added!");
cmbMonth.SelectedIndex = -1;
salary = new SALARY();
}
}
else
{
DialogResult dialogResult = MessageBox.Show("Are you sure?", "title", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
SALARY salary = new SALARY();
salary.ID = detail.SalaryID;
salary.EmployeeID = detail.EmployeeID;
salary.Year = Convert.ToInt32(txtYear.Text);
salary.MonthID = Convert.ToInt32(cmbMonth.SelectedValue);
salary.Amount = Convert.ToInt32(txtSalary.Text);
if (salary.Amount > detail.OldSalary)
{
control = true;
}
SalaryBLL.UpdateSalary(salary, control);
MessageBox.Show("Salary updated!");
this.Close();
}
}
}
}
