public DetailDto getPosision(String id)
{
Position position = db.Position.Where(s => s.Id == id).FirstOrDefault();
DetailDto positionDto = new DetailDto(position.Id, position.Name);
return(positionDto);
}
public DetailDto getStatus(String id)
{
status status = db.status.Where(s => s.id == id).FirstOrDefault();
DetailDto dto = new DetailDto(status.id, status.name);
return(dto);
}
public DetailDto getSimpleStaff(int id)
{
staff staff = db.staffs.Where(s => s.id == id).FirstOrDefault();
DetailDto dto = new DetailDto(staff.id.ToString(), staff.name);
return(dto);
}
public IActionResult Update([FromBody] DetailDto value)
{
Car car = value;
if (String.IsNullOrWhiteSpace(car.Id))
{
return(BadRequest(new ErrorModel
{
Message = "Cannot update not existing car!"
}));
}
Car found = _repo.Find(value.Id);
if (found is null)
{
return(ValidationProblem("Car not found!"));
}
found.Brand = car.Brand;
found.Model = car.Model;
found.Colour = car.Colour;
found.LicensePlate = car.LicensePlate;
found.EngineDescription = car.EngineDescription;
found.Mileage = car.Mileage;
if (!String.IsNullOrWhiteSpace(car.PremiseId))
{
found.PremiseId = car.PremiseId;
}
_repo.Save();
return(Ok());
}
public DetailDto getPosision(String id)
{
position position = db.positions.Where(s => s.id == id).FirstOrDefault();
DetailDto positionDto = new DetailDto(position.id, position.name);
return(positionDto);
}
public DetailDto getSupplier(String id)
{
Supplier supplier = db.Supplier.Where(s => s.Id == id).FirstOrDefault();
DetailDto dto = new DetailDto(supplier.Id, supplier.Name);
return(dto);
}
public DetailDto getMaterialType(String id)
{
material_type type = db.material_type.Where(s => s.id == id).FirstOrDefault();
DetailDto dto = new DetailDto(type.id, type.name);
return(dto);
}
public DetailDto GetPurchases(string detailValues, string accountNumber, string mrcDataSpName, string serviceId, int dateDueMonth, int dateDueYear)
{
DetailDto mrcData = null;
var purchasesRegex = new Regex(Constants.PurchasesRegex).Match(detailValues);
if (purchasesRegex.Success)
{
mrcData = new DetailDto();
var purchasesRegexGroup = purchasesRegex.Groups;
var begYear = Convert.ToInt32(purchasesRegexGroup[1].ToString()) >= 1 && Convert.ToInt32(purchasesRegexGroup[1].ToString()) <= dateDueMonth ? dateDueYear : dateDueYear - 1;
mrcData.UNIQ_ID = Constants.OCC;
mrcData.CHG_CLASS = Constants.LevelOne;
mrcData.ACCT_LEVEL = accountNumber.Replace(Constants.Hyphen, string.Empty);
mrcData.ACCT_LEVEL_2 = Constants.VerizonWireless;
mrcData.SP_NAME = mrcDataSpName.TrimStart();
mrcData.SUBSCRIBER = serviceId;
mrcData.CHG_CODE_1 = purchasesRegexGroup[4].ToString().Replace(Constants.Pipe, ' ').Trim();
mrcData.BEG_CHG_DATE = new DateTime(begYear, Convert.ToInt32(purchasesRegexGroup[1].ToString()), Convert.ToInt32(purchasesRegexGroup[2].ToString())).ToString("M/d/yyyy");
mrcData.END_CHG_DATE = new DateTime(begYear, Convert.ToInt32(purchasesRegexGroup[1].ToString()), Convert.ToInt32(purchasesRegexGroup[2].ToString())).ToString("M/d/yyyy");;
mrcData.CHG_AMT = Utils.NumberFormat(purchasesRegexGroup[6].ToString());
mrcData.CURRENCY = Constants.USD;
mrcData.SP_INV_RECORD_TYPE = Constants.PURCHASES;
}
return(mrcData);
}
public ActionResult Details(int id)
{
ISongsRepository <SongDto> songsRepo = Container.Resolve <ISongsRepository <SongDto> >(DefaultRepository);
DetailDto songDetail = songsRepo.Details(id, User.Identity.GetUserId());
return(View(songDetail));
}
public void Update(DetailDto data)
{
Detail result = _mapper.Map <DetailDto, Detail>(data);
result.DeleteDate = null;
_dalFactory.DetailDal.UpdateVoid(result, result.Id);
}
public DetailDto GetTaxesGovermentalSurcharges(string surValues, string accountNumber, string mrcDataSpName, string serviceId)
{
DetailDto usgsumDetail = null;
var taxesGovernmentalSurchargesRegex = new Regex(Constants.TaxesGovernmentalSurchargesRegex).Match(surValues);
if (taxesGovernmentalSurchargesRegex.Success)
{
var regexGroup = taxesGovernmentalSurchargesRegex.Groups;
usgsumDetail = new DetailDto();
usgsumDetail.UNIQ_ID = Constants.TAX;
usgsumDetail.CHG_CLASS = Constants.LevelOne;
usgsumDetail.ACCT_LEVEL = accountNumber.Replace(Constants.Hyphen, string.Empty);
usgsumDetail.ACCT_LEVEL_2 = Constants.VerizonWireless;
usgsumDetail.SP_NAME = mrcDataSpName.TrimStart();
usgsumDetail.SUBSCRIBER = serviceId;
usgsumDetail.CHG_CODE_1 = regexGroup[3].ToString();
usgsumDetail.CHG_AMT = Utils.NumberFormat(regexGroup[4].ToString());
usgsumDetail.CURRENCY = Constants.USD;
usgsumDetail.INFO_ONLY_IND = "N";
usgsumDetail.SP_INV_RECORD_TYPE = Constants.TaxesType;
}
return(usgsumDetail);
}
public DetailDto GetMessaging(string messagingValues, string mrcDataSpName, string serviceId, string accountNumber, string type)
{
DetailDto usgsumDetail = null;
var messagingArray = messagingValues.Split(Constants.Pipe);
var internationalMessageRegex = new Regex(Constants.InternationalMessageRegex).Match(messagingValues);
if (internationalMessageRegex.Success)
{
usgsumDetail = new DetailDto();
var purchasesRegexGroup = internationalMessageRegex.Groups;
var planeName = purchasesRegexGroup[1].ToString();
usgsumDetail.UNIQ_ID = Constants.USGSUM;
usgsumDetail.CHG_CLASS = Constants.LevelOne;
usgsumDetail.ACCT_LEVEL = accountNumber.Replace(Constants.Hyphen, string.Empty);
usgsumDetail.ACCT_LEVEL_2 = Constants.VerizonWireless;
usgsumDetail.SP_NAME = mrcDataSpName.TrimStart();
usgsumDetail.SUBSCRIBER = serviceId;
usgsumDetail.CHG_CODE_1 = planeName;
usgsumDetail.CHG_QTY1_ALLOWED = messagingValues.Contains("unlimited") ? "" : Utils.NumberFormat(purchasesRegexGroup[6].ToString().Replace(Constants.Hyphen, string.Empty));
usgsumDetail.CHG_QTY1_TYPE = Utils.GetChargesType(purchasesRegexGroup[2].ToString());
usgsumDetail.CHG_QTY1_USED = Utils.NumberFormat(purchasesRegexGroup[8].ToString().Replace(Constants.Hyphen, string.Empty));
usgsumDetail.CHG_QTY1_BILLED = purchasesRegexGroup[10].ToString().Replace(Constants.Hyphen, string.Empty).Equals(string.Empty) ? "0" : Utils.NumberFormat(purchasesRegexGroup[10].ToString());
usgsumDetail.CHG_AMT = purchasesRegexGroup[12].ToString().Contains("--") ? "0" : Utils.NumberFormat(purchasesRegexGroup[12].ToString().Replace(Constants.MoneySign, string.Empty));
usgsumDetail.CURRENCY = Constants.USD;
usgsumDetail.INFO_ONLY_IND = "N";
usgsumDetail.SP_INV_RECORD_TYPE = type;
}
return(usgsumDetail);
}
public DetailDto getMaterialType(String id)
{
MaterialType type = db.MaterialType.Where(s => s.Id == id).FirstOrDefault();
DetailDto dto = new DetailDto(type.Id, type.Name);
return(dto);
}
public DetailDto getSupplier(String id)
{
supplier supplier = db.suppliers.Where(s => s.id == id).FirstOrDefault();
DetailDto dto = new DetailDto(supplier.id, supplier.name);
return(dto);
}
public DetailDto getSimpleStaff(long id)
{
Staff staff = db.Staff.Where(s => s.Id == id).FirstOrDefault();
DetailDto dto = new DetailDto(staff.Id.ToString(), staff.Name);
return(dto);
}
public DetailDto getSimpleStaff(String accessToken)
{
staff staff = db.staffs.Where(s => s.auth_token == accessToken).FirstOrDefault();
DetailDto dto = new DetailDto(staff.id.ToString(), staff.name);
return(dto);
}
public DetailDto GetOtherChargesCredits(string detailValues, string mrcDataSpName, string serviceId, string accountNumber)
{
DetailDto usgsumDetail = null;
var therChargesCreditsRegex = new Regex(Constants.OtherChargesCreditsRegex).Match(detailValues);
if (therChargesCreditsRegex.Success)
{
usgsumDetail = new DetailDto();
var voiceRegexGroup = therChargesCreditsRegex.Groups;
usgsumDetail.UNIQ_ID = Constants.OCC;
usgsumDetail.CHG_CLASS = Constants.LevelOne;
usgsumDetail.ACCT_LEVEL = accountNumber.Replace(Constants.Hyphen, string.Empty);
usgsumDetail.ACCT_LEVEL_2 = Constants.VerizonWireless;
usgsumDetail.SP_NAME = mrcDataSpName.TrimStart();
usgsumDetail.SUBSCRIBER = serviceId;
usgsumDetail.CHG_CODE_1 = voiceRegexGroup[1].ToString().Replace(Constants.StringPipe, Constants.WhiteSpace);
usgsumDetail.CHG_AMT = Utils.NumberFormat(voiceRegexGroup[4].ToString());
usgsumDetail.CURRENCY = Constants.USD;
usgsumDetail.SP_INV_RECORD_TYPE = Constants.Equipment;
}
return(usgsumDetail);
}
public DetailDto getTransactionType(String id)
{
transaction_type transaction_Type = db.transaction_type.Where(s => s.id == id).FirstOrDefault();
DetailDto dto = new DetailDto(transaction_Type.id, transaction_Type.name);
return(dto);
}
public DetailDto getSimpleMaterial(int id)
{
material m = db.materials.Where(s => s.id == id).FirstOrDefault();
DetailDto materialDto = new DetailDto(m.id.ToString(), m.name);
return(materialDto);
}
public IActionResult Add([FromBody] DetailDto value)
{
Car car = value;
if (String.IsNullOrWhiteSpace(car.PremiseId))
{
return(BadRequest(new ErrorModel
{
Message = "Premise MUST be chosen!"
}));
}
try
{
if (_repo.CarExists(car))
{
return(Conflict("Car already exists!"));
}
}
catch (ArgumentNullException ex)
{
return(BadRequest(new ErrorModel
{
Message = ex.Message,
CauseValue = nameof(value)
}));
}
_repo.Add(value);
_repo.Save();
return(Ok());
}
public DetailDto GetVoice(string detailValues, string mrcDataSpName, string serviceId, string accountNumber, bool shared)
{
DetailDto usgsumDetail = null;
var usageVoiceRegex = new Regex(Constants.UsageVoiceRegex).Match(detailValues);
if (usageVoiceRegex.Success)
{
usgsumDetail = new DetailDto();
var voiceRegexGroup = usageVoiceRegex.Groups;
usgsumDetail.UNIQ_ID = Constants.USGSUM;
usgsumDetail.CHG_CLASS = Constants.LevelOne;
usgsumDetail.ACCT_LEVEL = accountNumber.Replace(Constants.Hyphen, string.Empty);
usgsumDetail.ACCT_LEVEL_2 = Constants.VerizonWireless;
usgsumDetail.SP_NAME = mrcDataSpName.TrimStart();
usgsumDetail.SUBSCRIBER = serviceId;
usgsumDetail.CHG_CODE_1 = voiceRegexGroup[1].ToString().Replace("|", string.Empty);
usgsumDetail.CHG_QTY1_TYPE = Utils.GetChargesType(voiceRegexGroup[2].ToString());
usgsumDetail.CHG_QTY1_USED = voiceRegexGroup[5].ToString();
usgsumDetail.CHG_QTY1_ALLOWED = voiceRegexGroup[3].ToString().Contains("unlimited") ? string.Empty : (voiceRegexGroup[4].ToString().Contains("--") ? string.Empty : voiceRegexGroup[4].ToString().Replace("|", string.Empty));
usgsumDetail.CHG_QTY1_BILLED = voiceRegexGroup[3].ToString().Contains("unlimited") ? (voiceRegexGroup[5].ToString().Contains("--") ? string.Empty : voiceRegexGroup[5].ToString()) : (voiceRegexGroup[6].ToString().Contains("--") ? string.Empty : voiceRegexGroup[6].ToString());
usgsumDetail.CHG_AMT = voiceRegexGroup[7].ToString().Contains("--") ? "0" : string.IsNullOrEmpty(voiceRegexGroup[7].ToString()) ? "0" : Utils.NumberFormat(voiceRegexGroup[7].ToString());
usgsumDetail.CURRENCY = Constants.USD;
usgsumDetail.SHARE_IND = shared ? "True" : string.Empty;
usgsumDetail.ROAM_IND = voiceRegexGroup[1].ToString().Contains("Roaming") ? "True" : string.Empty;
usgsumDetail.INFO_ONLY_IND = "N";
usgsumDetail.SP_INV_RECORD_TYPE = Constants.VOICE;
}
else
{
var voiceRegex = new Regex(Constants.VoiceRegex).Match(detailValues);
if (voiceRegex.Success)
{
usgsumDetail = new DetailDto();
var voiceRegexGroup = voiceRegex.Groups;
usgsumDetail.UNIQ_ID = Constants.USGSUM;
usgsumDetail.CHG_CLASS = Constants.LevelOne;
usgsumDetail.ACCT_LEVEL = accountNumber.Replace(Constants.Hyphen, string.Empty);
usgsumDetail.ACCT_LEVEL_2 = Constants.VerizonWireless;
usgsumDetail.SP_NAME = mrcDataSpName.TrimStart();
usgsumDetail.SUBSCRIBER = serviceId;
usgsumDetail.CHG_CODE_1 = voiceRegexGroup[1].ToString();
usgsumDetail.CHG_AMT = Utils.NumberFormat(voiceRegexGroup[2].ToString());
usgsumDetail.CURRENCY = Constants.USD;
usgsumDetail.SP_INV_RECORD_TYPE = Constants.VOICE;
}
}
return(usgsumDetail);
}
public CheckStoreDto(int id, DetailDto simpleStore, DetailDto simpleStaff, DateTime time, List <TransactionMaterialAmountDto> detail)
{
this.id = id;
this.simpleStore = simpleStore;
this.simpleStaff = simpleStaff;
Time = time;
this.detail = detail;
}
internal List <DetailDto> getSuplliers()
{
List <DetailDto> detailDtos = new List <DetailDto>();
List <Supplier> suppliers = db.Supplier.ToList();
foreach (Supplier supplier in suppliers)
{
DetailDto dto = new DetailDto(supplier.Id, supplier.Name);
detailDtos.Add(dto);
}
return(detailDtos);
}
internal List <DetailDto> getSimpleStore()
{
List <Store> stores = db.Store.ToList();
List <DetailDto> storeDtos = new List <DetailDto>();
foreach (Store store in stores)
{
DetailDto detail = getSimpleStoreDto(store.Id);
storeDtos.Add(detail);
}
return(storeDtos);
}
public DetailDto GetSurcharges(string dataValues, string mrcDataSpName, string serviceId, string accountNumber)
{
var dateRegex = new Regex(Constants.SurchargesRegex2).Match(dataValues);
DetailDto usgsumDetail = null;
if (dateRegex.Success)
{
var surchargesGroup = dateRegex.Groups;
usgsumDetail = new DetailDto();
usgsumDetail.UNIQ_ID = Constants.SUR;
usgsumDetail.CHG_CLASS = Constants.LevelOne;
usgsumDetail.ACCT_LEVEL = accountNumber.Replace(Constants.Hyphen, string.Empty);
usgsumDetail.ACCT_LEVEL_1 = "";
usgsumDetail.ACCT_LEVEL_2 = Constants.VerizonWireless;
usgsumDetail.SP_NAME = mrcDataSpName.TrimStart();
usgsumDetail.SUBSCRIBER = serviceId;
usgsumDetail.CHG_CODE_1 = surchargesGroup[2].ToString().Replace(Constants.Pipe, ' ');
usgsumDetail.CHG_AMT = Utils.NumberFormat(surchargesGroup[4].ToString());
usgsumDetail.CURRENCY = Constants.USD;
usgsumDetail.INFO_ONLY_IND = "N";
usgsumDetail.SP_INV_RECORD_TYPE = Constants.SurchargesType;
}
else
{
var dateRegex2 = new Regex(Constants.SurchargesRegex).Match(dataValues);
if (dateRegex2.Success)
{
var surchargesGroup = dateRegex2.Groups;
usgsumDetail = new DetailDto();
usgsumDetail.UNIQ_ID = Constants.SUR;
usgsumDetail.CHG_CLASS = Constants.LevelOne;
usgsumDetail.ACCT_LEVEL = accountNumber.Replace(Constants.Hyphen, string.Empty);
usgsumDetail.ACCT_LEVEL_1 = "";
usgsumDetail.ACCT_LEVEL_2 = Constants.VerizonWireless;
usgsumDetail.SP_NAME = mrcDataSpName.TrimStart();
usgsumDetail.SUBSCRIBER = serviceId;
usgsumDetail.CHG_CODE_1 = surchargesGroup[2].ToString().Replace(Constants.Pipe, ' ');
usgsumDetail.CHG_AMT = Utils.NumberFormat(surchargesGroup[3].ToString());
usgsumDetail.CURRENCY = Constants.USD;
usgsumDetail.INFO_ONLY_IND = "N";
usgsumDetail.SP_INV_RECORD_TYPE = Constants.SurchargesType;
}
}
return(usgsumDetail);
}
public dynamic RemoveDeviceToken([FromBody] DetailDto dto)
{
Staff staff = db.Staff.FirstOrDefault(s => s.Id == long.Parse(dto.id));
if (staff == null)
{
return(false);
}
staff.DeviceToken = null;
db.Entry(staff).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
return(true);
}
public DResult AddDetail(string wikiId, DetailDto detail)
{
if (!Wikis.Exists(w => w.Id == wikiId))
return DResult.Error("词条不存在!");
var item = detail.MapTo<WikiDetail>();
item.Id = CombHelper.Guid16;
item.WikiId = wikiId;
item.Sort = Details.Max(d => d.Sort, d => d.WikiId == wikiId) + 1;
var result = Details.Insert(item);
return string.IsNullOrWhiteSpace(result)
? DResult.Error("添加词条详情失败！")
: DResult.Success;
}
public IActionResult Update(DetailDto data)
{
try
{
_bllFactory.DetailBll.Update(data);
return(Ok());
}
catch (ValidationException ex)
{
ModelState.AddModelError("error", ex.Message);
return(BadRequest(ModelState));
}
}
public DetailDto getSimpleStoreDto(String id)
{
DetailDto storeDto = null;
try
{
store store = db.stores.Where(s => s.id == id).FirstOrDefault();
storeDto = new DetailDto(store.id, store.name);
}
catch (Exception e)
{
}
return(storeDto);
}
public DetailDto getSimpleStoreDto(String id)
{
DetailDto storeDto = null;
try
{
Store store = db.Store.Where(s => s.Id == id).FirstOrDefault();
storeDto = new DetailDto(store.Id, store.Name);
}
catch (Exception e)
{
return(null);;
}
return(storeDto);
}
public ActionResult Detail(Guid id)
{
var model = new DetailDto {
Match = MatchDto.Single(id)
};
var query = _repo.Query <BetView>(x => x.CasinoItem.MatchGuid == id)
.Many <BetView, BetDetail, int>(t => t.ID);
var mapper = BetDto.ConfigMapper().CreateMapper();
var list = mapper.Map <IEnumerable <BetDto> >(query.AsEnumerable());
model.Bets = list;
return(View(model));
}
public ActionResult Detail(Guid id)
{
var model = new DetailDto { Match = MatchDto.Single(id) };
var query = _repo.Query<BetView>(x => x.CasinoItem.MatchGuid == id)
.Many<BetView, BetDetail, int>(t => t.ID);
var mapper = BetDto.ConfigMapper().CreateMapper();
var list = mapper.Map<IEnumerable<BetDto>>(query.AsEnumerable());
model.Bets = list;
return View(model);
}
