public ManualUpdateSTK(string[] STKData, int Year)
{
List <STKDB> NewSTKManual = new List <STKDB>();
foreach (string OneRow in STKData)
{
string[] ToAdd = OneRow.Split('\t');
if (ToAdd.Length != 1 && ToAdd.Length == 4)
{
var NewRow = new STKDB
{
ANC = ToAdd[0],
Description = ToAdd[1],
IDCO = ToAdd[2],
Year = Year,
Month = 0,
Day = 0,
Value = Convert.ToDouble(ToAdd[3]),
};
NewSTKManual.Add(NewRow);
}
}
if (NewSTKManual != null)
{
STKController.AddManualUpdate(NewSTKManual);
}
}
private void But_STK_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
var Option = MainProgram.Self.adminTableView.optionsView;
var Table = MainProgram.Self.adminTableView.ReturnDataGridView();
Table.DataSource = STKController.Load_By_Year(Convert.ToInt32(Option.GetYear()));
Cursor.Current = Cursors.Default;
}
public FindSTK(int Count, string NewOld, string ANC, double Quantity)
{
Cursor.Current = Cursors.WaitCursor;
if (ANC == "n/a" || ANC == string.Empty)
{
if (NewOld == "New")
{
MainProgram.Self.actionView.StkChange.SetNewSTK(Count, ANC);
}
else if (NewOld == "Old")
{
MainProgram.Self.actionView.StkChange.SetOldSTK(Count, ANC);
}
}
else
{
decimal ActionYear = MainProgram.Self.actionView.stateView.GetYear();
var ANCSTK = STKController.Load(Convert.ToInt32(ActionYear), ANC);
if (ANCSTK == null)
{
if (NewOld == "New")
{
MainProgram.Self.actionView.StkChange.SetNewSTK(Count, "n/a");
}
else if (NewOld == "Old")
{
MainProgram.Self.actionView.StkChange.SetOldSTK(Count, "n/a");
}
}
else
{
if (NewOld == "New")
{
double Suma = ANCSTK.Value * Quantity;
Suma = Math.Round(Suma, 4, MidpointRounding.AwayFromZero);
MainProgram.Self.actionView.StkChange.SetNewSTK(Count, Suma.ToString());
MainProgram.Self.actionView.ANCChangeView.SetNewIDCO(Count, ANCSTK.IDCO);
}
else if (NewOld == "Old")
{
double Suma = ANCSTK.Value * Quantity;
Suma = Math.Round(Suma, 4, MidpointRounding.AwayFromZero);
MainProgram.Self.actionView.StkChange.SetOldSTK(Count, Suma.ToString());
MainProgram.Self.actionView.ANCChangeView.SetOldIDCO(Count, ANCSTK.IDCO);
}
}
}
Cursor.Current = Cursors.Default;
}
public STKUpdate_ManualUpdate(int Year)
{
var List = STKController.Load_By_Year(Year);
if (List != null)
{
DialogResult Results = MessageBox.Show("Dane STK na rok " + Year.ToString() + " istnieją!. Czy zamienić je ?", "Uwaga", MessageBoxButtons.YesNo);
if (Results == DialogResult.Yes)
{
STKController.Remove_Year(Year);
}
else
{
return;
}
}
_ = new AddData("Wprowadz dane STK dla Manualanego zaktualizowania", Year);
}
public STKUpdateRemove(int Year)
{
STKController.Remove_Year(Year);
}
public STKUpdate()
{
string FileName;
string[] STKFile;
int Add = 0;
int Update = 0;
FileName = FindLink();
if (FileName == string.Empty)
{
MessageBox.Show("Brak pliku z STK od 10 dni lub w tym roku");
return;
}
var STKDataBase = STKController.Load_By_Year(DateTime.UtcNow.Year);
STKFile = File.ReadAllLines(FileName);
foreach (string OneLine in STKFile)
{
string ANC;
int Year;
int Month;
int Day;
double STK;
string Name;
string IDCO;
string line_help = OneLine;
line_help = line_help.Remove(0, 2);
ANC = line_help.Remove(9);
line_help = line_help.Remove(0, 11);
Year = 2000 + Convert.ToInt32(line_help.Remove(2));
line_help = line_help.Remove(0, 2);
Month = Convert.ToInt32(line_help.Remove(2));
line_help = line_help.Remove(0, 2);
Day = Convert.ToInt32(line_help.Remove(2));
line_help = line_help.Remove(0, 2);
STK = Convert.ToDouble(line_help.Remove(9)) / 10000;
line_help = line_help.Remove(0, 154);
Name = line_help.Remove(30).Trim();
line_help = line_help.Remove(0, 31);
IDCO = line_help.Remove(4);
if (Skip(Name))
{
STKDB Find = STKDataBase.Where(u => u.ANC == ANC).FirstOrDefault();
if (Find == null)
{
var NewRow = new STKDB
{
ANC = ANC,
Description = Name,
IDCO = IDCO,
Day = Day,
Month = Month,
Year = Year,
Value = STK,
};
STKController.AddNewValue(NewRow);
Add++;
}
else
{
if (STK != Find.Value)
{
Find.Description = Name;
Find.IDCO = IDCO;
Find.Day = Day;
Find.Month = Month;
Find.Year = Year;
Find.Value = STK;
STKController.UpdateValue(Find);
Update++;
}
}
}
}
MessageBox.Show("Dodano: " + Add.ToString() + Environment.NewLine + "Zaktualizwoano: " + Update.ToString());
}
public static bool Find(DataTable PNCList)
{
DataRow PNCRow;
decimal Year;
STKList = new List <STKDB>();
PNCRow = PNCList.NewRow();
Year = MainProgram.Self.actionView.stateView.GetYear();
foreach (DataRow Row in PNCList.Rows)
{
if (Row["PNC"].ToString() != string.Empty)
{
PNCRow = Row;
}
else
{
if (Row["OLD ANC"].ToString() != string.Empty)
{
if (!STKList.Any(x => x.ANC == Row["OLD ANC"].ToString()))
{
STKDB FindSTK = STKController.Load(Convert.ToInt32(Year), Row["OLD ANC"].ToString());
if (FindSTK != null)
{
STKList.Add(FindSTK);
}
}
if (STKList.Any(x => x.ANC == Row["OLD ANC"].ToString()))
{
STKDB STK = STKList.Find(u => u.ANC == Row["OLD ANC"].ToString());
double Value = STK.Value * Convert.ToDouble(Row["OLD Q"].ToString());
Value = Math.Round(Value, 4, MidpointRounding.AwayFromZero);
Row["OLD STK"] = Value.ToString();
if (PNCRow["OLD STK"].ToString() != string.Empty)
{
PNCRow["OLD STK"] = (Convert.ToDouble(PNCRow["OLD STK"].ToString()) + Value).ToString();
}
else
{
PNCRow["OLD STK"] = Value.ToString();
}
}
}
if (Row["NEW ANC"].ToString() != string.Empty)
{
if (!STKList.Any(x => x.ANC == Row["NEW ANC"].ToString()))
{
STKDB FindSTK = STKController.Load(Convert.ToInt32(Year), Row["NEW ANC"].ToString());
if (FindSTK != null)
{
STKList.Add(FindSTK);
}
}
if (STKList.Any(x => x.ANC == Row["NEW ANC"].ToString()))
{
STKDB STK = STKList.Find(u => u.ANC == Row["NEW ANC"].ToString());
double Value = STK.Value * Convert.ToDouble(Row["NEW Q"].ToString());
Value = Math.Round(Value, 4, MidpointRounding.AwayFromZero);
Row["NEW STK"] = Value.ToString();
if (PNCRow["NEW STK"].ToString() != string.Empty)
{
PNCRow["NEW STK"] = (Convert.ToDouble(PNCRow["NEW STK"].ToString()) + Value).ToString();
}
else
{
PNCRow["NEW STK"] = Value.ToString();
}
}
}
double Delta = 0;
if (Row["OLD STK"].ToString() != string.Empty)
{
Delta = Convert.ToDouble(Row["OLD STK"].ToString());
}
if (Row["NEW STK"].ToString() != string.Empty)
{
Delta -= Convert.ToDouble(Row["NEW STK"].ToString());
}
Delta = Math.Round(Delta, 4, MidpointRounding.AwayFromZero);
Row["Delta"] = Delta.ToString();
if (PNCRow["Delta"].ToString() != string.Empty)
{
PNCRow["Delta"] = (Convert.ToDouble(PNCRow["Delta"].ToString()) + Delta).ToString();
}
else
{
PNCRow["Delta"] = Delta.ToString();
}
}
}
MainProgram.Self.actionView.PNCListView.SetPNCSpecial(PNCList);
foreach (STKDB STK in STKList)
{
MainProgram.Self.actionView.PNCListView.AddIDCOValue(STK.ANC, STK.IDCO);
}
return(true);
}
