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 }));
}
}
}
