public IHttpActionResult PuttblClientDetail(long id, tblClientDetail tblClientDetail) { //if (!ModelState.IsValid) //{ // return BadRequest(ModelState); //} if (id != tblClientDetail.ClientDetailsID) { return(BadRequest()); } db.Entry(tblClientDetail).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tblClientDetailExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult Client(tblClientDetail objClientDetails) { objClientDetails.dtCreatedOn = DateTime.Now; db.tblClientDetails.Add(objClientDetails); db.SaveChanges(); return(RedirectToAction("Client")); }
public IHttpActionResult GettblClientDetail(long id) { tblClientDetail tblClientDetail = db.tblClientDetails.Find(id); if (tblClientDetail == null) { return(NotFound()); } return(Ok(tblClientDetail)); }
public IHttpActionResult PosttblClientDetail(tblClientDetail tblClientDetail) { //if (!ModelState.IsValid) //{ // return BadRequest(ModelState); //} db.tblClientDetails.Add(tblClientDetail); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = tblClientDetail.ClientDetailsID }, tblClientDetail)); }
public IHttpActionResult Delete(long id) { tblClientDetail tblClientDetail = db.tblClientDetails.Find(id); if (tblClientDetail == null) { return(NotFound()); } db.tblClientDetails.Remove(tblClientDetail); db.SaveChanges(); return(Ok(tblClientDetail)); }
public ActionResult AddProject() { //============================= Employee binding entity =======================================// List <tblEmployee> empList = (from data in db.tblEmployees orderby data.varFirstName ascending select data).ToList(); tblEmployee tm = new tblEmployee(); tm.intEmployeeID = 0; tm.varFirstName = "-- Select --"; empList.Insert(0, tm); SelectList objModelEmp = new SelectList(empList, "intEmployeeID", "varFirstName", 0); ProjectViewModel objPrjModel = new ProjectViewModel(); objPrjModel.EmployeeModel = objModelEmp; //============================= End Employee Binding Entity ===================================// //============================= Project Status entity =========================================// List <tblStatus> stList = (from data in db.tblStatus orderby data.varStatus ascending select data).ToList(); tblStatus ts = new tblStatus(); ts.intStatusID = 0; ts.varStatus = "-- Select --"; stList.Insert(0, ts); SelectList objModelStatus = new SelectList(stList, "intStatusID", "varStatus", 0); objPrjModel.ProjectStatusList = objModelStatus; //============================= End Project Status entity ======================================// //============================= Client entity =================================================// List <tblClientDetail> clientList = (from data in db.tblClientDetails orderby data.varClientName ascending select data).ToList(); tblClientDetail tcd = new tblClientDetail(); tcd.intClientID = 0; tcd.varClientName = "-- Select--"; clientList.Insert(0, tcd); SelectList objClientList = new SelectList(clientList, "intClientID", "varClientName", 0); objPrjModel.ClientModel = objClientList; //============================= End Client entity =============================================// //============================= Internal Team entity ==========================================// List <tblEmployee> internTeamList = (from data in db.tblEmployees orderby data.varFirstName ascending select data).ToList(); SelectList objInternList = new SelectList(internTeamList, "intEmployeeID", "varFirstName", 0); objPrjModel.InternalTeam = objInternList; //============================= End Internal Team entity ======================================// //============================ Completion entity =============================================// List <tblCompletion> complList = (from data in db.tblCompletions orderby data.varComplition ascending select data).ToList(); tblCompletion tcm = new tblCompletion(); tcm.intCompletionId = 0; tcm.varComplition = "-- Select --"; complList.Insert(0, tcm); SelectList objCompletionlist = new SelectList(complList, "intCompletionId", "varComplition", 0); objPrjModel.CompletionModel = objCompletionlist; //=========================== End Completion entity ========================================// return(View(objPrjModel)); }