public ActionResult EmployeeIndex(EmployeeVM model)
{
try
{
List <Department> list = db.Departments.ToList();
ViewBag.DepartmentList = new SelectList(list, "DepartmentId", "DepartmentName");
Employee emp = new Employee();
emp.Address = model.Address;
emp.Name = model.Name;
emp.DepartmentId = model.DepartmentId;
db.Employees.Add(emp);
db.SaveChanges();
int ltstEmp = emp.EmployeeId;
Site objsite = new Site();
objsite.SiteName = model.SiteName;
objsite.EmployeeId = ltstEmp;
db.Sites.Add(objsite);
db.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
return(View(model));
}
public ActionResult Create([Bind(Include = "Id,FullName,UserName,Password")] tblUser tblUser)
{
if (ModelState.IsValid)
{
db.tblUsers.Add(tblUser);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblUser));
}
public string InsertEmp(saletran emp)
{
dc.Configuration.ProxyCreationEnabled = false;
ViewData["drp"] = dc.custs.ToList();
ViewData["drp2"] = dc.products.ToList();
dc.saletrans.Add(emp);
dc.SaveChanges();
return("Product added successfully...");
}
public IHttpActionResult PostOrder(Order order)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
order = new Order();
order.OrderName = "Test";
order.OrderAddress = "Karachi";
order.OrderFrom = "Suleman";
order.OrderTo = "Ahmed";
order.DestinationFrom = "Kemari karachi Pakistan";
order.DestinationTo = "Bahadurabad karachi Pakistan";
double ad1 = GetLocs1(order.DestinationFrom);
double ad2 = GetLocs2(order.DestinationFrom);
double ad3 = GetLocs1(order.DestinationTo);
double ad4 = GetLocs2(order.DestinationTo);
order.CurrentLocation = GetIp(); //this will insert the current location of device.
order.Distance = GetDistanceBetweenPoints(ad1, ad2, ad3, ad4);
order.PaymentMode = "Before Delievery";
order.DrivingMode = "Flight";
order.TotalAmount = TotalAmt(order.Distance, order.DrivingMode); //this will insert Total Amount from Distance.
order.Status = false;
db.Orders.Add(order);
db.SaveChanges();
return(Ok("success"));
}
public ActionResult Index(int[] checkes, DateTime attendanceDate)
{
StudentsAttendance sa = new StudentsAttendance();
Student s = new Student();
var chkDate = db.StudentsAttendances.Where(a => a.Date == attendanceDate).FirstOrDefault();
if (chkDate == null)
{
foreach (var id in checkes)
{
sa.StudentId = id;
sa.Date = attendanceDate;
db.StudentsAttendances.Add(sa);
db.SaveChanges();
TempData["message"] = "Attendance has been marked";
}
}
else
{
TempData["message"] = "Attendance has already been marked ";
}
var students = db.Students.ToList();
ViewBag.students = students;
return(View());
}
public HttpResponseMessage Put(int id, student student)
{
try
{
using (demoEntities entity = new demoEntities())
{
var stud = entity.students.FirstOrDefault(p => p.id == id);
if (stud != null)
{
stud.name = student.name;
stud.location = student.location;
stud.city = student.city;
stud.salary = student.salary;
entity.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, stud));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Student with id " + id.ToString() + " not exist"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public void GrabarCliente(Clientes c)
{
using (demoEntities db = new demoEntities())
{
db.Clientes.Add(c);
db.SaveChanges();
}
}
public JsonResult InsertCustomer(Customer customer)
{
using (demoEntities entities = new demoEntities())
{
entities.Customers.Add(customer);
entities.SaveChanges();
}
return(Json(customer));
}
public void EliminarCliente(Clientes oCli)
{
using (demoEntities db = new demoEntities())
{
Clientes cli = (from c in db.Clientes
where c.TipoDoc == oCli.TipoDoc &&
c.NroDoc == oCli.NroDoc
select c).FirstOrDefault();
db.Clientes.Remove(cli);
db.SaveChanges();
}
}
public ActionResult DeleteCustomer(int customerId)
{
using (demoEntities entities = new demoEntities())
{
Customer customer = (from c in entities.Customers
where c.CustomerId == customerId
select c).FirstOrDefault();
entities.Customers.Remove(customer);
entities.SaveChanges();
}
return(new EmptyResult());
}
public JsonResult SaveMasterDetail(string c_email, string p_amount, string c_address, int c_id, int add_id, int p_id)
{
bool result = false;
if (c_id > 0)
{
var customer = db.Customers.Where(a => a.c_id == c_id).FirstOrDefault();
customer.c_id = c_id;
customer.cemail = c_email;
db.SaveChanges();
}
if (add_id > 0)
{
var add = db.Addresses.Where(a => a.add_id == add_id).FirstOrDefault();
add.c_address = c_address;
add.add_id = add_id;
db.SaveChanges();
}
if (p_id > 0)
{
var pay = db.payments.Where(a => a.p_id == p_id).FirstOrDefault();
pay.p_amount = Convert.ToDouble(p_amount);
pay.p_id = p_id;
db.SaveChanges();
result = true;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult Store(Post _post)
{
if (ModelState.IsValid)
{
var title = _post.Title;
var count = _db.Posts.Where(s => s.Title.Contains(title)).Count();
if (count > 0)
{
ViewBag.message = "Title already exists";
return(View());
}
_post.Created_at = DateTime.Now;
_post.Updated_at = DateTime.Now;
_db.Posts.Add(_post);
_db.SaveChanges();
return(RedirectToAction("Index"));
//return Json(_post);
}
ViewBag.message = "Insert failed!";
return(View());
}
public void ActualizarCliente(Clientes oCli)
{
using (demoEntities db = new demoEntities())
{
Clientes cli = (from c in db.Clientes
where c.TipoDoc == oCli.TipoDoc && c.NroDoc == oCli.NroDoc
select c).FirstOrDefault();
cli.Nombres = oCli.Nombres.Trim();
cli.Apellidos = oCli.Apellidos.Trim();
db.SaveChanges();
}
}
public ActionResult UpdateCustomer(Customer customer)
{
using (demoEntities entities = new demoEntities())
{
Customer updatedCustomer = (from c in entities.Customers
where c.CustomerId == customer.CustomerId
select c).FirstOrDefault();
updatedCustomer.Name = customer.Name;
updatedCustomer.Country = customer.Country;
entities.SaveChanges();
}
return(new EmptyResult());
}
public ActionResult SubjectDelete(long?id)
{
try
{
demoEntities db = new demoEntities();
mst_subjectmarks subject = db.mst_subjectmarks.First(c => c.subject_id == id);
db.mst_subjectmarks.Remove(subject);
db.SaveChanges();
return(RedirectToAction("studentlist"));
}
catch (Exception ex)
{
return(RedirectToAction("studentlist"));
}
}
public HttpResponseMessage Post([FromBody] student student)
{
try
{
using (demoEntities entity = new demoEntities())
{
entity.students.Add(student);
entity.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, student);
message.Headers.Location = new Uri(Request.RequestUri + "/" + student.id.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public ActionResult Add(mst_student studentData)
{
try
{
if (ModelState.IsValid)
{
demoEntities db = new demoEntities();
db.mst_student.Add(studentData);
db.SaveChanges();
return(RedirectToAction("studentlist"));
}
else
{
return(View(studentData));
}
}
catch (Exception ex)
{
return(View(studentData));
}
}
public ActionResult Edit(mst_student studentData)
{
try
{
if (ModelState.IsValid)
{
demoEntities db = new demoEntities();
mst_student student = db.mst_student.First(c => c.student_id == studentData.student_id);
student.student_name = studentData.student_name;
db.SaveChanges();
return(RedirectToAction("studentlist"));
}
else
{
return(View(studentData));
}
}
catch (Exception ex)
{
return(View(studentData));
}
}
public HttpResponseMessage Delete(int id)
{
try
{
using (demoEntities entity = new demoEntities())
{
var stud = entity.students.FirstOrDefault(p => p.id == id);
if (stud == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "THe student with id " + id.ToString() + "not found"));
}
else
{
entity.students.Remove(stud);
entity.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
