public ActionResult AddOrEdit(Emloyee emp)
{
try
{
if (emp.ImageUpload != null)
{
string fileName = Path.GetFileNameWithoutExtension(emp.ImageUpload.FileName);
string extension = Path.GetExtension(emp.ImageUpload.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
emp.ImagePath = "~/AppFiles/Images/" + fileName;
emp.ImageUpload.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/Images/"), fileName));
}
using (MvcProject_SayedEntities db = new MvcProject_SayedEntities())
{
if (emp.EmloyeeID == 0)
{
db.Emloyees.Add(emp);
db.SaveChanges();
}
else
{
db.Entry(emp).State = EntityState.Modified;
db.SaveChanges();
}
}
return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllEmployee()), message = "Submitted Successfully" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult Put(Emloyee emp)
{
string query = @"
update dbo.Employee set
EmployeeName = '" + emp.EmployeeName + @"'
,Department = '" + emp.Department + @"'
,DateOfJoining = '" + emp.DateOfJoining + @"'
where EmployeeId = " + emp.EmployeeId + @"
";
DataTable table = new DataTable();
string sqlDataSource = _configuration.GetConnectionString("DefaultConnection");
SqlDataReader myReader;
using (SqlConnection myCon = new SqlConnection(sqlDataSource))
{
myCon.Open();
using (SqlCommand myCommand = new SqlCommand(query, myCon))
{
myReader = myCommand.ExecuteReader();
table.Load(myReader);;
myReader.Close();
myCon.Close();
}
}
return(new JsonResult("Updated Successfully"));
}
public JsonResult Post(Emloyee emp)
{
string query = @"
insert into dbo.Employee
(EmployeeName,Department,DateOfJoining,PhotoFileName)
values
(
'" + emp.EmployeeName + @"'
,'" + emp.Department + @"'
,'" + emp.DateOfJoining + @"'
,'" + emp.PhotoFileName + @"'
)
";
DataTable table = new DataTable();
string sqlDataSource = _configuration.GetConnectionString("DefaultConnection");
SqlDataReader myReader;
using (SqlConnection myCon = new SqlConnection(sqlDataSource))
{
myCon.Open();
using (SqlCommand myCommand = new SqlCommand(query, myCon))
{
myReader = myCommand.ExecuteReader();
table.Load(myReader);;
myReader.Close();
myCon.Close();
}
}
return(new JsonResult("Added Successfully"));
}
public void DeleteEmployee(Emloyee emloyee)
{
if (emloyee == null)
{
throw new ArgumentNullException(nameof(emloyee));
}
_context.Employees.Remove(emloyee);
}
public ActionResult AddOrEdit(int id = 0)
{
Emloyee emp = new Emloyee();
if (id != 0)
{
using (MvcProject_SayedEntities db = new MvcProject_SayedEntities())
{
emp = db.Emloyees.Where(x => x.EmloyeeID == id).FirstOrDefault <Emloyee>();
}
}
return(View(emp));
}
public ActionResult AddOrEdit(int id = 0)
{
Emloyee emp = new Emloyee();
if (id != 0)
{
using (ApplicationDbContext db = new ApplicationDbContext())
{
emp = db.Emloyees.Where(x => x.EmloyeeID == id).FirstOrDefault <Emloyee>();
}
}
return(View(emp));
}
public void AddEmployee(Emloyee emloyee, Guid comanuId)
{
if (emloyee == null)
{
throw new ArgumentNullException(nameof(emloyee));
}
if (comanuId == Guid.Empty)
{
throw new ArgumentNullException(nameof(comanuId));
}
emloyee.CompanyId = comanuId;
_context.Employees.Add(emloyee);
}
public ActionResult Delete(int id)
{
try
{
using (MvcProject_SayedEntities db = new MvcProject_SayedEntities())
{
Emloyee emp = db.Emloyees.Where(x => x.EmloyeeID == id).FirstOrDefault <Emloyee>();
db.Emloyees.Remove(emp);
db.SaveChanges();
}
return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllEmployee()), message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public void UpdataEmloyee(Emloyee emloyee)
{
// throw new NotImplementedException();
}
