//branches insert public List <dynamic> AddBranches(BranchDetailsUI Branches) { List <dynamic> ObjDynamic = new List <dynamic>(); BranchDetailsDTO BranchDTO = new BranchDetailsDTO(); BranchDTO.BranchId = Branches.BranchId; BranchDTO.BranchName = Branches.BranchName; BranchDTO.City = Branches.City; BranchDTO.FullAddress = Branches.FullAddress; BranchDTO.State = Branches.State; BranchDTO.Zip = Branches.Zip; BranchDTO.country = Branches.country; BranchDTO.UserID = Branches.UserID; BranchDTO.Type = 1; AddBranches(BranchDTO); ObjDynamic.Add(BranchDTO); return(ObjDynamic); }
public async Task <Guid> Save(BranchDetailsDTO model) { var check = model.Id == Guid.Empty; if (check) { model.IsFromLicense = false; } var branchId = _dataService.Add <Branch>(model); await _dataService.SaveChangesAsync(); if (check) { var applicationBranch = new ApplicationBranch { LimsDocumentId = model.ApplicationId, BranchId = branchId }; _dataService.Add(applicationBranch); await _dataService.SaveChangesAsync(); if (model.AppType == "TRL") { //Вид діяльності обраний в МПД var trlActivityTypeEnum = _dataService.GetEntity <EnumRecord>(x => x.Code == model.TrlActivityType)?.FirstOrDefault(); _dataService.Add(new EntityEnumRecords() { EntityId = branchId, EntityType = "BranchApplication", EnumRecordType = trlActivityTypeEnum?.EnumType, EnumRecordCode = trlActivityTypeEnum?.Code }); if (model.PharmacyId != null) { _dataService.Add(new PharmacyItemPharmacy() { PharmacyId = model.PharmacyId.Value, PharmacyItemId = branchId }); } await _dataService.SaveChangesAsync(); } } else { if (model.AppType == "TRL") { var pharmacyItem = _dataService.GetEntity <PharmacyItemPharmacy>(x => x.PharmacyItemId == branchId)?.FirstOrDefault(); if (pharmacyItem != null) { _dataService.Remove(pharmacyItem); } if (model.PharmacyId != null) { _dataService.Add(new PharmacyItemPharmacy() { PharmacyId = model.PharmacyId.Value, PharmacyItemId = branchId }); } var entityEnumRecords = _dataService.GetEntity <EntityEnumRecords>(x => x.EntityId == branchId).ToList(); if (entityEnumRecords.Count > 0) { entityEnumRecords.ForEach(x => _dataService.Remove(x)); } //Види діяльності обрані в МПД var trlActivityTypeEnum = _dataService.GetEntity <EnumRecord>(x => x.Code == model.TrlActivityType)?.FirstOrDefault(); _dataService.Add(new EntityEnumRecords() { EntityId = branchId, EntityType = "BranchApplication", EnumRecordType = trlActivityTypeEnum?.EnumType, EnumRecordCode = trlActivityTypeEnum?.Code }); await _dataService.SaveChangesAsync(); } } return(branchId); }
//Log log = new Log(); private int AddBranches(BranchDetailsDTO Brnches) { string insertProcedure = "[BranchMasterInsert]"; SqlCommand insertCommand = new SqlCommand(insertProcedure, connection); insertCommand.CommandType = CommandType.StoredProcedure; int BranchId = 0; if (Brnches.BranchId != 0) { insertCommand.Parameters.AddWithValue("@Pkey_Branch_id", Brnches.BranchId); } else { insertCommand.Parameters.AddWithValue("@Pkey_Branch_id", 0); } if (!string.IsNullOrEmpty(Brnches.BranchName)) { insertCommand.Parameters.AddWithValue("@Branch_name", Brnches.BranchName); } else { insertCommand.Parameters.AddWithValue("@Branch_name", DBNull.Value); } if (!string.IsNullOrEmpty(Brnches.BranchEmail)) { insertCommand.Parameters.AddWithValue("@address3", Brnches.BranchEmail); } else { insertCommand.Parameters.AddWithValue("@address3", DBNull.Value); } //if (Brnches.BranchPhone != 0) //{ // insertCommand.Parameters.AddWithValue("@", Brnches.BranchPhone); //} //else //{ // insertCommand.Parameters.AddWithValue("@", 0); //} if (!string.IsNullOrEmpty(Brnches.FullAddress)) { insertCommand.Parameters.AddWithValue("@address1", Brnches.FullAddress); } else { insertCommand.Parameters.AddWithValue("@address1", DBNull.Value); } if (!string.IsNullOrEmpty(Brnches.FullAddress)) { insertCommand.Parameters.AddWithValue("@address2", Brnches.FullAddress); } else { insertCommand.Parameters.AddWithValue("@address2", DBNull.Value); } if (!string.IsNullOrEmpty(Brnches.City)) { insertCommand.Parameters.AddWithValue("@city", Brnches.City); } else { insertCommand.Parameters.AddWithValue("@city", DBNull.Value); } if (!string.IsNullOrEmpty(Brnches.State)) { insertCommand.Parameters.AddWithValue("@state", Brnches.State); } else { insertCommand.Parameters.AddWithValue("@state", DBNull.Value); } if (!string.IsNullOrEmpty(Brnches.country)) { insertCommand.Parameters.AddWithValue("@country", Brnches.country); } else { insertCommand.Parameters.AddWithValue("@country", DBNull.Value); } if (Brnches.Zip != 0) { insertCommand.Parameters.AddWithValue("@pincode", Brnches.Zip); } else { insertCommand.Parameters.AddWithValue("@pincode", 0); } if (Brnches.UserID != 0) { insertCommand.Parameters.AddWithValue("@UserID", Brnches.UserID); } else { insertCommand.Parameters.AddWithValue("@UserID", 0); } insertCommand.Parameters.AddWithValue("@is_delete", 0); insertCommand.Parameters.AddWithValue("@Type", Brnches.Type); insertCommand.Parameters.Add("@Pkey_Branch_idout", System.Data.SqlDbType.Int); insertCommand.Parameters["@Pkey_Branch_idout"].Direction = ParameterDirection.Output; insertCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int); insertCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output; try { int count = 0; connection.Open(); insertCommand.ExecuteNonQuery(); if (insertCommand.Parameters["@ReturnValue"].Value != DBNull.Value) { count = System.Convert.ToInt32(insertCommand.Parameters["@ReturnValue"].Value); } if (count != 0 && Brnches.BranchId == 0) { Brnches.BranchId = Convert.ToInt32(insertCommand.Parameters["@Pkey_Branch_idout"].Value); } return(BranchId); } catch (Exception ex) { //log.logErrorMessage(""); //log.logErrorMessage(ex.StackTrace); return(BranchId); } finally { connection.Close(); } }