private ActionResult GetAll(string table) { var lookup = _lookup.GetAll(table).OrderBy(l => l.Code); var result = new { total = lookup.Count(), data = lookup }; return(this.Json(result)); }
public DirectResult GetAll(int start, int limit, string sort, string dir, string record) { try { var hashtable = JsonConvert.DeserializeObject <Hashtable>(record); string tableName = hashtable["tableName"].ToString(); if (tableName != "") { var filtered = (IEnumerable <coreLookup>)_lookup.GetAll(tableName); filtered = dir == "ASC" ? filtered.OrderBy(l => l.GetType().GetProperty(sort).GetValue(l, null)) : filtered.OrderByDescending(l => l.GetType().GetProperty(sort).GetValue(l, null)); var count = filtered.Count(); filtered = filtered.Skip(start).Take(limit); var lookup = filtered.Select(item => new { item.Id, item.Name, item.Code }).Cast <object>().ToList(); return(this.Json(new { total = count, data = lookup })); } else { return(this.Json(new { total = 0, data = new List <coreLookup>() })); } } catch (Exception exception) { return(this.Json(new { success = false, data = exception.InnerException == null ? exception.Message : exception.InnerException.Message })); } }
public DirectResult Save(iffsSurveyRequest SurveyRequest) { using (var transaction = new TransactionScope((TransactionScopeOption.Required), new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted })) { _context.Database.Connection.Open(); _context.Database.CommandTimeout = int.MaxValue; try { int employeeId = 0; var objUser = (coreUser)Session[Constants.CurrentUser]; if (objUser != null && objUser.EmployeeId != null) { employeeId = (int)objUser.EmployeeId; } if (SurveyRequest.Id.Equals(0)) { SurveyRequest.PreparedById = employeeId; SurveyRequest.Date = DateTime.Now; /* *************************************************** * Concurrency controlling scheme using global locking * ***************************************************/ var objOperationType = _lookup.GetAll((Lookups.LupOperationType)).Where(o => o.Id == SurveyRequest.Id).FirstOrDefault(); CyberErp.Presentation.Iffs.Web.MvcApplication httpapplication = HttpContext.ApplicationInstance as CyberErp.Presentation.Iffs.Web.MvcApplication; httpapplication.Application.Lock(); SurveyRequest.Number = _documentNoSetting.GetDocumentNumber("SurveyRequest");//objOperationType.Code + "/" + _SurveyRequest.Add(SurveyRequest); _documentNoSetting.SaveChanges(); httpapplication.Application.UnLock(); _notification.AddNew(new iffsNotification { Operation = Constants.SURVEYREQUEST, ObjectId = SurveyRequest.Id, ActorId = SurveyRequest.PreparedById, Date = DateTime.Now, Message = "Ordering Client Address: " + SurveyRequest.OrderingClientId + " Receiving Client Address: " + SurveyRequest.ReceivingClientId, IsViewed = false }); } else { _SurveyRequest.Edit(SurveyRequest); } _context.SaveChanges(); transaction.Complete(); return(this.Json(new { success = true, data = "Survey Request has been saved Successfully!" })); } catch (Exception exception) { return(this.Json(new { success = false, data = exception.InnerException != null ? exception.InnerException.Message : exception.Message })); } } }
public ActionResult GetMeasurementUnits(object query) { var ht = JsonConvert.DeserializeObject <Hashtable>(query.ToString()); var quarystring = ""; if (ht != null && ht["query"] != null) { quarystring = ht["query"].ToString(); } var lookup = quarystring != "" ? _lookup.GetAll(Lookups.MeasurementUnit).Where(t => t.Name.ToUpper().StartsWith(quarystring.ToUpper())).OrderBy(l => l.Code) : _lookup.GetAll(Lookups.MeasurementUnit).OrderBy(l => l.Code); var result = new { total = lookup.Count(), data = lookup }; return(this.Json(result)); }
public DirectResult GetLabels() { var lookup = _lookup.GetAll(Lookups.DamageType).OrderBy(l => l.Code); var result = new { total = lookup.Count(), data = lookup }; return this.Json(result); }
public DirectResult GetTruckTypes() { var lookup = _lookup.GetAll(Lookups.TruckType).OrderBy(l => l.Code); var result = new { total = lookup.Count(), data = lookup }; return(this.Json(result)); }
public ActionResult GetBoxTypes() { var lookup = _lookup.GetAll(Lookups.BoxType).OrderBy(l => l.Code); var result = new { total = lookup.Count(), data = lookup }; return(this.Json(result)); }
public DirectResult Save(iffsPackingSurveyHeader PackingSurvey) { using (var transaction = new TransactionScope((TransactionScopeOption.Required), new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted })) { _context.Database.Connection.Open(); _context.Database.CommandTimeout = int.MaxValue; try { // Request.Params[""] int employeeId = 0; var objUser = (coreUser)Session[Constants.CurrentUser]; if (objUser != null && objUser.EmployeeId != null) { employeeId = (int)objUser.EmployeeId; } if (PackingSurvey.Id.Equals(0)) { PackingSurvey.SurveyedById = employeeId; PackingSurvey.SurveyDate = DateTime.Now; /* *************************************************** * Concurrency controlling scheme using global locking * ***************************************************/ var objOperationType = _lookup.GetAll((Lookups.LupOperationType)).Where(o => o.Id == PackingSurvey.Id).FirstOrDefault(); CyberErp.Presentation.Iffs.Web.MvcApplication httpapplication = HttpContext.ApplicationInstance as CyberErp.Presentation.Iffs.Web.MvcApplication; httpapplication.Application.Lock(); // PackingSurvey.Number = GetDocumentNumber("PackingSurvey");//objOperationType.Code + "/" + _PackingSurvey.Add(PackingSurvey); // UpdateDocumentNumber("PackingSurvey"); httpapplication.Application.UnLock(); } else { _PackingSurvey.Edit(PackingSurvey); } _context.SaveChanges(); transaction.Complete(); return(this.Json(new { success = true, HeaderId = PackingSurvey.Id, data = "Packing Request has been saved Successfully!" })); } catch (Exception exception) { return(this.Json(new { success = false, data = exception.InnerException != null ? exception.InnerException.Message : exception.Message })); } } }
public DirectResult Save(iffsJobOrderHeader jobOrderHeader) { using (var transaction = new TransactionScope((TransactionScopeOption.Required), new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted })) { _context.Database.Connection.Open(); _context.Database.CommandTimeout = int.MaxValue; try { int employeeId = 0; var objUser = (coreUser)Session[Constants.CurrentUser]; if (objUser != null && objUser.EmployeeId != null) { employeeId = (int)objUser.EmployeeId; } var hashtable = JsonConvert.DeserializeObject <Hashtable>(Request.Params["record"]); var voucherDetailsString = hashtable["templateDetails"].ToString(); voucherDetailsString = voucherDetailsString.Remove(voucherDetailsString.Length - 1); var voucherDetails = voucherDetailsString.Split(new[] { ';' }); string action = hashtable["action"].ToString(); var jobOrderNo = jobOrderHeader.JobOrderNo; if (Request.Params["IsViewed"] != null) { jobOrderHeader.IsViewed = true; } if (jobOrderHeader.Id.Equals(0)) { jobOrderHeader.PreparedById = employeeId; jobOrderHeader.PreparedDate = DateTime.Now; /* *************************************************** * Concurrency controlling scheme using global locking * ***************************************************/ if (jobOrderNo == "Auto-Generated") { var objOperationType = _lookup.GetAll((Lookups.LupOperationType)).Where(o => o.Id == jobOrderHeader.OperationTypeId).FirstOrDefault(); CyberErp.Presentation.Iffs.Web.MvcApplication httpapplication = HttpContext.ApplicationInstance as CyberErp.Presentation.Iffs.Web.MvcApplication; httpapplication.Application.Lock(); jobOrderHeader.JobOrderNo = objOperationType.Code + "/" + GetDocumentNumber("JobOrder"); jobOrderHeader.Version = "000"; _jobOrderHeader.AddNew(jobOrderHeader); UpdateDocumentNumber("JobOrder"); httpapplication.Application.UnLock(); } else { _jobOrderHeader.AddNew(jobOrderHeader); } } else { if (action == "Revised") { var objJobOrder = _jobOrderHeader.Get(j => j.Id == jobOrderHeader.ParentJobOrderId); var objJobHistories = _historyHeader.GetAll().Where(h => h.ParentJobOrderId == jobOrderHeader.ParentJobOrderId); var objJobDetail = _jobOrderDetail.GetAll().Where(o => o.JobOrderHeaderId == jobOrderHeader.ParentJobOrderId); int versionint = 0; string version = ""; if (objJobHistories.Any()) { var lastVersion = objJobHistories.LastOrDefault().Version; versionint = Convert.ToInt32(lastVersion); versionint = versionint + 1; version = "00" + versionint.ToString(); } else { version = "001"; } //Make the copy of the previous joborder in history table iffsJobOrderHistoryHeader history = new iffsJobOrderHistoryHeader(); history.Quotations = objJobOrder.Quotations; history.JobOrderNo = objJobOrder.JobOrderNo; history.OperationTypeId = objJobOrder.OperationTypeId; history.ParentJobOrderId = objJobOrder.Id; history.Version = version; history.ValidityDate = objJobOrder.ValidityDate; history.UltimateClient = objJobOrder.UltimateClient; history.ReceivingClient = objJobOrder.ReceivingClient; history.ContactPersonForeign = objJobOrder.ContactPersonForeign; history.ContactPersonLocal = objJobOrder.ContactPersonLocal; history.PreparedById = objJobOrder.PreparedById; history.PreparedDate = objJobOrder.PreparedDate; history.CheckedById = objJobOrder.CheckedById; history.CheckedDate = objJobOrder.CheckedDate; history.ApprovedById = objJobOrder.ApprovedById; history.ApprovedDate = objJobOrder.ApprovalDate; history.Status = objJobOrder.Status; history.IsViewed = objJobOrder.IsViewed; history.Remark = objJobOrder.Remark; history.IsRequiredDocumentsSubmited = objJobOrder.IsRequiredDocumentsSubmited; _historyHeader.AddNew(history); foreach (var d in objJobDetail) { iffsJobOrderHistoryDetail historyDetail = new iffsJobOrderHistoryDetail(); historyDetail.JobOrderHeaderId = history.Id; historyDetail.FieldCategory = d.FieldCategory; historyDetail.Field = d.Field; historyDetail.Value = d.Value; _historyDetail.AddNew(historyDetail); } _context.Entry(objJobOrder).State = EntityState.Detached; jobOrderHeader.CheckedById = null; jobOrderHeader.CheckedDate = null; jobOrderHeader.ApprovedById = null; jobOrderHeader.ApprovalDate = null; } _jobOrderHeader.Edit(jobOrderHeader); } var quotations = Request.Form["QuotationRecs"]; quotations = quotations.Remove(quotations.Length - 1); var quotationDetails = quotations.Split(new[] { ';' }); SaveJobOrderDetails(jobOrderHeader, voucherDetails.ToList(), action, quotationDetails.ToList()); //if (action != "Revised") //{ // var quotations = Request.Form["QuotationRecs"]; // quotations = quotations.Remove(quotations.Length - 1); // var quotationDetails = quotations.Split(new[] { ';' }); // SaveJobOrderDetails(jobOrderHeader, voucherDetails.ToList(), action, quotationDetails.ToList()); //} //else //{ // SaveJobOrderDetails(jobOrderHeader, voucherDetails.ToList(), action, null); //} _context.SaveChanges(); transaction.Complete(); return(this.Json(new { success = true, data = "Job Order has been saved Successfully!" })); } catch (Exception exception) { return(this.Json(new { success = false, data = exception.InnerException != null ? exception.InnerException.Message : exception.Message })); } } }