public ChangeOrAddItemViewModel(ItemModelBase?item = null)
{
this._definition = (this.Item = item)?.Definition ?? Amalur.ItemDefinitions.Values.First();
this._category = item?.Category ?? ChangeOrAddItemViewModel._defaultCategory;
this.ProcessCommand = new DelegateCommand(this.Process, () => this._definition != null);
this.OnFilterChanged();
}
public WeaponBase(string name, Money money, double weight, EquipmentCategory category, List<EquipmentType> types, int baseDamage, int hitModifier, int criticalModifier)
: base(name, money, weight, category, types)
{
BaseDamage = baseDamage;
CriticalModifier = criticalModifier;
HitModifier = hitModifier;
}
public void MergeExpressionTest()
{
// arrange
var options = new DbContextOptionsBuilder <Context>().UseInMemoryDatabase("test data base").Options;
var context = new Context(options);
var service = new EquipmentInfoService(context);
var eq1 = new EquipmentCategory {
Id = 1, Name = "test name"
};
context.EquipmentCategory.Add(eq1);
context.EquipmentInfo.Add(new EquipmentInfo {
EquipmentCategoryNav = eq1, Name = "asds", Id = 1
});
// act
context.SaveChanges();
var res1 = service.GetInfoExtCategoryNames().First();
var res2 = service.GetInfoExtCategoryNamesMerge().First();
// assert
Assert.IsTrue(res1.CategoryName == eq1.Name);
Assert.IsTrue(res2.CategoryName == eq1.Name);
;
}
public ActionResult DeleteConfirmed(int id)
{
EquipmentCategory equipmentCategory = db.EquipmentCategories.Find(id);
db.EquipmentCategories.Remove(equipmentCategory);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ChangeOrAddItemViewModel(GameSave gameSave, ItemModelBase?item = null)
{
this._category = item?.Category ?? ChangeOrAddItemViewModel._defaultCategory;
this._definition = (this.Item = item)?.Definition ?? gameSave.ItemDefinitions.First();
this.GameSave = gameSave;
this.ProcessCommand = new(this.Process, () => this._definition != null);
this.OnFilterChanged();
}
public async Task <JsonResult> Delete([FromBody] EquipmentCategory equipmentCategory)
{
await CheckPermission();
var cer = new CategoryEquipmentRepository(_logger);
await cer.Delete(equipmentCategory.Id);
return(Json(new { message = "Delete OK" }));
}
public List <Package> Read()
{
DataHandler dh = new DataHandler();
List <Package> packageList = new List <Package>();
// 0 1 2 3 4 5 6 7 8 9
string query = "SELECT P.PackageID, P.pName, P.pDescription, S.ServiceID, S.expectedDuration, S.sDescription, SLA.ServiceLevelAgreementID, SLA.slaDescription, P.EquipmentCategoryID , EC.CategoryName FROM Package P " +
"LEFT JOIN Service S ON S.ServiceID = P.ServiceID " +
"LEFT JOIN ServiceLevelAgreement SLA ON SLA.ServiceLevelAgreementID = P.ServiceLevelAgreementID " +
"LEFT JOIN EquipmentCategory EC ON EC.EquipmentCategoryID = P.EquipmentCategoryID ";
SqlDataReader read = dh.Select(query);
EquipmentCategory category;
Service service;
ServiceLevelAgreement serviceLevelAgreement;
Package package;
if (read.HasRows)
{
while (read.Read())
{
service = new Service(
read.GetString(5),
read.GetInt32(4)
);
service.Id = read.GetInt32(3);
serviceLevelAgreement = new ServiceLevelAgreement(
read.GetString(7)
);
serviceLevelAgreement.Id = read.GetInt32(6);
category = new EquipmentCategory(
read.GetString(9)
);
category.Id = read.GetInt32(8);
package = new Package(
read.GetString(1),
read.GetString(2),
service,
serviceLevelAgreement,
category
);
package.Id = read.GetInt32(0);
packageList.Add(package);
}
}
dh.Dispose();
return(packageList);
}
public void CreateEquipmentCategory(CreateCategoryDto createCategory)
{
EquipmentCategory category = _mapper.Map <EquipmentCategory>(createCategory);
ImageFile image = JsonConvert.DeserializeObject <ImageFile>(createCategory.image.ToString());
category.image = Convert.FromBase64String(image.value);
_repositoryFactory.EquipmentRepository.CreateEquipmentCategory(category);
_logger.LogInformation("Equipment category created successfully");
}
public ActionResult Edit([Bind(Include = "EquipmentCategoryId,EquipmentCategoryName,EquipmentCategoryIsReusable,EquipmentCategoryInUseCount,EquipmentCategoryThreshold")] EquipmentCategory equipmentCategory)
{
if (ModelState.IsValid)
{
db.Entry(equipmentCategory).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(equipmentCategory));
}
public ActionResult Edit([Bind(Include = "Id,Code,Description")] EquipmentCategory equipmentCategory)
{
if (ModelState.IsValid)
{
db.Entry(equipmentCategory).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(equipmentCategory));
}
public ActionResult Create(EquipmentCategory category)
{
if (ModelState.IsValid)
{
_equipmentCategoryDao.Create(category);
return(RedirectToAction("Index", "EquipmentCategory"));
}
ViewBag.categories = _categories;
return(View("Index"));
}
public static ContainerIdentification From(this ContainerIdentification containerIdentification,
OwnerCode ownerCode,
EquipmentCategory equipmentCategory,
SerialNumber serialNumber)
{
containerIdentification.OwnerCode = ownerCode;
containerIdentification.EquipmentCategory = equipmentCategory;
containerIdentification.SerialNumber = serialNumber;
return(containerIdentification);
}
public ActionResult Create([Bind(Include = "Id,Code,Description")] EquipmentCategory equipmentCategory)
{
if (ModelState.IsValid)
{
db.EquipmentCategories.Add(equipmentCategory);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(equipmentCategory));
}
public ActionResult Create([Bind(Include = "EquipmentCategoryId,EquipmentCategoryName,EquipmentCategoryIsReusable,EquipmentCategoryQuantity,EquipmentCategoryThreshold")] EquipmentCategory equipmentCategory)
{
if (ModelState.IsValid)
{
db.EquipmentCategories.Add(equipmentCategory);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(equipmentCategory));
}
private void btnAddPackage1_Click(object sender, EventArgs e)
{
//Here we call from the Service Contract logic
if (txtPDiscript.Text.Equals(""))
{
MessageBox.Show("Please enter Package description details", "EMPTY FIELDS!!",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}//Data validation
if (txtPName.Text.Equals(""))
{
MessageBox.Show("Please enter package name details", "EMPTY FIELDS!!",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}//Data Validation
if (cmbPService.SelectedIndex < 0)
{
MessageBox.Show("Please Select a Service", "EMPTY VALUE!!",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (cmbPSLA.SelectedIndex < 0)
{
MessageBox.Show("Please Select a Service Level Agreemnt", "EMPTY VALUE!!",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
Description = txtPDiscript.Text;
Name = txtPName.Text;
service = Placeholder_Service_List[cmbPService.SelectedIndex];
sla = Placeholder_SLA_List[cmbPSLA.SelectedIndex];
EQC = Placeholder_EQC_List[cbxEquitptmentCatagory.SelectedIndex];
/*
* ! You were here last
*
*/
newPackage = new Package(Name, Description, service, sla, EQC);
P_L.Addpackage(newPackage);
MessageBox.Show("Service successfully Added", " ADD",
MessageBoxButtons.OK, MessageBoxIcon.Information);
//Perform Fom transition
Hide();
frmServiceContract form = new frmServiceContract();
form.ShowDialog();
}
}//Add a Package
public IHttpActionResult UpdateEquipment([FromBody] EquipmentCategory eqiupment)
{
try
{
_equipementCategoryService.UpdateEquipmentCategory(eqiupment);
return(Ok());
}
catch (System.Exception e)
{
return(InternalServerError(e));
}
}
public ucEquipmentEntry()
{
InitializeComponent();
luColEquipNum.DataSource = Equipment.ListForCompany().Select(e => new
{
EqpNum = e.EqpNum,
AssetCode = e.AssetCode,
DisplayName = e.DisplayName,
Class = EquipmentClass.GetEquipmentClass(e.ClassCode)?.Desc,
Category = EquipmentCategory.GetEquipmentCategory(e.CategoryCode)?.Desc
}).ToList();
luColAssertNum.DataSource = Equipment.ListForCompany().Select(e => new
{
EqpNum = e.EqpNum,
AssetCode = e.AssetCode,
DisplayName = e.DisplayName,
Class = EquipmentClass.GetEquipmentClass(e.ClassCode)?.Desc,
Category = EquipmentCategory.GetEquipmentCategory(e.CategoryCode)?.Desc
}).ToList();
var level1CodeList = LevelOneCode.ListForCompany().Select(code => new { MatchId = code.MatchId, Code = code.Code, Desc = code.Desc, DisplayName = code.DisplayName }).Distinct().ToList();
luColLevel1All.DataSource = level1CodeList.OrderBy(x => x.MatchId);
var level2CodeList = LevelTwoCode.ListForCompany().Select(code => new { MatchId = code.MatchId, Code = code.Code, Desc = code.Desc, DisplayName = code.DisplayName }).Distinct().ToList();
luColLevel2All.DataSource = level2CodeList.OrderBy(x => x.MatchId);
var level3CodeList = LevelThreeCode.ListForCompany().Select(code => new { MatchId = code.MatchId, Code = code.Code, Desc = code.Desc, DisplayName = code.DisplayName }).Distinct().ToList();
luColLevel3All.DataSource = level3CodeList.OrderBy(x => x.MatchId);
var level4CodeList = LevelFourCode.ListForCompany().Select(code => new { MatchId = code.MatchId, Code = code.Code, Desc = code.Desc, DisplayName = code.DisplayName }).Distinct().ToList();
luColLevel4All.DataSource = level4CodeList.OrderBy(x => x.MatchId);
luColBillCycleAll.DataSource = Enum.GetValues(typeof(EnumBillCycle)).Cast <EnumBillCycle>().Select(x => new { Enum = (char)x, Desc = Enum.GetName(typeof(EnumBillCycle), x) });
int maxLevel = Company.GetCurrCompany().MaxLevelCode;
var SetColumn = new Action <GridColumn, int, string>((col, level, caption) =>
{
col.Visible = maxLevel >= level;
col.OptionsColumn.ShowInCustomizationForm = maxLevel >= level;
col.Caption = caption;
});
SetColumn(colLevel4Code, 4, Company.GetCurrCompany().Level4CodeDesc);
SetColumn(colLevel3Code, 3, Company.GetCurrCompany().Level3CodeDesc);
SetColumn(colLevel2Code, 2, Company.GetCurrCompany().Level2CodeDesc);
SetColumn(colLevel1Code, 1, Company.GetCurrCompany().Level1CodeDesc);
}
public ArmorBase(
string name, Money money, EquipmentCategory category, List<EquipmentType> type, double weight,
int armorValue, int staminaBoost, int strengthBoost, int agilityBoost, int intelligenceBoost, int wisdomBoost
)
: base(name, money, weight, category, type)
{
ArmorValue = armorValue;
StaminaBoost = staminaBoost;
StrengthBoost = strengthBoost;
AgilityBoost = agilityBoost;
IntelligenceBoost = intelligenceBoost;
WisdomBoost = wisdomBoost;
}
public static CheckedContainerIdentification From(this CheckedContainerIdentification containerIdentification,
OwnerCode ownerCode,
EquipmentCategory equipmentCategory,
SerialNumber serialNumber,
CheckDigit checkDigit)
{
containerIdentification.OwnerCode = ownerCode;
containerIdentification.EquipmentCategory = equipmentCategory;
containerIdentification.SerialNumber = serialNumber;
containerIdentification.CheckDigit = checkDigit;
return(containerIdentification);
}
// GET: EquipmentCategories/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EquipmentCategory equipmentCategory = db.EquipmentCategories.Find(id);
if (equipmentCategory == null)
{
return(HttpNotFound());
}
return(View(equipmentCategory));
}
private void DeleteChildrenCategories(EquipmentCategory category)
{
var categories = GetCategoriesByParentId(category.Id);
foreach (var equipmentCategory in categories)
{
var info = _repository.Query <EquipmentInfo>().Where(x => x.EquipmentCategory == category).ToList();
foreach (var i in info)
{
_repository.Execute("Delete from EquipmentInfoColumnValue Where EquipmentInfoId = " + i.Id);
_repository.Execute("Delete from EquipmentInfo Where Id = " + i.Id);
}
_repository.Execute("Delete from EquipmentCategoryColumn Where EquipmentCategoryId = " + equipmentCategory.Id);
_repository.Execute("Delete from EquipmentCategory Where Id = " + equipmentCategory.Id);
}
}
public static string GetEquipmentCategoryStandardString(EquipmentCategory equipmentCategory)
{
switch (equipmentCategory)
{
case EquipmentCategory.J:
return(Constants.EquipmentCategoryJStandardString);
case EquipmentCategory.U:
return(Constants.EquipmentCategoryUStandardString);
case EquipmentCategory.Z:
return(Constants.EquipmentCategoryZStandardString);
default:
throw new ArgumentException(EnumHelper.UnexpectedEnumerationValueMessage(equipmentCategory), nameof(equipmentCategory));
}
}
static EquipmentCategoryExtensions()
{
// Build all parents
foreach (EquipmentCategory root in immediateParents.Keys)
{
List <EquipmentCategory> parents = new List <EquipmentCategory>()
{
default(EquipmentCategory)
};
for (EquipmentCategory parent = immediateParents.GetValueOrDefault(root); parent != default(EquipmentCategory) && !parents.Contains(parent); parent = immediateParents.GetValueOrDefault(parent))
{
parents.Add(parent);
}
allParents[root] = parents;
}
}
public ActionResult Edit(EquipmentCategory category)
{
if (ModelState.IsValid)
{
EquipmentCategory cat = _equipmentCategoryDao.GetById(category.Id);
cat.Title = category.Title;
cat.Description = category.Description;
_equipmentCategoryDao.Update(cat);
return(RedirectToAction("Index", "EquipmentCategory"));
}
ViewBag.categories = _categories;
EquipmentCategory ec = _equipmentCategoryDao.GetById(category.Id);
return(View("Detail", ec));
}
public void SaveCategory([FromBody] EquipmentCategory model)
{
var set = _db.Set <EquipmentCategory>();
var domain = set.Find(model.Id);
if (domain == null)
{
domain = model;
set.Add(domain);
}
else
{
domain.Name = model.Name;
domain.ParentId = model.ParentId;
set.Update(domain);
}
_db.SaveChanges();
}
public List <Equipment> ReadChildren(Client parent)
{
DataHandler dh = new DataHandler();
List <Equipment> equipmentList = new List <Equipment>();
string query = String.Format(
"SELECT EquipmentID, SerialNumber, Manufacturer, E.EquipmentCategoryID, EC.CategoryName " +
"FROM Equipment E INNER JOIN EquipmentCategory EC ON EC.EquipmentCategoryID = E.EquipmentCategoryID " +
"WHERE ClientID = {0}",
parent.Id
);
SqlDataReader read = dh.Select(query);
Equipment equipment;
EquipmentCategory category;
if (read.HasRows)
{
while (read.Read())
{
equipment = new Equipment(
read.GetString(1),
read.GetString(2)
);
equipment.Id = read.GetInt32(0);
category = new EquipmentCategory(
read.GetString(4)
);
category.Id = read.GetInt32(3);
equipment.Category = category;
equipmentList.Add(equipment);
}
}
dh.Dispose();
return(equipmentList);
}
internal ItemDefinition(EquipmentCategory category, uint typeId, byte level, string name, string internalName, float maxDurability, Rarity rarity,
string socketTypes, Element element, ArmorType armorType, Buff?prefix, Buff?suffix, Buff[] itemBuffs, Buff[] playerBuffs, bool hasVariants)
{
Category = category;
TypeId = typeId;
Level = level;
Name = name;
InternalName = internalName;
MaxDurability = maxDurability;
Rarity = rarity;
SocketTypes = socketTypes;
ArmorType = armorType;
Element = element;
PlayerBuffs = playerBuffs;
HasVariants = hasVariants;
ItemBuffs = itemBuffs.Length == 0 && prefix is null && suffix is null
? ItemDefinitionBuffMemory.Empty
: new ItemDefinitionBuffMemory(itemBuffs, prefix, suffix);
// merchant search is case sensitive to avoid affixing the Merchant's hat.
IsMerchant = InternalName.Contains("merchant");
AffixableName = IsMerchant || internalName.IndexOf("common", StringComparison.OrdinalIgnoreCase) != -1;
}
public async Task <JsonResult> Add([FromBody] EquipmentCategory input)
{
await CheckPermission();
var sqlr = new CategoryEquipmentRepository(_logger);
try
{
if (input.Id != 0)
{
await sqlr.Update(input);
}
else
{
await sqlr.Add(input);
}
return(Json(new { message = "addOrUpdate OK" }));
}
catch (Exception e)
{
throw new Exception($"Can't add or update {this.GetType().ToString()} ex = {e}");
}
}
public static List <EquipmentType> SeperateToEquipmentTypes(this EquipmentCategory equipmentCategory)
{
List <EquipmentType> ret = new List <EquipmentType>();
switch (equipmentCategory)
{
case EquipmentCategory.Weapon:
ret.Add(EquipmentType.Weapon);
break;
case EquipmentCategory.Armor:
ret.Add(EquipmentType.Helm);
ret.Add(EquipmentType.Chest);
ret.Add(EquipmentType.Pant);
break;
case EquipmentCategory.Accessory:
ret.Add(EquipmentType.Amulet);
ret.Add(EquipmentType.Ring);
break;
}
return(ret);
}
private ItemDefinition(EquipmentCategory category, uint typeId, byte level, string name, string internalName, float maxDurability, Rarity rarity,
string socketTypes, Element element, ArmorType armorType, Buff?prefix, Buff?suffix,
Buff[] itemBuffs, Buff[] playerBuffs, bool isMerchant, bool affixableName, bool hasVariants, string chaosTier)
{
Category = category;
TypeId = typeId;
Level = level;
Name = name;
InternalName = internalName;
MaxDurability = maxDurability;
Rarity = rarity;
SocketTypes = socketTypes;
ArmorType = armorType;
Element = element;
PlayerBuffs = playerBuffs;
ItemBuffs = itemBuffs.Length == 0 && prefix is null && suffix is null
? ItemDefinitionBuffMemory.Empty
: new(itemBuffs, prefix, suffix);
IsMerchant = isMerchant;
AffixableName = affixableName;
HasVariants = hasVariants;
ChaosTier = chaosTier;
RequiresFatesworn = internalName.StartsWith("mit_");
}
public async Task <EquipmentPaging> GetByCategory(EquipmentCategory cat, int skip = 0,
int limit = Int32.MaxValue, string filter = null)
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
var sql = Sql.SqlQueryCach["Equipment.ByCategoryId"];
var result = await conn.QueryAsync <EquipmentWitcAct, EquipmentCategory, EquipmentWitcAct>(
sql,
(equipment, category) =>
{
equipment.Category = category;
return(equipment);
}, new { category_id = cat.Id, skip = skip, limit = limit });
var sqlc = Sql.SqlQueryCach["Equipment.CountByCategoryId"];
var count = conn.ExecuteScalar <int>(sqlc, new
{
category_id = cat.Id
});
TaskCommon.FilterBody[] filters;
var filterOutput = new List <EquipmentWitcAct>();
if (filter != null)
{
filters = JsonConvert.DeserializeObject <TaskCommon.FilterBody[]>(filter);
if (filters.Length > 0)
{
foreach (var value in result)
{
foreach (var item in filters)
{
switch (item.Filter)
{
case "Name":
if (value.Name.ToLower().Contains(item.Value.ToLower()))
{
filterOutput.Add(value);
}
break;
}
}
}
}
}
if (filter != null)
{
result = filterOutput;
count = filterOutput.Count;
}
//var newFuckingResult = new List<EquipmentWitcAct>();
var sqlRAct = new ActCategoriesRepository();
foreach (var item in result.ToArray())
{
var actCategory = await sqlRAct.GetByEquipmentId(item.Id);
if (actCategory.ToArray().Length > 0)
{
item.EquipmentActCategoryDescription = actCategory.FirstOrDefault().Description;
item.EquipmentActCategoryName = actCategory.FirstOrDefault().Name;
item.EquipmentActCategoryId = actCategory.FirstOrDefault().Id;
}
}
var output = new EquipmentPaging
{
Data = result.ToArray(),
Total = count
};
return(output);
}
}
public bool UpdateEquipmentCategory(EquipmentCategory equipmentCategory)
{
this._unitOfWork.EquipmentCategoryRepository <EquipmentCategory>().Update(equipmentCategory);
return(false);
}
private static void AddEquipmentProficiency(CharacterBase character, EquipmentCategory type)
{
if (character.Proficiencies.Contains(type))
return;
character.Proficiencies.Add(type);
}
