public ActionResult SaveTQCHeadDetails(TQCHeadModel model) { if (ModelState.IsValid) { _TQCHeadRepo = new TQCHeadRepo(); _repoResponse = new RepositoryResponse(); string _loggedInUserID = System.Web.HttpContext.Current.Session["UserID"].ToString(); _repoResponse = _TQCHeadRepo.AddOrEditTQCHeadDetails(model, _loggedInUserID); //if (_repoResponse.success) //{ // return View(); //} return(Json(new { success = _repoResponse.success, message = _repoResponse.message })); } else { List <string> fieldOrder = new List <string>(new string[] { "Name", "StartDate", "EndDate" }) .Select(f => f.ToLower()).ToList(); var _message1 = ModelState .Select(m => new { Order = fieldOrder.IndexOf(m.Key.ToLower()), Error = m.Value }) .OrderBy(m => m.Order) .SelectMany(m => m.Error.Errors.Select(e => e.ErrorMessage)).ToList(); _message = string.Join("<br/>", _message1); return(Json(new { success = false, message = _message })); } }
public RepositoryResponse AddOrEditTQCHeadDetails(TQCHeadModel model, string _loggedInUserID) { baseModel = new RepositoryResponse(); TQCHead dbModel; try { using (objSOMEntities = new SOMEntities()) { DateTime now = DateTime.Now; dbModel = new TQCHead(); //var usr = objSOMEntities.EmpMasters.Where(r => r.EmpID == model.EmployeeID).FirstOrDefault(); dbModel = objSOMEntities.TQCHeads.Where(r => r.ID == model.ID).FirstOrDefault(); if (dbModel != null) { dbModel.StartDate = Assistant.SOMDateConversionFrom_UIToDb((DateTime)model.StartDate); dbModel.EndDate = "01019999"; dbModel.EmployeeNumber = model.EmpNumber; dbModel.Name = model.EmpName; dbModel.IsActive = true; dbModel.ModifiedBy = _loggedInUserID; objSOMEntities.SaveChanges(); baseModel = new RepositoryResponse { success = true, message = "TQC Head Details updated Successfully" }; } else { dbModel = new TQCHead(); dbModel.EmployeeNumber = model.EmpNumber; dbModel.Name = model.EmpName; dbModel.StartDate = Assistant.SOMDateConversionFrom_UIToDb((DateTime)model.StartDate); dbModel.EndDate = "01019999"; dbModel.IsActive = true; dbModel.CreatedBy = _loggedInUserID; objSOMEntities.TQCHeads.Add(dbModel); objSOMEntities.SaveChanges(); baseModel = new RepositoryResponse { success = true, message = "TQC Head Details added Successfully" }; } } } catch (Exception ex) { baseModel = new RepositoryResponse { success = false, message = ex.ToString() }; } return(baseModel); }
public RepositoryResponse GetAllTQCHeadDatas(string dept, string date) { baseModel = new RepositoryResponse(); try { string subMonth = string.Empty; string subYear = string.Empty; if (!string.IsNullOrEmpty(date)) { string[] sDate = date.Split('-'); subMonth = sDate[0]; subYear = sDate[1]; } List <TQCHeadModel> _lstTQCHead = new List <TQCHeadModel>(); using (objSOMEntities = new SOMEntities()) { var lstTQCHead = objSOMEntities.TQCHeads.OrderBy(r => r.IsActive).ToList(); int i = 1; foreach (var item in lstTQCHead) { TQCHeadModel _TQCHead = new TQCHeadModel(); _TQCHead.ID = item.ID; _TQCHead.SlNo = i; _TQCHead.EmployeeID = long.Parse(item.EmployeeNumber); _TQCHead.EmpNumber = item.EmployeeNumber; _TQCHead.EmpName = item.Name; _TQCHead.StartDate_Grid = Assistant.SOMDbToUIDateConversion(item.StartDate); _TQCHead.EndDate_Grid = Assistant.SOMDbToUIDateConversion(item.EndDate); _TQCHead.IsActive = (bool)item.IsActive; _lstTQCHead.Add(_TQCHead); i++; } baseModel = new RepositoryResponse { success = true, message = "Get TQC Head details Successfully", Data = _lstTQCHead }; } } catch (Exception ex) { baseModel = new RepositoryResponse { success = false, message = ex.ToString() }; } return(baseModel); }
public RepositoryResponse GetTQCHeadDetailsByID(long ID) { baseModel = new RepositoryResponse(); try { TQCHeadModel model = new TQCHeadModel(); using (objSOMEntities = new SOMEntities()) { var data = objSOMEntities.TQCHeads.Where(r => r.ID == ID).FirstOrDefault(); if (data != null) { model.ID = data.ID; model.EmployeeID = long.Parse(data.EmployeeNumber); model.EmpName = data.Name; model.StartDate_Grid = Assistant.SOMDbToUIDateConversionForPopup(data.StartDate); model.EndDate_Grid = Assistant.SOMDbToUIDateConversionForPopup(data.EndDate);; //model.IsActive = (bool)data.IsActive; baseModel = new RepositoryResponse { success = true, message = "Get TQC Head details Successfully", Data = model }; } else { baseModel = new RepositoryResponse { success = false, message = "Unable to get TQC Head details", Data = model }; } } } catch (Exception ex) { baseModel = new RepositoryResponse { success = false, message = ex.ToString() }; } return(baseModel); }
public ActionResult LoadTQCHeadDetailsByID(string ID) { long _id = long.Parse(ID); _TQCHeadRepo = new TQCHeadRepo(); _repoResponse = new RepositoryResponse(); if (_id > 0) { _repoResponse = _TQCHeadRepo.GetTQCHeadDetailsByID(_id); } if (_repoResponse.success == true) { TQCHeadModel model = new TQCHeadModel(); model = _repoResponse.Data; //return JSon(model); return(Json(new { success = _repoResponse.success, message = _repoResponse.message, data = model })); } else { EvaluationModel model = new EvaluationModel(); return(Json(new { success = _repoResponse.success, message = _repoResponse.message, data = model })); } }
// GET: TQCHead public ActionResult Index() { TQCHeadModel model = new TQCHeadModel(); return(View(model)); }