public void Insert(BloodStockManagementModel model) { using (EHMSEntities ent = new EHMSEntities()) { var objToSave = AutoMapper.Mapper.Map <BloodStockManagementModel, BloodStockManagement>(model); objToSave.CreatedBy = 1; objToSave.CreatedDate = DateTime.Now; objToSave.SourceFrom = 0;//direct entry from stock entry ent.BloodStockManagements.Add(objToSave); ent.SaveChanges(); //insert into blood bank master BloodStockManagementMasterModel modelBloodMaster = new BloodStockManagementMasterModel(); modelBloodMaster.BloodType = model.BloodType; modelBloodMaster.QuantityML = model.QuantityML; modelBloodMaster.QuantityUnit = model.QuantityUnit; if (isBLoodGroupExist(model.BloodType)) { //update updateBloodStockMasterTable(modelBloodMaster); } else { //insert insertBloodStockMasterTable(modelBloodMaster); } } }
private void insertBloodStockMasterTable(BloodStockManagementMasterModel modelBloodMaster) { EHMSEntities ent = new EHMSEntities(); var objToSave = AutoMapper.Mapper.Map <BloodStockManagementMasterModel, BloodStockManagementMaster>(modelBloodMaster); ent.BloodStockManagementMasters.Add(objToSave); ent.SaveChanges(); //throw new NotImplementedException(); }
private void updateBloodStockMasterTable(BloodStockManagementMasterModel modelBloodMaster) { using (EHMSEntities ent = new EHMSEntities()) { BloodStockManagementMaster e = (from e1 in ent.BloodStockManagementMasters where e1.BloodType == modelBloodMaster.BloodType select e1).First(); e.QuantityUnit = e.QuantityUnit + modelBloodMaster.QuantityUnit; e.QuantityML = e.QuantityML + modelBloodMaster.QuantityML; ent.SaveChanges(); } }
public void Insert(BloodDonateModel model) { using (EHMSEntities ent = new EHMSEntities()) { var objToSave = AutoMapper.Mapper.Map <BloodDonateModel, BloodDonate>(model); objToSave.CreatedBy = 1; objToSave.CreatedDate = DateTime.Now; ent.BloodDonates.Add(objToSave); model.BloodDonateId = objToSave.BloodDonateId; ent.SaveChanges(); int lastInsertedId = ent.BloodDonates.Max(x => x.BloodDonateId); //Insert into BloodStock BloodStockManagementModel modelStock = new BloodStockManagementModel(); modelStock.QuantityUnit = model.Quantity; modelStock.BloodType = model.BloodGroup; modelStock.QuantityML = model.QuantityML; modelStock.PouchNumber = model.PouchNumber; var objTosaveStock = AutoMapper.Mapper.Map <BloodStockManagementModel, BloodStockManagement>(modelStock); objTosaveStock.CreatedBy = 1; objTosaveStock.CreatedDate = DateTime.Now; objTosaveStock.SourceFrom = lastInsertedId; ent.BloodStockManagements.Add(objTosaveStock); ent.SaveChanges(); //insert into blood bank master BloodStockManagementMasterModel modelBloodMaster = new BloodStockManagementMasterModel(); modelBloodMaster.BloodType = model.BloodGroup; modelBloodMaster.QuantityML = model.QuantityML; modelBloodMaster.QuantityUnit = model.Quantity; //insert if not update blood type if (isBLoodGroupExist(model.BloodGroup)) { //update updateBloodStockMasterTable(modelBloodMaster); } else { //insert insertBloodStockMasterTable(modelBloodMaster); } //SaveSubjectId(model); } }