public static ActionDB FindAction(string ActionName, int Year)
{
var context = new DataBaseConnectionContext();
ActionDB FindAction = context.Action.Where(u => u.Name == ActionName && u.StartYear == Year && u.Active == true).FirstOrDefault();
return(FindAction);
}
public static void NewAction(ActionDB action)
{
var context = new DataBaseConnectionContext();
context.Action.Add(action);
context.SaveChanges();
}
public static void Save(ActionDB action)
{
var context = new DataBaseConnectionContext();
context.Action.Update(action);
context.SaveChanges();
}
public static ActionDB Load_ID(int ID)
{
var context = new DataBaseConnectionContext();
ActionDB Action = context.Action.Where(u => u.ID == ID).FirstOrDefault();
return(Action);
}
// Use this for initialization
void Awake()
{
photonView = GetComponent <PhotonView>();
_actionDB = ActionDB.Instance;
_actorDB = ActorDB.Instance;
_trendingDB = TrendingDB.Instance;
Instance = this;
Debug.Log("DB ready");
}
public static void ModificationAction(ActionDB Original, ActionDB Updaeted)
{
var context = new DataBaseConnectionContext();
Original.Active = false;
Updaeted.Rev = Original.Rev + 1;
Updaeted.ActionIDOriginal = Original.ID;
context.Action.Update(Original);
context.Action.Add(Updaeted);
context.SaveChanges();
}
public LoadAction(string ActionName, decimal Year)
{
_ = new ClearForm();
_ = new ActionVerificationEnabled();
ActionDB Action = ActionController.FindAction(ActionName, Convert.ToInt32(Year));
ActionLoad.Load(Action);
ANCChangeLoad.Load(Action.ID);
CalculationMassLoad.Load(Action.ID);
if (Action.PNC == true)
{
PNCLoad.Load(Action.ID);
}
if (Action.PNCSpec == true)
{
PNCSpecialLoad.Load(Action.ID);
}
ActionID.Delete();
ActionID.Singleton.ID = Action.ID;
}
public static void Load(ActionDB Action)
{
var ActionView = MainProgram.Self.actionView;
ActionView.nameView.ActionNameChange(Action.Name);
ActionView.nameView.Description(Action.Description);
// StateView
ActionView.stateView.SetActionIdea(Action.Status);
ActionView.stateView.SetYear(Convert.ToDecimal(Action.StartYear));
ActionView.stateView.SetStartMonth(Action.MonthStart);
ActionView.stateView.SetFactory(Action.Factory);
ActionView.stateView.SetLeader(Action.Leader);
ActionView.stateView.SetDevision(Action.Devision);
//Platform
ActionView.platformView.SetDMD(Action.Platform_DMD);
ActionView.platformView.SetD45(Action.Platform_D45);
//Installation
ActionView.installationView.SetBI(Action.Installation_BI);
ActionView.installationView.SetFI(Action.Installation_FI);
ActionView.installationView.SetFS(Action.Installation_FS);
ActionView.installationView.SetFSBU(Action.Installation_FSBU);
//ECCC
ActionView.ecccView.SetECCC(Action.ECCC);
ActionView.ecccView.SetECCCSpec(Action.ECCC_PNCSpec);
ActionView.ecccView.SetECCCSec(Action.ECCC_Sec);
//Action Calculation by Method
ActionView.calculationByView.SetANC(Action.ANC);
ActionView.calculationByView.SetANCSpec(Action.ANCSpec);
ActionView.calculationByView.SetPNC(Action.PNC);
ActionView.calculationByView.SetPNCSpec(Action.PNCSpec);
//Set PNC Estimation
ActionView.PNCSpecialEstymationView.SetPNCEstimationValue(Action.PNCSpec_Estimation);
}
public async Task <List <Models.Action> > GetActionsAsync()
{
var db = new ActionDB(_storageConnectionString);
return(await db.GetActionsAsync());
}
public SaveAction()
{
//Sprawdzamy czy wszystko jest dozwolone do zapisu i czy czegoś nie brakuje;
if (!CheckPermisionToSave())
{
return;
}
if (ActionID.Singleton.ID != 0)
{
ActionDB NewAction;
OriginalAction = ActionController.Load_ID(ActionID.Singleton.ID);
NewAction = ActionSave.Save();
if (ActionID.Singleton.ActionModification)
{
ActionController.ModificationAction(OriginalAction, NewAction);
//ActionID.Delete();
ActionID.Singleton.ID = NewAction.ID;
}
//Jeśli zmianie ulegają ANC to tedy ma działać
if (ActionID.Singleton.ANCModification)
{
IEnumerable <ANCChangeDB> ANCs = ANCChangeSave.ANCSave();
if (OriginalAction.ID != NewAction.ID && NewAction.ID != 0)
{
ANCChangeController.UpdateANC(OriginalAction.ID, NewAction.ID, ANCs);
}
else
{
ANCChangeController.UpdateANC(OriginalAction.ID, OriginalAction.ID, ANCs);
}
}
else
{
//Update tylko ID akcji
if (OriginalAction.ID != NewAction.ID && NewAction.ID != 0)
{
ANCChangeController.UpdateActionID(OriginalAction.ID, NewAction.ID);
}
}
//Jeśli jest zmiana w Mass Calculation to ma coś zmienić
if (ActionID.Singleton.MassModification)
{
if (NewAction.Group_Calc && OriginalAction.Group_Calc)
{
CalculationMassDB Mass = CalculationMassSave.Mass();
if (OriginalAction.ID != NewAction.ID && NewAction.ID != 0)
{
CalculationMassController.Update(OriginalAction.ID, NewAction.ID, Mass);
}
else
{
CalculationMassController.Update(OriginalAction.ID, OriginalAction.ID, Mass);
}
}
else if (NewAction.Group_Calc && !OriginalAction.Group_Calc)
{
CalculationMassDB Mass = CalculationMassSave.Mass();
Mass.ActionID = NewAction.ID;
CalculationMassController.Add(Mass);
}
else if (!NewAction.Group_Calc && OriginalAction.Group_Calc)
{
CalculationMassController.Deactivation(OriginalAction.ID);
}
}
else
{
if (OriginalAction.Group_Calc)
{
//Update tylko ID akcji
if (OriginalAction.ID != NewAction.ID && NewAction.ID != 0)
{
ANCChangeController.UpdateActionID(OriginalAction.ID, NewAction.ID);
}
}
}
//Jeśli jest zmiania w liście PNC to ma zmienic
if (ActionID.Singleton.PNCModification)
{
if (NewAction.PNC && OriginalAction.PNC)
{
IEnumerable <PNCListDB> PNCList = PNCSave.Save();
if (OriginalAction.ID != NewAction.ID && NewAction.ID != 0)
{
PNCListController.UpatePNCList(OriginalAction.ID, NewAction.ID, PNCList);
}
else
{
PNCListController.UpatePNCList(OriginalAction.ID, OriginalAction.ID, PNCList);
}
}
else if (NewAction.PNC && !OriginalAction.PNC)
{
IEnumerable <PNCListDB> PNCList = PNCSave.Save();
foreach (PNCListDB PNC in PNCList)
{
PNC.ActionID = NewAction.ID;
}
PNCListController.Add(PNCList);
}
else if (!NewAction.PNC && OriginalAction.PNC)
{
PNCListController.Deactivation(OriginalAction.ID);
}
}
else
{
//Update tylko ID akcji
if (OriginalAction.ID != NewAction.ID && NewAction.ID != 0)
{
PNCListController.UpdateID(OriginalAction.ID, NewAction.ID);
}
}
if (ActionID.Singleton.PNCSpecModification)
{
if (NewAction.PNCSpec && OriginalAction.PNCSpec)
{//Update
IEnumerable <PNCSpecialDB> List = PNCSpecialSave.Save();
if (OriginalAction.ID != NewAction.ID && NewAction.ID != 0)
{
PNCSpecialController.UpdateList(List, OriginalAction.ID, NewAction.ID);
}
else
{
PNCSpecialController.UpdateList(List, OriginalAction.ID, OriginalAction.ID);
}
}
else if (NewAction.PNCSpec && !OriginalAction.PNCSpec)
{//Nowe
IEnumerable <PNCSpecialDB> List = PNCSpecialSave.Save();
foreach (PNCSpecialDB PNC in List)
{
PNC.ActionID = NewAction.ID;
}
PNCSpecialController.Add(List);
}
else if (!NewAction.PNCSpec && OriginalAction.PNCSpec)
{//Usuwamy
PNCSpecialController.Deactivation(OriginalAction.ID);
}
}
}
else
{
ActionDB ActionToSave = ActionSave.Save();
ActionToSave.Rev = 1;
ActionToSave.ActionIDOriginal = 0;
ActionController.NewAction(ActionToSave);
OriginalAction = ActionController.FindAction(ActionToSave.Name, ActionToSave.StartYear);
//IEnumerable<ANCChangeDB> ListANC = ANCChangeSave.ANCSave();
//foreach(var ANC in ListANC)
//{
// ANC.ActionID = OriginalAction.ID;
// ANC.Rev = 1;
//}
//ANCChangeController.Add(ListANC);
//if (OriginalAction.ANCSpec)
//{
// CalculationMassDB MassList = CalculationMassSave.Mass();
// MassList.ActionID = OriginalAction.ID;
// MassList.Rev = 1;
// CalculationMassController.Add(MassList);
//}
//else if(OriginalAction.PNC)
//{
// IEnumerable<PNCListDB> PNCList = PNCSave.Save();
// foreach(var Row in PNCList)
// {
// Row.ActionID = OriginalAction.ID;
// Row.Rev = 1;
// }
//}
//else if(OriginalAction.PNCSpec)
//{
// IEnumerable<PNCSpecialDB> PNCSpecialList = PNCSpecialSave.Save();
// foreach(var Row in PNCSpecialList)
// {
// Row.ActionID = OriginalAction.ID;
// Row.Rev = 1;
// }
//}
}
}
public static ActionDB Save()
{
ActionDB ActionToSave = new ActionDB();
var ActionForm = MainProgram.Self.actionView;
ActionToSave.Name = ActionForm.nameView.GetActionName();
ActionToSave.Description = ActionForm.nameView.GetDescription();
if (ActionForm.stateView.GetActive())
{
ActionToSave.Status = "Active";
}
if (ActionForm.stateView.GetIdea())
{
ActionToSave.Status = "Idea";
}
ActionToSave.Group = ActionForm.stateView.GetDevison();
ActionToSave.Devision = ActionForm.stateView.GetDevison();
ActionToSave.Factory = ActionForm.stateView.GetFactory();
ActionToSave.Leader = ActionForm.stateView.GetLeader();
ActionToSave.StartYear = Convert.ToInt32(ActionForm.stateView.GetYear());
ActionToSave.MonthStart = ActionForm.stateView.GetStartMonth();
//Platform and Instalation
ActionToSave.Platform_DMD = ActionForm.platformView.GetDMD();
ActionToSave.Platform_D45 = ActionForm.platformView.GetD45();
ActionToSave.Installation_FS = ActionForm.installationView.GetFS();
ActionToSave.Installation_FI = ActionForm.installationView.GetFI();
ActionToSave.Installation_BI = ActionForm.installationView.GetBI();
ActionToSave.Installation_FSBU = ActionForm.installationView.GetFSBU();
//Sposób kalkulacji
ActionToSave.ANC = ActionForm.calculationByView.GetANC();
ActionToSave.ANCSpec = ActionForm.calculationByView.GetANCSpec();
ActionToSave.PNC = ActionForm.calculationByView.GetPNC();
ActionToSave.PNCSpec = ActionForm.calculationByView.GetPNCSpec();
//ECCC
ActionToSave.ECCC = ActionForm.ecccView.GetECCC();
ActionToSave.ECCC_Sec = Convert.ToDouble(ActionForm.ecccView.GetECCCSec());
ActionToSave.ECCC_PNCSpec = ActionForm.ecccView.GetECCCSpec();
//Calcby ANC or MAss
ActionToSave.ANC_Calc = ActionForm.CalculationGroup.GetANCbyGroup();
ActionToSave.Group_Calc = ActionForm.CalculationGroup.GetMassGroup();
//PNC Special Estymation
ActionToSave.PNCSpec_Estimation = Convert.ToDouble(ActionForm.PNCSpecialEstymationView.GetPNCEstymation());
//Revision info
ActionToSave.Active = true;
ActionToSave.ChangeBy = Environment.UserName.ToLower();
ActionToSave.ChangeTime = DateTime.UtcNow;
return(ActionToSave);
}
