public FrmNewDrug(spDrug d)
{
InitializeComponent();
db = new UnitOfWork();
FormClosed += (s, e) => { db.Dispose(); };
lb1.Visible = false;
lb2.Visible = false;
if (d != null)
{
drug = d;
SetData();
}
else
{
drug = new spDrug();
drug.CreateDate = DateTime.Now;
drug.CreateUser = Vars.UserId;
drug.Status = 1;
drug.Barcode = Vars.BarcodeEmpty;
}
cbUnit.Properties.DataSource = db.Unit.GetSp();
cbManufacturer.Properties.DataSource = db.Manufacturer.GetSp();
cbDrugCategory.Properties.DataSource = db.DrugCategory.GetSp();
cbPharmGroup.Properties.DataSource = db.PharmGroup.GetSp();
}
public static void Run(MyDbContext pgDb)
{
var dlist = pgDb.tbImports
.AsNoTracking()
.ToList();
var ph = new tbProductHeader();
ph.Status = 1;
ph.CreateDate = DateTime.Now;
ph.CreateUser = 1;
pgDb.tbProductHeaders.Add(ph);
foreach (var it in dlist)
{
if (pgDb.spDrugs.Find(it.DrugId) == null)
{
var di = new spDrug();
di.Id = it.DrugId;
di.Barcode = "000000";
di.Name = it.DrugName.ToLower();
di.Description = it.DrugName;
di.InternationalName = "";
di.Dose = "0";
di.ManufacturerId = 1;
di.DrugCategoryId = 1;
di.PharmGroupId = 1;
di.UnitId = 1;
di.Piece = 1;
di.Special = 0;
di.Photo = "";
di.VatRate = 0;
di.DrugRecomendation = "";
di.Status = 1;
di.CreateDate = DateTime.Now;
di.CreateUser = 1;
pgDb.spDrugs.Add(di);
}
var dp = new tbProductDetails();
dp.ProductHeader = ph;
dp.DrugId = it.DrugId;
dp.SeriesNo = it.SeriesNo;
dp.Qty = -1;
dp.CurQty = -1;
dp.Price = it.Price;
dp.Vat = 0;
dp.ExpiryDate = it.ExpiryDate;
dp.BasePrice = -1;
dp.IncomingPrice = -1;
dp.ExtraCharge = -1;
dp.Status = 1;
dp.CreateDate = DateTime.Now;
dp.CreateUser = 1;
pgDb.tbProductDetails.Add(dp);
}
pgDb.ChangeTracker.DetectChanges();
pgDb.SaveChanges();
}
private void ShowForm(string id)
{
spDrug drug = null;
if (!string.IsNullOrWhiteSpace(id))
{
drug = db.Drugs.GetById(id.ToString());
}
var index = gridView1.FocusedRowHandle;
var f = new FrmNewDrug(drug);
if (f.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
gridControl.DataSource = null;
gridControl.DataSource = db.Drugs.GetViDrugListForGrid();
gridView1.FocusedRowHandle = index;
}
f.Dispose();
}
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();
}
