private int AddDirectoryToDB(string path, PSContext db)
{
Directory directory = new Directory()
{
FileDirectory = path
};
db.Directory.Add(directory);
db.SaveChanges();
directoryList.Add(directory.FileDirectory, directory.Id);
return(directory.Id);
}
public List <OpstiDomenskiObjekat> pretraziProizvode(OpstiDomenskiObjekat o)
{
Roba r = o as Roba;
List <OpstiDomenskiObjekat> objekti = new List <OpstiDomenskiObjekat>();
using (var context = new PSContext())
{
context.StavkeOtpremnice.Where(x => x.RobaID == r.RobaID).ToList().ForEach(a => objekti.Add(a));
context.StavkePrijemnice.Where(x => x.RobaID == r.RobaID).ToList().ForEach(a => objekti.Add(a));
}
return(objekti);
}
private void AddToDB(PictureInfo pictureInfo)
{
using (var db = new PSContext(_config.DBConnection))
{
var checkDirectoryIsOnList = directoryList.TryGetValue(pictureInfo.Path, out int directoryId);
if (!checkDirectoryIsOnList)
{
directoryId = AddDirectoryToDB(pictureInfo.Path, db);
}
AddPictureToDB(pictureInfo, directoryId, db);
};
}
public bool kreirajRevers(Revers r)
{
using (var conext = new PSContext())
{
conext.Revers.Add(r);
if (conext.SaveChanges() == 1)
{
return(true);
}
else
{
return(false);
}
}
}
public static TypeOfEntity GetExportType(this EntityType type, PSContext ctx)
{
if (ctx.EntityTypes.ProjectEntity.Name == type.Name)
{
return(TypeOfEntity.Project);
}
else if (ctx.EntityTypes.TaskEntity.Name == type.Name)
{
return(TypeOfEntity.Task);
}
else if (ctx.EntityTypes.ResourceEntity.Name == type.Name)
{
return(TypeOfEntity.Resource);
}
return(TypeOfEntity.Undefined);
}
public static ExportEnterpriseField GetExportField(this CustomField cf, PSContext ctx)
{
return(new ExportEnterpriseField()
{
Id = cf.Id,
Name = cf.Name,
Description = cf.Description,
EntityType = cf.EntityType.GetExportType(ctx),
FieldType = cf.FieldType,
Formula = cf.Formula,
IsEditableInVisibility = cf.IsEditableInVisibility,
IsMultilineText = cf.IsMultilineText,
IsRequired = cf.IsRequired,
IsWorkflowControlled = cf.IsWorkflowControlled,
LookupAllowMultiSelect = cf.LookupAllowMultiSelect,
LookupDefaultValue = cf.LookupDefaultValue,
LookupTable = (bool)cf.LookupTable.ServerObjectIsNull ? null : cf.LookupTable?.Id
});
}
public bool Edit(Poliza entidad)
{
using (PSContext cnx = new PSContext())
{
Poliza poliza = cnx.Polizas.Find(entidad.IdPoliza);
if (poliza != null)
{
poliza.IdTipoRiesgo = entidad.IdTipoRiesgo;
poliza.NombrePoliza = entidad.NombrePoliza;
poliza.PrecioPoliza = entidad.PrecioPoliza;
poliza.FechaInicioVigencia = entidad.FechaInicioVigencia;
poliza.DescripcionPoliza = entidad.DescripcionPoliza;
cnx.SaveChanges();
return(true);
}
return(false);
}
}
public bool IzvrsiSo(OpstiDomenskiObjekat odo)
{
bool rezultat;
using (var context = new PSContext())
{
using (var transaction = context.Database.BeginTransaction())
{
rezultat = izvrsi(odo);
if (rezultat)
{
transaction.Commit();
}
else
{
transaction.Rollback();
}
}
}
return(rezultat);
}
public static ExportLookupTable GetExportTable(this LookupTable t, PSContext ctx)
{
return(new ExportLookupTable()
{
Id = t.Id,
Name = t.Name,
Entries = t.Entries.Select(e => new ExportLookupText()
{
FullValue = e.FullValue,
Id = e.Id
}).ToList(),
FieldType = t.FieldType,
Masks = t.Masks.Select(m => new ExportLookupMask()
{
MaskType = m.MaskType,
Length = m.Length,
Separator = m.Separator
}).ToList(),
SortOrder = t.SortOrder
});
}
private void AddPictureToDB(PictureInfo p, int directoryId, PSContext db)
{
Picture picture = new Picture()
{
DirectoryId = directoryId,
CenterBottom = p.CenterBottom,
CenterCenter = p.CenterCenter,
CenterTop = p.CenterTop,
LeftBottom = p.LeftBottom,
LeftCenter = p.LeftCenter,
LeftTop = p.LeftTop,
RightBottom = p.RightBottom,
RightCenter = p.RightCenter,
RightTop = p.RightTop,
FileName = p.FileName,
CreationFileDate = p.CreationFileDate,
};
db.Picture.Add(picture);
db.SaveChanges();
}
private void bSubmit_Click(object sender, EventArgs e)
{
try
{
PSContext.IsOnline = rbOnline.Checked;
PSContext.PSUrl = tbUrl.Text;
PSContext.UserName = tbUsername.Text;
PSContext.Password = tbPass.Text;
PSContext.Domain = tbDomain.Text;
using (var ctx = new PSContext())
{
this.Hide();
ExportImportForm form = new ExportImportForm();
form.Show();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public bool sacuvajOtpremnicu(OpstiDomenskiObjekat o)
{
Otpremnica otpremnica = o as Otpremnica;
try
{
using (var context = new PSContext())
{
using (var transakcija = context.Database.BeginTransaction())
{
//otpremnica.KupacID = otpremnica.Kupac.KupacID;
//otpremnica.Kupac = null;
foreach (StavkaOtpremnice item in otpremnica.Stavke)
{
//item.RobaID = item.Roba.RobaID;
//item.Roba = null;
}
context.Dokumenti.Add(otpremnica);
if (context.SaveChanges() > 0)
{
transakcija.Commit();
return(true);
}
else
{
transakcija.Rollback();
return(false);
}
}
}
}
catch (Exception)
{
return(false);
}
}
public PutProductCommandHandler(PSContext context)
{
_context = context;
}
public DeleteProductCommandHandler(PSContext context)
{
_context = context;
}
public GetProductQueryHandler(PSContext context)
{
_context = context;
}
