private IEnumerator ChangeClass()
{
lockControls.value = true;
LevelGain level = gains[classList.GetPosition()];
yield return(new WaitForSeconds(1f * currentGameSpeed.value));
StatsContainer stats = playerData.stats[entryList.GetPosition()];
InventoryContainer inventory = playerData.inventory[entryList.GetPosition()];
SkillsContainer skills = playerData.skills[entryList.GetPosition()];
levelupScript.SetupStats(stats, false);
Debug.Log("CLASS CHANGE!");
stats.ClassGain(level, (int)level.playerClassName);
inventory.IncreaseWpnSkill(level.weaponSkills);
skills.GainSkill(level.skill);
sfxQueue.Enqueue(levelupFanfare);
playSfxEvent.Invoke();
popupMode = true;
yield return(StartCoroutine(levelupScript.RunLevelup(stats)));
popupMode = false;
CreateListEntries();
DeselectCharacter();
lockControls.value = false;
yield break;
}
//
public List <SubVoucherDTO> LoadSubVoucherData_Validation(int id, string subvouchername)
{
using (var Container = new InventoryContainer())
{
var query = from s in Container.AccSubVouchers
join mainvoucher in Container.AccMainVouchers on s.MainVoucherId equals mainvoucher.MainVoucherId
select new { s, mainvoucher };
if (id != 0)
{
query = query.Where(c => c.s.SubVoucherId.Equals(id));
}
if (!string.IsNullOrEmpty(subvouchername))
{
query = query.Where(c => c.s.SubVoucherName.Contains(subvouchername));
}
var result = from o in query
orderby o.s.SubVoucherId descending
// where o.s.MainHeadId.Equals(id)
select new SubVoucherDTO
{
MainVoucherCode = o.mainvoucher.MainVoucherCode,
MainVoucherName = o.mainvoucher.MainVoucherName,
MainVoucherId = o.mainvoucher.MainVoucherId,
SubVoucherId = o.s.SubVoucherId,
SubVoucherName = o.s.SubVoucherName,
SubVoucherCode = o.s.SubVoucherCode,
CreateBy = o.s.CreateBy,
CreateDate = o.s.CreateDate,
};
return(result.ToList <SubVoucherDTO>());
}
}
private void TakeItem()
{
Debug.Log("Take item");
ItemListEntry item = convoy.GetEntry();
if (!item)
{
return;
}
InventoryContainer invCon = charList.GetEntry().invCon;
if (!invCon.AddItem(playerData.items[item.index]))
{
prompt.ShowOkPopup("Inventory is full!");
currentMode = State.MENU;
return;
}
convoy.RemoveEntry();
playerData.items.RemoveAt(item.index);
ShowCharInfo();
ShowCharInfoTake();
ShowItemInfo();
}
//generate sub voucher code no#
public List <SubVoucherDTO> GenerateSuvCodeNo(int id)
{
using (var Container = new InventoryContainer())
{
var query = from s in Container.AccSubVouchers
join mainvoucher in Container.AccMainVouchers on s.MainVoucherId equals mainvoucher.MainVoucherId
select new { s, mainvoucher };
if (id != 0)
{
query = query.Where(c => c.mainvoucher.MainVoucherId.Equals(id));
}
var result = from o in query
orderby o.s.SubVoucherId descending
// where o.s.MainHeadId.Equals(id)
select new SubVoucherDTO
{
MainVoucherCode = o.mainvoucher.MainVoucherCode,
MainVoucherName = o.mainvoucher.MainVoucherName,
MainVoucherId = o.mainvoucher.MainVoucherId,
SubVoucherId = o.s.SubVoucherId,
SubVoucherName = o.s.SubVoucherName,
SubVoucherCode = o.s.SubVoucherCode,
CreateBy = o.s.CreateBy,
CreateDate = o.s.CreateDate,
};
return(result.ToList <SubVoucherDTO>());
}
}
public List <MainVoucherDTO> GenerateSubVoucherCodeNO(int id)
{
using (var Container = new InventoryContainer())
{
var query = from s in Container.AccMainVouchers
select new { s };
if (id != 0)
{
query = query.Where(c => c.s.MainVoucherId.Equals(id));
}
var result = from o in query
orderby o.s.MainVoucherId descending
// where o.s.MainHeadId.Equals(id)
select new MainVoucherDTO
{
MainVoucherCode = o.s.MainVoucherCode,
// MainVoucherName = o.s.MainVoucherName,
MainVoucherId = o.s.MainVoucherId,
// CreateBy = o.s.CreateBy,
// CreateDate = o.s.CreateDate,
// MainVoucherCode_Name = o.s.MainVoucherName + " " + "(" + o.s.MainVoucherCode + ")"
};
return(result.ToList <MainVoucherDTO>());
}
}
public List <EmpTrainingDTO> ShowtrianingInfo_ForUpdate(int tarinid)
{
using (var Container = new InventoryContainer())
{
var query = from s in Container.EmpTrainings
select new { s };
if (tarinid != 0)
{
query = query.Where(c => c.s.TrainingId.Equals(tarinid));
}
var result = from o in query
select new EmpTrainingDTO
{
EmpId = o.s.Employee.EmpId,
TrainingYear = o.s.TrainingYear,
TrainingName = o.s.TrainingName,
TopicsCovered = o.s.TopicsCovered,
Location = o.s.Location,
InstituteName = o.s.InstituteName,
Duration = o.s.Duration,
TrainingId = o.s.TrainingId
};
return(result.ToList <EmpTrainingDTO>());
}
}
public List <InvenSalesInputDTO> GetInputByDate(string date)
{
using (var container = new InventoryContainer())
{
DateTime Date;
var query = from input in container.InvenSalesInputs
select new { input };
if (!String.IsNullOrEmpty(date))
{
Date = DateTime.Parse(date);
query = query.Where(o => o.input.CreatedDate == Date);
}
var result = (from o in query
select new InvenSalesInputDTO
{
InputId = o.input.InputId,
GuestCharge = o.input.GuestCharge,
Card = o.input.Card,
ExtraBill = o.input.ExtraBill,
GuestChagePlus = o.input.GuestChagePlus,
TotalAmount = o.input.TotalAmount,
CreatedDate = o.input.CreatedDate
}).ToList <InvenSalesInputDTO>();
return(result);
}
}
public List <EmpSpcialistDTO> GetSpcialistSearchAllpage(int id)
{
using (var Container = new InventoryContainer())
{
var query = from s in Container.EmpSpecialists
join emptype in Container.EmpTypes on s.EmpTypeId equals emptype.EmpTypeId
select new { s, emptype };
if (id != 0)
{
query = query.Where(c => c.emptype.EmpTypeId.Equals(id));
}
var result = from o in query
// orderby o.s.Id descending
where o.emptype.EmpTypeId.Equals(id)
select new EmpSpcialistDTO
{
EmpSpecilistId = o.s.EmpSpecilistId,
CreateBy = o.s.CreateBy,
TypeName = o.emptype.TypeName,
EmpTypeId = o.emptype.EmpTypeId,
Specialist = o.s.Specialist
};
return(result.ToList <EmpSpcialistDTO>());
}
}
//Central to party product rept
public List <InvenChangePaymentDtlDto> Return_Central_To_Party_ProductRpt(int retunno)
{
using (var Container = new InventoryContainer())
{
var query = from central in Container.InvenCentralReturns
join brRet in Container.InvenBranchReturns on central.BranchReturnId equals brRet.BranchReturnId
join chdtl in Container.InvenChangeDtls on brRet.ChangeDtlId equals chdtl.ChangeDtlId
join chinfo in Container.InvenChangeInfoes on chdtl.ChangeId equals chinfo.ChangeId
select new { central, brRet, chdtl, chinfo };
var result = from o in query
orderby o.central.CentralReturnId ascending
where o.central.ReturnNo.Equals(retunno)
select new InvenChangePaymentDtlDto
{
ReturnDate = o.central.ReturnDate,
CategoryName = o.chdtl.Product.Category.CategoryName,
CompName = o.chdtl.Product.CompanyInfo.CompName,
ProductName = o.chdtl.Product.ProductName,
Quantity = o.chdtl.Quantity,
ProductId = o.chdtl.Product.ProductId,
BrProName = o.chinfo.InvenBranchProfile.BrProName,
ReturnNo = o.central.ReturnNo
};
return(result.ToList <InvenChangePaymentDtlDto>());
}
}
public List <EmpSpcialistDTO> GetSpcialistSearch(int id)
{
using (var Container = new InventoryContainer())
{
var query = from s in Container.EmpSpecialists
join emptype in Container.EmpTypes on s.EmpTypeId equals emptype.EmpTypeId
select new { s, emptype };
if (id != 0)
{
query = query.Where(c => c.s.EmpSpecilistId.Equals(id));
}
//if (!string.IsNullOrEmpty(empname))
// query = query.Where(c => c.s.EmpName.Contains(empname));
var result = from o in query
orderby o.s.EmpSpecilistId descending
select new EmpSpcialistDTO
{
EmpSpecilistId = o.s.EmpSpecilistId,
Specialist = o.s.Specialist,
CreateBy = o.s.CreateBy,
TypeName = o.emptype.TypeName,
EmpTypeId = o.emptype.EmpTypeId,
SpecilistName = o.s.Specialist
};
return(result.ToList <EmpSpcialistDTO>());
}
}
public List <CategoryDTO> GetCategory(int id, string catename)
{
using (var Container = new InventoryContainer())
{
var query = from s in Container.Categories
select new { s };
if (id != 0)
{
query = query.Where(c => c.s.CatId.Equals(id));
}
if (!string.IsNullOrEmpty(catename))
{
query = query.Where(c => c.s.CategoryName.Contains(catename));
}
var result = from o in query
orderby o.s.CatId descending
select new CategoryDTO
{
CatId = o.s.CatId,
CategoryName = o.s.CategoryName,
CreateBy = o.s.CreateBy,
CreateDate = o.s.CreateDate,
UpdateDate = o.s.UpdateDate
};
return(result.ToList <CategoryDTO>());
}
}
public void Edit(EmpEducationDTO EduDTO)
{
using (var container = new InventoryContainer())
{
var Comp = new EmpEducation();
Comp = container.EmpEducations.FirstOrDefault(o => o.EduId.Equals(EduDTO.EduId));
// Comp = container.EmpEducations .FirstOrDefault(o => o.EmpId.Equals(EduDTO.EmpId));
// Comp.EmpId = EduDTO.EmpId;
// Comp.EduId = EduDTO.EduId;
Comp.Board = EduDTO.Board;
Comp.UpdateBy = EduDTO.UpdateBy;
Comp.Updatedate = EduDTO.Updatedate;
Comp.Cgpa = EduDTO.Cgpa;
Comp.Division = EduDTO.Division;
Comp.Eximination = EduDTO.Eximination;
Comp.InstituteName = EduDTO.InstituteName;
Comp.PassingYear = EduDTO.PassingYear; //problem can be occur
Comp.ResultType = EduDTO.ResultType;
Comp.Note = EduDTO.Note;
Comp = (EmpEducation)DTOMapper.DTOObjectConverter(EduDTO, Comp);
container.SaveChanges();
}
}
public List <EmpEducationDTO> ShowEducationInfo_ForUpdate(int eduid)
{
using (var Container = new InventoryContainer())
{
var query = from s in Container.EmpEducations
select new { s };
if (eduid != 0)
{
query = query.Where(c => c.s.EduId.Equals(eduid));
}
var result = from o in query
select new EmpEducationDTO
{
EmpId = o.s.Employee.EmpId,
Eximination = o.s.Eximination,
Board = o.s.Board,
InstituteName = o.s.InstituteName,
ResultType = o.s.ResultType,
PassingYear = o.s.PassingYear,
Division = o.s.Division,
EduId = o.s.EduId
};
return(result.ToList <EmpEducationDTO>());
}
}
public List <InvenPerRequisitionDto> RequsiitonWiseProdctInfoLoad(int RecNo)
{
using (var content = new InventoryContainer())
{
var result = (from data1 in content.InvenPerRequisitions
join data2 in content.Products on data1.ProductId equals data2.ProductId
// join data3 in content.PharmDurgCompanyInfoes on data1.CompId equals data3.CompId
where data1.RequisitionNo == RecNo
select new InvenPerRequisitionDto
{
PurReqId = data1.PurReqId,
ProductId = data1.ProductId,
ProductName = data2.ProductName, //+ "-" + data2.Unit.UnitName,
CompId = data2.CompanyInfo.CompId,
CompName = data2.CompanyInfo.CompName,
Quantity = data1.Quantity,
UnitPrice = data1.UnitPrice,
Priority = data1.Priority,
RequisitionNo = data1.RequisitionNo,
RequisitionBy = data1.RequisitionBy,
RequisitionDate = data1.RequisitionDate,
PurReqStatus = data1.PurReqStatus,
UnitName = data2.Unit.UnitName,
CategoryName = data2.Category.CategoryName,
CatId = data2.Category.CatId
}).ToList <InvenPerRequisitionDto>();
return(result);
}
}
public void OpenContainerAt(Container container, byte index)
{
if (index < Constants.MaxOpenContainers)
{
openContainers[index] = new InventoryContainer(container, index, null);
}
}
public List <CompanyInfoDTO> SearchComInfo(int CompId, string CompName, string CompMobile, string CompAdd)
{
using (var Container = new InventoryContainer())
{
var query = from s in Container.CompanyInfoes
select new { s };
if (CompId != 0)
{
query = query.Where(c => c.s.CompId.Equals(CompId));
}
if (!string.IsNullOrEmpty(CompName))
{
query = query.Where(c => c.s.CompName.Contains(CompName));
}
// GetContacts().Where(c => searchTerms.Any(term => c.FullName.Contains(term)))
// query.Where(c => CompName.Any(term => c.s.CompName.Contains(term)));
//query.Where((string)CompanyInfo.EntityKeyPropertyName("CompName")).CompareTo(CompName);
// query.Where ((string)s.Element("CompName")).Contains(CompName);
// query.Where(c => c.s.CompName.Contains(CompName)).Single();
// (gr.Name as string).Equals(name, StringComparison.OrdinalIgnoreCase)
// query.Where(c=>c.s.CompName as string
//query.Where(c => CompName.Equals(c.s.CompName.ToLower()));
//query.Where(c =>( c.s.CompName as string).Equals(CompName, StringComparison.OrdinalIgnoreCase));
//if (!string.IsNullOrEmpty(CompMobile))
// query.Where(c => c.s.CompMobile1.Contains(CompMobile) || c.s.CompMobile2.Contains(CompMobile));
//if (!string.IsNullOrEmpty(CompAdd))
// query.Where(c => c.s.CompPresentAdd.Contains(CompAdd) || c.s.CompPermanantAdd.Contains(CompAdd));
var result = from o in query
orderby o.s.CompId descending
where (o.s.CompName.Contains(CompName) || o.s.CompMobile1.Contains(CompMobile))
select new CompanyInfoDTO
{
CompId = o.s.CompId,
CompName = o.s.CompName,
CompPermanantAdd = o.s.CompPermanantAdd,
CompName_BarCode = o.s.CompName_BarCode,
CompMobile1 = o.s.CompMobile1,
CompPresentAdd = o.s.CompPresentAdd,
CompDes = o.s.CompDes,
CompEmail = o.s.CompEmail,
CompMobile2 = o.s.CompMobile2,
Website = o.s.Website,
CompPhone = o.s.CompPhone,
CompStatus = o.s.CompStatus
};
return(result.ToList <CompanyInfoDTO>());
}
}
public List <RoleDTO> LoadRole(int id)
{
using (var Container = new InventoryContainer())
{
var query = from s in Container.PayRoles
select new { s };
if (id != 0)
{
query = query.Where(c => c.s.RoleId.Equals(id));
}
var result = (from o in query
orderby o.s.RoleId descending
select new RoleDTO
{
RoleName = o.s.RoleName,
RoleId = o.s.RoleId,
CreateDate = o.s.CreateDate,
CreateBy = o.s.CreateBy,
UpdateBy = o.s.UpdateBy,
UpdateDate = o.s.UpdateDate
}).ToList <RoleDTO>();
return(result);
}
}
public List <InvenSalePaymentDtlDto> LoadDailyGuestChargeDue(string date)
{
using (var container = new InventoryContainer())
{
DateTime Date;
var query = from salpay in container.InvenSalePayments
join salinfo in container.InvenSalesInfoes on salpay.SalId equals salinfo.SalId
join saldtl in container.InvenSaleDtls on salinfo.SalId equals saldtl.SalId
//join salextra in container.InvenSaleXtraInfoes on salinfo.SalId equals salextra.SalId
where salpay.DueAmount > 0
select new { salpay, salinfo, saldtl };
if (!String.IsNullOrEmpty(date))
{
Date = DateTime.Parse(date);
query = query.Where(o => o.salinfo.CreateDate.Equals(Date));
}
var result = from o in query
where o.saldtl.Product.CompanyInfo.CompName.ToLower().Contains("guest".ToLower())
orderby o.salinfo.SalId ascending
group o by new { o.saldtl.Product.Category.CategoryName, o.saldtl.Product.ProductSalePrice }
into os
select new InvenSalePaymentDtlDto
{
PaidAmount = os.Sum(o => o.saldtl.Quantity * os.Key.ProductSalePrice)
};
return(result.ToList <InvenSalePaymentDtlDto>());
}
}
//Member
public List <InvenSalePaymentDtlDto> LoadMemberDue(int MemId, int SalId, int SalePaymentId)
{
using (var container = new InventoryContainer())
{
var query = from mem in container.Members
join salinfo in container.InvenSalesInfoes on mem.MemberId equals salinfo.MemberId
join sale in container.InvenSalePayments on salinfo.SalId equals sale.SalId
select new { mem, sale, salinfo };
if (MemId != 0)
{
query = query.Where(o => o.mem.MemberId == MemId);
}
if (SalId != 0)
{
query = query.Where(o => o.salinfo.SalId == SalId);
}
if (SalePaymentId != 0)
{
query = query.Where(o => o.sale.SalePaymentId == SalePaymentId);
}
var result = (from o in query
where o.sale.DueAmount > 0
orderby o.salinfo.CreateDate descending
select new InvenSalePaymentDtlDto
{
SalePaymentId = o.sale.SalePaymentId,
PaidAmount = o.sale.PaidAmount,
DueAmount = o.sale.DueAmount,
SalId = o.sale.SalId,
CreateDate = o.salinfo.CreateDate
}).Distinct().ToList <InvenSalePaymentDtlDto>();
return(result);
}
}
public List <InvenCentralPurRequisitonDTO> GetInfo(int RecNo)
{
using (var content = new InventoryContainer())
{
var result = (from data1 in content.InvenCentralPurRequisitions
join data2 in content.Products on data1.ProductId equals data2.ProductId
where data1.RequisitionNo == RecNo
select new InvenCentralPurRequisitonDTO
{
CenPurReqId = data1.CenPurReqId,
ProductId = data1.ProductId,
ProductName = data2.ProductName,
PurReqId = data1.PurReqId,
CompId = data2.CompanyInfo.CompId,
CompName = data2.CompanyInfo.CompName,
Quantity = data1.Quantity,
UnitPrice = data1.UnitPrice,
Priority = data1.Priority,
RequisitionNo = data1.RequisitionNo,
RequisitionBy = data1.RequisitionBy,
RequisitionDate = data1.RequisitionDate,
PurReqStatus = data1.PurReqStatus,
UnitName = data2.Unit.UnitName,
}).ToList <InvenCentralPurRequisitonDTO>();
return(result);
}
}
public List <CocktailInfoDTO> GetCocktail(int proid, int itemproid)
{
using (var container = new InventoryContainer())
{
var query = from pro in container.Products
join c**k in container.CocktailInfoes on pro.ProductId equals c**k.ItemProId
select new { pro, c**k };
if (proid != 0)
{
query = query.Where(o => o.c**k.CocktaiProId == proid);
}
if (itemproid != 0)
{
query = query.Where(o => o.c**k.ItemProId == itemproid);
}
var result = (from o in query
select new CocktailInfoDTO
{
CategoryName = o.pro.Category.CategoryName,
CompName = o.pro.CompanyInfo.CompName,
Quantity = o.c**k.Quantity,
CocktaiInfoId = o.c**k.CocktaiInfoId,
CocktaiProId = o.c**k.CocktaiProId,
ItemProId = o.c**k.ItemProId
}).ToList <CocktailInfoDTO>();
return(result);
}
}
private void Start()
{
//fonud inventory container in main Scene
found_player = GameObject.FindGameObjectWithTag("Player");
container = found_player.GetComponentInChildren <InventoryContainer>();
container.OnInventoryUpdated.AddListener(OnInventoryUpdatedHandler);
for (int index = 0; index < InvItemSlots.Count; index++)
{
InvItemSlots[index].OnLeftClickEvent.AddListener(OnLeftClickEventHandler);
InvItemSlots[index].OnRightClickEvent.AddListener(OnRightClickEventHandler);
InvItemSlots[index].OnBeginDragEvent.AddListener(OnBeginDragEventHandler);
InvItemSlots[index].OnEndDragEvent.AddListener(OnEndDragEventHandler);
InvItemSlots[index].OnDragEvent.AddListener(OnDragEventHandler);
InvItemSlots[index].OnDropEvent.AddListener(OnDropEventHandler);
InvItemSlots[index].OnPointEnterEvent.AddListener(OnPointEnterEventHandler);
InvItemSlots[index].OnPointExitEvent.AddListener(OnPointExitEventHandler);
InvItemSlots[index].INDEX = index;
}
displayed = false;
//display all item
//Reset();
}
// purorder no wise load
public List <InvenCentralPurOrderDTO> GetOrderNo_CentralPurchasepage_UnderPurOrder(int Recno)
{
using (var Container = new InventoryContainer())
{
var query = from s in Container.InvenCentrealPurOrders
join pro in Container.Products on s.ProductId equals pro.ProductId
select new { s, pro };
if (Recno != 0)
{
query = query.Where(c => c.s.PurOrderNO == Recno);
}
var result = from o in query
select new InvenCentralPurOrderDTO
{
CentralPurOrderId = o.s.CentralPurOrderId,
PurOrderStatus = o.s.PurOrderStatus,
ProductId = o.pro.ProductId,
PurOrderBy = o.s.PurOrderBy,
PurOrderDate = o.s.PurOrderDate,
PurOrderNO = o.s.PurOrderNO,
UnitPrice = o.s.UnitPrice,
CompId = o.pro.CompanyInfo.CompId,
CompName = o.pro.CompanyInfo.CompName,
Priority = o.s.Priority,
Quantity = o.s.Quantity
};
return(result.ToList <InvenCentralPurOrderDTO>());
}
}
public override void OnEnterInventory(InventoryContainer s, EquipmentSlot es)
{
base.OnEnterInventory(s, es);
if (es != null && es.SlotType == InventorySlotType.EQUIPMENT)
{
ItemInstance = Instantiate((GameObject)Resources.Load(ItemProperties.prefabPath), s.transform.position, Quaternion.identity);
ItemInstance.transform.SetParent(s.gameObject.transform);
ItemInstance.GetComponent <Item>().ItemProperties = ItemProperties;
ItemInstance.GetComponent <Item>().LoadItems();
Debug.Log("Assigning current slot to: " + es.coordinate);
ItemInstance.GetComponent <Item>().SetSlotData(s, es.coordinate);
ItemInstance.GetComponent <BasicPhysics>().enabled = false;
ItemInstance.GetComponent <CharacterController>().enabled = false;
m_onSave = ItemInstance.GetComponent <Item>().onItemSave;
Destroy(ItemInstance.GetComponent <PersistentItem>());
ItemInstance.name = es.SlotName;
ItemInstance.GetComponent <Equipment>().AddActionListeners(s.gameObject);
if (ItemInstance.GetComponent <BasicPhysics>())
{
ItemInstance.GetComponent <BasicPhysics>().GravityForce = 0f;
ItemInstance.GetComponent <SpriteRenderer>().enabled = false;
//Debug.Log("Removing spriterenderer");
}
OnEquip(s, es);
OverrideCurrentEquipSprite(s.gameObject);
}
}
public List <InvenStoreStatusDto> GetStoreStatusByProId(int proid, int branchid)
{
using (var Container = new InventoryContainer())
{
var query = from s in Container.InvenStoreStatus
join brance in Container.InvenBranchProfiles on s.BrProId equals brance.BrProId
join pro in Container.Products on s.ProductId equals pro.ProductId
// join cat in Container.Categories on s.CategoryId equals cat.CatId
select new { s, brance, pro };
if (proid != 0)
{
query = query.Where(c => c.pro.ProductId.Equals(proid));
}
if (branchid != 0)
{
query = query.Where(c => c.brance.BrProId.Equals(branchid));
}
var result = from o in query
// orderby o.s.InvenStoreId descending
/// where o.s.QuantityStore < reordervalue
select new InvenStoreStatusDto
{
ProductId = o.pro.ProductId,
BrProId = o.brance.BrProId,
InvenStoreId = o.s.InvenStoreId,
QuantityStore = o.s.QuantityStore,
QuantityPurchase = o.s.QuantityPurchase,
QuantityLastPurchase = o.s.QuantityLastPurchase,
DateStored = o.s.DateStored,
DateUpdated = o.s.DateUpdated
};
return(result.ToList <InvenStoreStatusDto>());
}
}
public override void OnEnter ()
{
base.OnEnter ();
if (gameObject.Value != null) {
container = gameObject.Value.GetComponent<InventoryContainer> ();
}
}
private void ShowItemInfo()
{
infoBoxView.SetActive(true);
RestockListEntry entry = characters.GetEntry();
InventoryTuple tuple = itemList.GetEntry().tuple;
if (!entry || tuple == null || string.IsNullOrEmpty(tuple.uuid))
{
itemName.text = "";
itemType.text = "";
itemIcon.sprite = null;
pwrText.text = "Pwr: ";
rangeText.text = "Range: ";
hitText.text = "Hit: ";
critText.text = "Crit: ";
reqText.text = "Req: ";
return;
}
itemName.text = tuple.entryName;
itemType.text = InventoryContainer.GetWeaponTypeName(tuple.weaponType);
itemIcon.sprite = tuple.icon;
pwrText.text = "Pwr: " + tuple.power.ToString();
rangeText.text = "Range: " + tuple.range.ToString();
hitText.text = "Hit: " + tuple.hitRate.ToString();
critText.text = "Crit: " + tuple.critRate.ToString();
reqText.text = "Req: " + tuple.skillReq.ToString();
}
public List <CashFolwEntityDTO> LoadCashFlowEntity(int id)
{
using (var Container = new InventoryContainer())
{
var query = from s in Container.AccCashFlowEntities
select new { s };
if (id != 0)
{
query = query.Where(c => c.s.CFEId.Equals(id));
}
var result = from o in query
orderby o.s.CFEId descending
select new CashFolwEntityDTO
{
CFEName = o.s.CFEName,
CFEId = o.s.CFEId,
CreateDate = o.s.CreateDate,
CreateBy = o.s.CreateBy,
UpdateDate = o.s.UpdateDate,
UpdateBy = o.s.UpdateBy,
Priority = o.s.Priority
};
return(result.ToList <CashFolwEntityDTO>());
}
}
public List <BalanceSheetRptDTO> LoadBalanceSheetRpt(int id)
{
using (var Container = new InventoryContainer())
{
var query = from s in Container.AccBalanceSheetRpts
join main in Container.AccMainHeads on s.MainHeadId equals main.MainHeadId
join s1code in Container.AccSubCode1 on s.MainHeadId equals s1code.SubCode_1Id
select new { s, main, s1code };
if (id != 0)
{
query = query.Where(c => c.s.BalanceShtId.Equals(id));
}
var result = from o in query
orderby o.s.Priority descending
select new BalanceSheetRptDTO
{
BalanceShtId = o.s.BalanceShtId,
MainHeadId = o.s.MainHeadId,
MainHeadName_Num = o.main.MainHadeNum + "-" + o.main.MainHeadName,
SubCode1Id = o.s.SubCode1Id,
SubCode1Name_Num = o.s1code.SubCode_1Num + "-" + o.s1code.SubCode_1Name,
ActiveStatus = o.s.ActiveStatus,
Priority = o.s.Priority,
CreateBy = o.s.CreateBy,
CreateDate = o.s.CreateDate,
};
return(result.ToList <BalanceSheetRptDTO>());
}
}
public List <InvenSalePaymentDtlDto> LoadActiveMember(int MemId, int SalId, int SalePaymentId)
{
using (var container = new InventoryContainer())
{
var query = from mem in container.Members
join salinfo in container.InvenSalesInfoes on mem.MemberId equals salinfo.MemberId
join sale in container.InvenSalePayments on salinfo.SalId equals sale.SalId
select new { mem, sale, salinfo };
if (MemId != 0)
{
query = query.Where(o => o.mem.MemberId == MemId);
}
if (SalId != 0)
{
query = query.Where(o => o.salinfo.SalId == SalId);
}
if (SalePaymentId != 0)
{
query = query.Where(o => o.sale.SalePaymentId == SalePaymentId);
}
var result = (from o in query
orderby o.salinfo.CreateDate descending
group o by new { o.salinfo.CreateDate } into os
select new InvenSalePaymentDtlDto
{
CreateDate = os.Key.CreateDate
}).ToList <InvenSalePaymentDtlDto>();
return(result);
}
}
public List <MainHeadDTO> LoadMainHead(int id)
{
using (var Container = new InventoryContainer())
{
var query = from s in Container.AccMainHeads
select new { s };
//if (!string.IsNullOrEmpty(Deptname))
// query = query.Where(c => c.emp.EmpType.TypeName.Contains(Deptname));
if (id != 0)
{
query = query.Where(c => c.s.MainHeadId.Equals(id));
}
var result = from o in query
orderby o.s.MainHeadId descending
// where o.s.MainHeadId.Equals(id)
select new MainHeadDTO
{
MainHeadName = o.s.MainHeadName,
MainHeadId = o.s.MainHeadId,
MainHadeNum = o.s.MainHadeNum,
AID = o.s.AID,
CreateBy = o.s.CreateBy,
CreateDate = o.s.CreateDate,
Description = o.s.Description,
MainHeadName_Num = o.s.MainHadeNum + "-" + o.s.MainHeadName
};
return(result.ToList <MainHeadDTO>());
}
}
public PlayerEntity()
{
_playerId = Guid.NewGuid();
Inventory = new InventoryContainer(INVENTORY_SIZE);
Toolbelt = new InventoryContainer(TOOLBELT_SIZE);
Speed = 0.1f;
Size = 0.8f;
}
public override bool Validate ()
{
if (container == null) {
container = gameObject.Value.GetComponent<InventoryContainer> ();
}
InventoryItem mItem = item.Value as InventoryItem;
bool result = true;
for (int i=0; i< mItem.ingredients.Count; i++) {
InventoryItem.Ingredient ingredient=mItem.ingredients[i];
if(container.GetItemStack(ingredient.item.itemName) < ingredient.amount){
result=false;
}
}
return result == equals.Value;
}
public void OpenContainerAt(Container container, byte index)
{
if (index < Constants.MaxOpenContainers)
openContainers[index] = new InventoryContainer(container, index, null);
}
public bool HasIngredients(List<InventoryItem.Ingredient> ingredients,InventoryContainer container){
return true;
}
public byte OpenContainer(Container container, Location location)
{
byte i;
for (i = 0; i < Constants.MaxOpenContainers; i++)
{
if (openContainers[i] == null)
{
openContainers[i] = new InventoryContainer(container, i, location);
return i;
}
}
// TODO: handle more than 16, replace last one
return i;
}
private void UpdateItems(InventoryContainer container)
{
for (int slotIndex = 0; slotIndex < container.Count; slotIndex++)
{
var itemStack = container.GetSlot(slotIndex);
if ((itemStack != null) && (itemStack.StackSize == 0))
{
container.SetSlot(slotIndex, null);
}
}
}
