public JsonResult updateFeeRepository([FromBody] Business.FeeDataModel request)
{
var respuesta = new { idEntity = request.FeeID, idEntityRequest = request.FeeID, message = "OK", error = "", DataReceived = request, OldData = "" };
Fees oldData = null;
using (QuotingToolRepository db = new QuotingToolRepository())
{
try
{
var FeeData = request.FeeID > 0 ? db.Fees.Where(i => i.FeeID == request.FeeID).Single() : new Fees();
oldData = FeeData;
if (request.FeeID > 0)
{
FeeData.DateUpdated = System.DateTime.Now;
FeeData.UpdatedBy = "SYSTEM"; // Replace with the right identity,
}
else
{
FeeData.DateAdded = System.DateTime.Now;
FeeData.AddedBy = "SYSTEM"; // Replace with the right identity,
}
FeeData.FeeID = request.FeeID;
FeeData.ParentFeeID = request.ParentFeeID;
FeeData.FeeTypeID = request.FeeTypeID;
FeeData.ByUomID = request.ByUomID;
FeeData.CityID = request.CityID;
FeeData.StateID = request.StateID;
FeeData.Discount = request.Discount;
FeeData.IslandID = request.IslandID;
FeeData.ActionID = request.ActionID;
FeeData.Value = request.Value;
FeeData.ZipCodes = request.ZipCodes;
FeeData.FeeMin = request.FeeMin;
FeeData.FeeMax = request.FeeMax;
FeeData.RangeFrom = request.RangeFrom;
FeeData.RangeTo = request.RangeTo;
FeeData.ValidFrom = request.ValidFrom;
FeeData.ValidUntil = request.ValidUntil;
if (request.FeeID < 0 && Helpers.NewEntityCreationHelper.CheckMandatoryFields(FeeData, typeof(Fees)))
{
db.Fees.AddObject(FeeData);
}
if (db.SaveChanges() > 0)
{
respuesta = new { idEntity = FeeData.FeeID, idEntityRequest = request.FeeID, message = "OK", error = "", DataReceived = request, OldData = JsonConvert.SerializeObject(oldData) }
}
;
}
catch (Exception ex)
{
Response.StatusCode = 500;
respuesta = new { idEntity = request.FeeID, idEntityRequest = request.FeeID, message = "ERROR", error = ex.Message, DataReceived = request, OldData = JsonConvert.SerializeObject(oldData) };
}
}
return(Json(respuesta, JsonRequestBehavior.AllowGet));
}
public JsonResult getUoms()
{
using (QuotingToolRepository db = new QuotingToolRepository())
{
var dataSet = db.UOMs.Select(uom => new { value = uom.UomID, label = uom.Name.Trim() }).ToList();
return(Json(dataSet, JsonRequestBehavior.AllowGet));
}
}
public JsonResult getCities()
{
using (QuotingToolRepository db = new QuotingToolRepository())
{
var dataSet = db.Cities.Select(city => new { value = city.CityID, label = city.Name.Trim() }).ToList();
return(Json(dataSet, JsonRequestBehavior.AllowGet));
}
}
public JsonResult getIslands()
{
using (QuotingToolRepository db = new QuotingToolRepository())
{
var dataSet = db.Islands.Select(island => new { value = island.IslandID, label = island.Name.Trim().ToUpper() }).ToList();
return(Json(dataSet, JsonRequestBehavior.AllowGet));
}
}
public JsonResult getStates()
{
using (QuotingToolRepository db = new QuotingToolRepository())
{
var dataSet = db.States.Select(state => new { value = state.StateID, label = state.Name.Trim().ToUpper() }).ToList();
return(Json(dataSet, JsonRequestBehavior.AllowGet));
}
}
public JsonResult getZones()
{
using (QuotingToolRepository db = new QuotingToolRepository())
{
var dataSet = db.Zones.Select(zone => new { value = zone.ZoneID, label = zone.Name.Trim() }).ToList();
return(Json(dataSet, JsonRequestBehavior.AllowGet));
}
}
public JsonResult updateSingleFieldFeeData([FromBody] Business.AGCellValueDataChangedModel request)
{
var respuesta = new { idEntity = request.idEntity, message = "OK", error = "", DataReceived = request, OldData = "" };
Fees oldData = null;
using (QuotingToolRepository db = new QuotingToolRepository())
{
try
{
var FeeData = request.idEntity > -1 ? db.Fees.Where(i => i.FeeID == request.idEntity).Single() : new Fees();
oldData = FeeData;
if (request.idEntity > -1)
{
FeeData.DateUpdated = System.DateTime.Now;
FeeData.UpdatedBy = "System"; // Replace with the right identity,
}
else
{
FeeData.DateAdded = System.DateTime.Now;
FeeData.AddedBy = "System"; // Replace with the right identity,
}
var properties = typeof(Fees).GetProperties(BindingFlags.Public | BindingFlags.Instance);
foreach (var property in properties)
{
if (request.field == property.Name)
{
property.SetValue(FeeData, Helpers.TypesHelper.ChangeType(request.newValue, property.PropertyType), null);
break;
}
}
if (request.idEntity == -1)
{
db.Fees.AddObject(FeeData);
}
if (db.SaveChanges() > 0)
{
respuesta = new { idEntity = request.idEntity, message = "OK", error = "", DataReceived = request, OldData = JsonConvert.SerializeObject(oldData) }
}
;
}
catch (Exception ex)
{
Response.StatusCode = 500;
respuesta = new { idEntity = request.idEntity, message = "ERROR", error = ex.Message + System.Environment.NewLine + ex.InnerException?.Message, DataReceived = request, OldData = JsonConvert.SerializeObject(oldData) };
}
}
return(Json(respuesta, JsonRequestBehavior.AllowGet));
}
public JsonResult GetFeeSubTypes(int?feeTypeID)
{
using (QuotingToolRepository db = new QuotingToolRepository())
{
var subTypesList = db.FeeTypes.Where(feeType => feeType.ParentFeeTypeID == feeTypeID)
.Select(feeType => new SelectListItem {
Value = SqlFunctions.StringConvert((double)feeType.FeeTypeID), Text = feeType.Name
})
.ToList();
return(Json(subTypesList, JsonRequestBehavior.AllowGet));
}
}
public JsonResult getUomsByFeeID(int ParentFeeID)
{
using (QuotingToolRepository db = new QuotingToolRepository())
{
var fees = db.Fees.Where(i => i.ParentFeeID == ParentFeeID).ToList();
List <UOM> uoms = new List <UOM>();
foreach (Fees fee in fees)
{
if (fee.ByUomID.HasValue && !uoms.Any(uom => uom.UomID == fee.ByUomID))
{
uoms.Add(db.UOMs.Where(i => fee.ByUomID == i.UomID).Single());
}
}
return(Json(uoms.Select(i => new { value = i.UomID, label = i.Name }), JsonRequestBehavior.AllowGet));
}
}
public ActionResult Index()
{
Business.FeesByTypeModel theModel = new Business.FeesByTypeModel();
using (QuotingToolRepository db = new QuotingToolRepository())
{
theModel.States = db.States.ToList();
theModel.State = theModel.States.First().StateID.ToString();
theModel.FeeTypes = db.FeeTypes.Where(feeType => feeType.ParentFeeTypeID == null).ToList();
}
theModel.FeesModel = new Business.FeesGridModel(Business.FeesGridModel.Mode.Fees, new List <string> {
"ParentFeeID", "StateID", "FeeTypeID"
});
theModel.RangesModel = new Business.FeesGridModel(Business.FeesGridModel.Mode.Ranges, new List <string> {
"ParentFeeID"
});
return(View(theModel));
}
public JsonResult removeFeeData([FromBody] int[] ids)
{
var respuesta = new { message = "OK", error = "", DataReceived = JsonConvert.SerializeObject(ids), OldData = "" };
try
{
using (QuotingToolRepository db = new QuotingToolRepository())
{
foreach (int id in ids)
{
db.Fees.DeleteObject(db.Fees.Where(i => i.FeeID == id).Single());
}
db.SaveChanges();
}
}
catch (Exception ex)
{
Response.StatusCode = 500;
respuesta = new { message = "ERROR", error = ex.Message, DataReceived = JsonConvert.SerializeObject(ids), OldData = "" };
}
return(Json(respuesta, JsonRequestBehavior.AllowGet));
}
public JsonResult getActions()
{
using (QuotingToolRepository db = new QuotingToolRepository())
{
var fakeRepository = new List <ActionMock>();
fakeRepository.Add(new ActionMock {
ActionID = 1, Description = "Fee"
});
fakeRepository.Add(new ActionMock {
ActionID = 2, Description = "Surcharge"
});
fakeRepository.Add(new ActionMock {
ActionID = 3, Description = "Discount"
});
fakeRepository.Add(new ActionMock {
ActionID = 4, Description = "Waiver"
});
var dataSet = fakeRepository.Select(action => new { value = action.ActionID, label = action.Description.Trim().ToUpper() }).ToList();
return(Json(dataSet, JsonRequestBehavior.AllowGet));
}
}
public JsonResult getFeeData([FromBody] Business.AGRequestModel request)
{
using (QuotingToolRepository db = new QuotingToolRepository())
{
object entities = null;
var query = db.Fees.Select(fee => new Business.FeeDataModel
{
FeeID = fee.FeeID,
ParentFeeID = fee.ParentFeeID,
FeeTypeID = fee.FeeTypeID,
StateID = fee.StateID,
IslandID = fee.IslandID,
CityID = fee.CityID,
ZoneID = fee.ZoneID,
ZipCodes = fee.ZipCodes,
Value = fee.Value,
ActionID = fee.ActionID,
ByUomID = fee.ByUomID,
Discount = fee.Discount,
FeeMin = fee.FeeMin,
FeeMax = fee.FeeMax,
ValidFrom = fee.ValidFrom,
ValidUntil = fee.ValidUntil,
RangeByUomID = fee.RangeByUomID,
RangeFrom = fee.RangeFrom,
RangeTo = fee.RangeTo
});
if (request.whereClause != null && request.whereClause.Length > 0)
{
foreach (Business.AGRequestModel.WherePredicate predicate in request.whereClause)
{
int intTemp;
int?intValue = null;
switch (predicate.Field)
{
case "ParentFeeID":
if (Int32.TryParse(predicate.Value, out intTemp))
{
intValue = intTemp;
}
if (intValue == null)
{
query = query.Where(fee => fee.ParentFeeID == null);
}
else
{
query = query.Where(fee => fee.ParentFeeID == intValue);
}
break;
case "StateID":
if (Int32.TryParse(predicate.Value, out intTemp))
{
intValue = intTemp;
}
if (intValue != null)
{
query = query.Where(fee => fee.StateID == intValue);
}
break;
case "FeeTypeID":
if (Int32.TryParse(predicate.Value, out intTemp))
{
intValue = intTemp;
}
if (intValue != null)
{
query = query.Where(fee => fee.FeeTypeID == intValue);
}
break;
case "ByUomID":
if (Int32.TryParse(predicate.Value, out intTemp))
{
intValue = intTemp;
}
if (intValue != null)
{
query = query.Where(fee => fee.ByUomID == intValue);
}
break;
}
}
}
var repo = query.ToList();
if (request.endRow == 0)
{
entities = repo;
}
else
{
var itemsToTake = (request.endRow >= repo.Count() ? repo.Count() : request.endRow) - request.startRow;
entities = repo.Skip(request.startRow).Take(itemsToTake);
}
return(Json(new { rows = entities, rowsTotalQuantity = repo.Count() }, JsonRequestBehavior.AllowGet));
}
}
