// Start is called before the first frame update
void Start()
{
TimeManagerCall = GameObject.Find("TimeManager").GetComponent <TimeManager>();
SalesValueCall = GameObject.Find("SalesManager").GetComponent <SalesValue>();
GoodsRecipeCall = GameObject.Find("BaseSystem").GetComponent <GoodsRecipe>();
Initializinig();
}
// Start is called before the first frame update
void Start()
{
BaseSystem = GameObject.Find("BaseSystem");
ObjectActCall = gameObject.GetComponent <InstallableObjectAct>();
CompanyManagerCall = GameObject.Find("CompanyManager").GetComponent <CompanyManager>();
GoodsValueCall = CompanyManagerCall.GetPlayerCompanyValue().GetGoodsValue().GetComponent <GoodsValue>();
SalesValueCall = GameObject.Find("SalesManager").GetComponent <SalesValue>();
MoverDetector = transform.GetChild(2).GetChild(0).GetChild(0).gameObject;
WarehouseDetector = transform.GetChild(2).GetChild(1).GetChild(0).gameObject;
isInitialized = false;
}
// Start is called before the first frame update
void Start()
{
CompanyManagerCall = GameObject.Find("CompanyManager").GetComponent <CompanyManager>();
GoodsValueCall = CompanyManagerCall.GetPlayerCompanyValue().GetGoodsValue().GetComponent <GoodsValue>();
SalesValueCall = GameObject.Find("SalesManager").GetComponent <SalesValue>();
ObjectActCall = gameObject.GetComponent <InstallableObjectAct>();
Goods = GameObject.Find("Goods");
DummyBeltActCall = DummyBelt.GetComponent <BeltAct>();
MoverDetector = transform.GetChild(2).GetChild(0).GetChild(0).gameObject;
WarehouseDetector = transform.GetChild(2).GetChild(1).GetChild(0).gameObject;
TargetGoodsName = "None";
}
// Start is called before the first frame update
void Start()
{
CompanyValueCall = transform.parent.gameObject.GetComponent <CompanyValue>();
GoodsValueCall = CompanyValueCall.GetGoodsValue().GetComponent <GoodsValue>();
TimaManagerCall = GameObject.Find("TimeManager").GetComponent <TimeManager>();
SalesValueCall = GameObject.Find("SalesManager").GetComponent <SalesValue>();
List <string> ItemList = new List <string>();
List <int> PriceList = new List <int>();
CompanyValueCall.GetGoodsValue().GetComponent <GoodsValue>().TotalCapacity = 9999999;
switch (Name)
{
case "General Industry Co.":
ItemList.Add("Paper roll");
PriceList.Add(1);
Initializing(ItemList, PriceList);
break;
case "Federal Agency of Industry":
ItemList.Add("Plastic mass"); ItemList.Add("Silicon mass");
PriceList.Add(2); PriceList.Add(3);
Initializing(ItemList, PriceList);
break;
// case "Sasio" :
// ItemList.Add("Packaged Calculator"); ItemList.Add("Calculator"); ItemList.Add("Calculating Circuit");
// List<string> NameList = new List<string>();
// NameList.Add("Packaged Cal-100"); NameList.Add("Cal-100"); NameList.Add("CM100");
// PriceList.Add(18); PriceList.Add(13); PriceList.Add(10);
// GoodsRecipe GoodsRecipeCall = GameObject.Find("BaseSystem").GetComponent<GoodsRecipe>();
// TechValue TechValueCall = CompanyValueCall.GetTechValue().GetComponent<TechValue>();
// for(int i = 0; i < ItemList.Count; i++)
// {
// for(int j = 0; j < GoodsRecipeCall.RecipeArray.Count; j++)
// {
// if(GoodsRecipeCall.RecipeArray[j].OutputName == ItemList[i])
// {
// GoodsRecipeCall.MakeCustomRecipe(ItemList[i], NameList[i], GoodsRecipeCall.RecipeArray[j].InputName, GoodsRecipeCall.RecipeArray[j].Attractiveness, Name);
// SalesValueCall.AddSales(NameList[i], Name, PriceList[i]);
// }
// }
// }
// break;
}
StockManage();
}
public String SalesGratuityToday(string paymentType, string orderstatus) //SalesToday
{
string SQL_str = "select Convert(nvarchar(10), " +
"DatePart(year, dCreatedDate)) + '-' + Convert(nvarchar(10), " +
"DatePart(month, dCreatedDate)) + '-' + Convert(nvarchar(10), DatePart(day, dCreatedDate))" +
" OrderDate,COALESCE(sum(dOrderServiceFee),0) SalesGratuity,sum(dOrderTax) Tax" +
" from pos_orderheader" +
" where vOrderStatus='" + orderstatus + "' and Convert(nvarchar(10), DatePart(year, dCreatedDate)) + '-' + Convert(nvarchar(10), DatePart(month, dCreatedDate)) + '-' + Convert(nvarchar(10), DatePart(day, dCreatedDate)) ='" + System.DateTime.Today.ToString("yyyy-M-d") + "'" +
"group by Convert(nvarchar(10), DatePart(year, dCreatedDate)) + '-' + Convert(nvarchar(10), DatePart(month, dCreatedDate)) + '-' + Convert(nvarchar(10), DatePart(day, dCreatedDate))";
//Connect to database and retrieve
SqlCEDataAccess POSdbAccess = new SqlCEDataAccess();
DataSet ResultSet;
DataTable ResultTable;
ResultSet = POSdbAccess.dsGetData(SQL_str, "POSsalesTipsToday");
ResultTable = ResultSet.Tables[0];
String RtnString;
Decimal SalesValue, TaxValue;
// SalesValue = (from DataRow dr in ResultTable.Rows where dr["Sales"] == EnvironmentVariableTarget select (int)dr["id"].FirstOrDefault);
if (ResultTable.Rows.Count > 0 && ResultTable.Rows != null)
{
if (ResultTable.Rows[0]["SalesGratuity"] != null)
{
SalesValue = (Decimal)ResultTable.Rows[0]["SalesGratuity"];
}
else
{
SalesValue = 0;
}
TaxValue = (Decimal)ResultTable.Rows[0]["Tax"];
// SalesValue = SalesValue; // + TaxValue; Tax is included in dOrderAmount......5/8/16
RtnString = "$ " + SalesValue.ToString("##,##.00");
}
else
{
RtnString = "$ 0.00";
}
return(RtnString);
}
public String YTDSales() //MonthlyAvg
{
string SQL_str = "select " +
"Convert(nvarchar(10), " +
"DatePart(year, dCreatedDate))" +
" OrderDate,sum(dOrderAmount) Sales,sum(dOrderTax) Tax" +
" from pos_orderheader" +
" where Convert(nvarchar(10), DatePart(year, dCreatedDate)) ='" + System.DateTime.Today.Year + "'" +
"group by Convert(nvarchar(10), DatePart(year, dCreatedDate)) ";
Int16 MonthCount = (Int16)System.DateTime.Today.Month;
//Connect to database and retrieve
SqlCEDataAccess POSdbAccess = new SqlCEDataAccess();
DataSet ResultSet;
DataTable ResultTable;
ResultSet = POSdbAccess.dsGetData(SQL_str, "POSytdSales");
ResultTable = ResultSet.Tables[0];
String RtnString;
Decimal SalesValue, TaxValue;
// SalesValue = (from DataRow dr in ResultTable.Rows where dr["Sales"] == EnvironmentVariableTarget select (int)dr["id"].FirstOrDefault);
if (ResultTable.Rows.Count > 0 && ResultTable.Rows != null)
{
SalesValue = (Decimal)ResultTable.Rows[0]["Sales"];
TaxValue = (Decimal)ResultTable.Rows[0]["Tax"];
// SalesValue = SalesValue + TaxValue; //tax included in dOrderAmount. 5/8/16 saa
RtnString = "$ " + SalesValue.ToString("##,##.00");
}
else
{
RtnString = "$ 0.00";
}
return(RtnString);
}
public String TransactionList() //Transaction List.
{
string SQL_str = "select Convert(nvarchar(10), " +
"DatePart(year, dCreatedDate)) + '-' + Convert(nvarchar(10), " +
"DatePart(month, dCreatedDate)) + '-' + Convert(nvarchar(10), DatePart(day, dCreatedDate))" +
" OrderDate,sum(dOrderAmount) Sales,sum(dOrderTax) Tax" +
" from pos_orderheader" +
" where Convert(nvarchar(10), DatePart(year, dCreatedDate)) + '-' + Convert(nvarchar(10), DatePart(month, dCreatedDate)) + '-' + Convert(nvarchar(10), DatePart(day, dCreatedDate)) ='" + System.DateTime.Today.ToString("yyyy-M-dd") + "'" +
"and vOrderStatus='Pending' group by Convert(nvarchar(10), DatePart(year, dCreatedDate)) + '-' + Convert(nvarchar(10), DatePart(month, dCreatedDate)) + '-' + Convert(nvarchar(10), DatePart(day, dCreatedDate))";
//Connect to database and retrieve
SqlCEDataAccess POSdbAccess = new SqlCEDataAccess();
DataSet ResultSet;
DataTable ResultTable;
ResultSet = POSdbAccess.dsGetData(SQL_str, "POSsalesPendingToday");
ResultTable = ResultSet.Tables[0];
String RtnString;
Decimal SalesValue, TaxValue;
// SalesValue = (from DataRow dr in ResultTable.Rows where dr["Sales"] == EnvironmentVariableTarget select (int)dr["id"].FirstOrDefault);
if (ResultTable.Rows.Count > 0 && ResultTable.Rows != null)
{
SalesValue = (Decimal)ResultTable.Rows[0]["Sales"];
TaxValue = (Decimal)ResultTable.Rows[0]["Tax"];
// SalesValue = SalesValue + TaxValue;//tax included in dOrderAmount. 5/8/16 saa
RtnString = "$ " + SalesValue.ToString("##,##.00");
}
else
{
RtnString = "$ 0.00";
}
return(RtnString);
}