public spManufacturer GetData()
{
var cp = new spManufacturer();
cp.Id = Guid.NewGuid();
cp.CountryId = cbCountry.EditValue.ToInt();
cp.Name = edName.Text;
cp.Status = 1;
cp.CreateDate = DateTime.Now;
cp.CreateUser = Vars.UserId;
return(cp);
}
public static void Run(Apteka.SqlServer.AptekaSqlServerDbContext sqlDb, MyDbContext pgDb)
{
var dlist = sqlDb.spDrugs
.Include(x => x.Manufacturer)
.Include(x => x.DrugCategory)
.Include(x => x.PharmGroup)
.Include(x => x.Unit).AsNoTracking().ToList();
spManufacturer sm = null;
spDrugCategory sd = null;
spPharmGroup sp = null;
spUnit su = null;
foreach (var it in dlist)
{
if (it.Manufacturer != null)
{
sm = new spManufacturer();
// sm.Id = it.Manufacturer.ServerId ?? it.Manufacturer.ServerId.Value;
sm.CountryId = it.Manufacturer.CountryId;
sm.Name = it.Manufacturer.Name;
sm.CreateDate = DateTime.Now;
sm.CreateUser = 1;
sm.Status = 1;
}
if (it.DrugCategory != null)
{
sd = new spDrugCategory();
// sd.Id = it.DrugCategory.ServerId ?? it.DrugCategory.ServerId.Value;
sd.Name = it.DrugCategory.Name;
sd.CreateDate = DateTime.Now;
sd.CreateUser = 1;
sd.Status = 1;
}
if (it.PharmGroup != null)
{
sp = new spPharmGroup();
// sp.Id = it.PharmGroup.ServerId ?? it.PharmGroup.ServerId.Value;
sp.Name = it.PharmGroup.Name;
sp.CreateDate = DateTime.Now;
sp.CreateUser = 1;
sp.Status = 1;
}
if (it.Unit != null)
{
su = new spUnit();
//su.Id = it.Unit.ServerId ?? it.Unit.ServerId.Value;
su.Name = it.Unit.Name;
su.Impartible = it.Unit.Impartible;
su.CreateDate = DateTime.Now;
su.CreateUser = 1;
su.Status = 1;
}
if (it.ServerId == null) continue;
var di = new spDrug();
di.Id = it.ServerId??it.ServerId.Value;
di.Barcode = it.Barcode;
di.Name = it.Name;
di.Description = it.Description;
di.InternationalName = it.InternationalName;
di.Dose = it.Dose;
di.Manufacturer = sm;
di.DrugCategory = sd;
di.PharmGroup = sp;
di.Unit = su;
di.Piece = it.Piece;
di.Special = 0;
di.Photo = it.Photo;
di.VatRate = it.VatRate;
di.DrugRecomendation = it.DrugRecomendation;
di.Status = 1;
di.CreateDate = DateTime.Now;
di.CreateUser = 1;
pgDb.spDrugs.Add(di);
}
pgDb.ChangeTracker.DetectChanges();
pgDb.SaveChanges();
}
