private void LogX_SelectCommonType_Execute(object sender, PopupWindowShowActionExecuteEventArgs e)
{
foreach (CommonTrType selectedItem in e.PopupWindowViewSelectedObjects)
{
if (selectedItem != null)
{
CommonTrHeader ctrh = (CommonTrHeader)View.CurrentObject;
CommonTrType ctrt = View.ObjectSpace.FindObject <CommonTrType>(new BinaryOperator("Oid", selectedItem.Oid));
ctrh.CommonType = ctrt;
//ObjectSpace.CommitChanges()
}
}
}
public ushort GetNewSorszam(string commonType)
{
decimal ujSorszam = 0;
Session workSession = new Session();
CommonTrType cType = workSession.FindObject <CommonTrType>(new BinaryOperator("Type", commonType));
Sorszam tpoSorszam = null;
lock (sorszamLock)
{
DateTime date = DateTime.Now;
//Megkeressük, hogy a sorszámot aszerint, hogyy évfüggő vagy nem
if (cType.DateDepended)
{
CriteriaOperator cop = new GroupOperator(GroupOperatorType.And, new BinaryOperator("Type", cType.Oid), new BinaryOperator("Year", date.Year));
tpoSorszam = (Sorszam)workSession.FindObject(typeof(Sorszam), cop);
}
else
{
CriteriaOperator cop = new GroupOperator(GroupOperatorType.And, new BinaryOperator("Type", cType.Oid), new BinaryOperator("Year", 0));
tpoSorszam = (Sorszam)workSession.FindObject(typeof(Sorszam), cop);
}
// Ha nem létezik sorszám létrehozunk egyet
if (tpoSorszam == null)
{
tpoSorszam = new Sorszam(workSession);
tpoSorszam.Type = cType;
if (cType.DateDepended)
{
tpoSorszam.Year = Convert.ToUInt16(date.Year);
}
else
{
tpoSorszam.Year = 0;
}
tpoSorszam.LastNum = 1;
ujSorszam = 1;
tpoSorszam.Save();
}
// Ha létezik akkor kérünk egy új sorszámot
else
{
ujSorszam = tpoSorszam.GetNewNumber();
tpoSorszam.Save();
}
}
return(Convert.ToUInt16(ujSorszam));
}
private void Import_CommonTrType()
{
int rekord = 0;
using (var fileStream = new FileStream(@"C:\Users\Halász Alexandra\OneDrive\LogX\halaszalexandra\LOGX\Imports\LogX_CommonTrType_Trans.csv", FileMode.Open, FileAccess.Read))
{
StreamReader reader = new StreamReader(fileStream);
while (!reader.EndOfStream)
{
string line = reader.ReadLine();
var values = line.Split(';');
if (rekord > 0)
{
CriteriaOperator criteriaDefPartner = new BinaryOperator("Name", values[3]);
Customer c = (Customer)View.ObjectSpace.FindObject(typeof(Customer), criteriaDefPartner, true);
if (values[0] != "")
{
CommonTrType ctrt = View.ObjectSpace.CreateObject <CommonTrType>();
ctrt.Type = values[0];
ctrt.Prefix = values[1];
ctrt.DateDepended = Convert.ToBoolean(values[2]);
ctrt.DefaultPartner = c;
ctrt.Name = values[4];
ctrt.Creatable = Convert.ToBoolean(values[5]);
ctrt.Save();
Sorszam sorszam = View.ObjectSpace.CreateObject <Sorszam>();
sorszam.Type = ctrt;
sorszam.LastNum = 0;
if (ctrt.DateDepended)
{
sorszam.Year = 2019;
}
else
{
sorszam.Year = 0;
}
sorszam.Save();
}
}
rekord++;
}
View.ObjectSpace.CommitChanges();
}
}
private void ResetTransportID()
{
CriteriaOperator copType = new BinaryOperator("Type", "TPO");
CommonTrType cTpId = (CommonTrType)View.ObjectSpace.FindObject(typeof(CommonTrType), copType);
CriteriaOperator copSorszam = new BinaryOperator("Oid", cTpId.Oid);
Sorszam sorszam = (Sorszam)View.ObjectSpace.FindObject(typeof(Sorszam), copSorszam);
if (sorszam != null)
{
sorszam.LastNum = 0;
}
//View.ObjectSpace.CommitChanges();
}
