static void Main(string [] args)
{
using (PhoneContext db = new PhoneContext())
{
var phones = db.Phones.ToList();
}
}
public ActionResult AddPhoneNumber(PhoneModel model)
{
if (ModelState.IsValid)
{
using (var context = new ApplicationDbContext())
{
var existingModel = context.PhoneContexts.FirstOrDefault();
if (existingModel == null)
{
var phoneContext = new PhoneContext
{
Phone = model.Phone
};
context.PhoneContexts.Add(phoneContext);
}
else
{
existingModel.Phone = model.Phone;
}
context.SaveChanges();
}
}
return(View());
}
public SearchPage()
{
InitializeComponent();
context = new PhoneContext();
service = new SearchService(context);
vService = new ValidationServise();
}
public SearchPage(SearchService service)
{
InitializeComponent();
context = new PhoneContext();
this.service = service;
vService = new ValidationServise();
}
public static void AddUpdatePhoneBookDetails(PhoneDetails phoneDetails)
{
try
{
var context = new PhoneContext();
if (phoneDetails.PhoneBookId == 0)
{
context.dbPhoneDetails.Add(phoneDetails);
context.SaveChanges();
}
else
{
var result = context.dbPhoneDetails.Find(phoneDetails.PhoneBookId);
if (result != null)
{
context.Entry(result).CurrentValues.SetValues(phoneDetails);
context.SaveChanges();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public ViewRedactionPage()
{
InitializeComponent();
context = new PhoneContext();
vServise = new ValidationServise(errorLabel);
service = new RedactionService(context);
}
public DeletePage()
{
InitializeComponent();
context = new PhoneContext();
service = new DeleteService(context);
personalGrid.ItemsSource = context.PersPhone.ToList();
corporativeGrid.ItemsSource = context.CorpPhones.ToList();
}
public ViewPhonesPage()
{
InitializeComponent();
PhoneContext db = new PhoneContext();
personalGrid.ItemsSource = db.PersPhone.ToList <PersonalTelephone>();
corporativeGrid.ItemsSource = db.CorpPhones.ToList <CorporativeTelephone>();
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, PhoneContext context)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
app.UseMvc();
}
public LoginManage(UserContext userContext, PhoneContext phoneContext, BrandContext brandContext, BrandTypeContext brandTypeContext, BrandTypeProductNoContext brandTypeProductNoContext, TypeYearContext typeYearContext, DeleteReasonContext deleteReasonContext)
{
_userContext = userContext;
userIQ = _userContext.Users;
phoneDao = new PhoneDao(phoneContext);
brandDao = new BrandDao(brandContext);
brandTypeDao = new BrandTypeDao(brandTypeContext);
brandTypeProductNoDao = new BrandTypeProductNoDao(brandTypeProductNoContext);
typeYearDao = new TypeYearDao(typeYearContext);
deleteReasonDao = new DeleteReasonDao(deleteReasonContext);
}
public static List <PhoneDetails> GetPhoneBookDetailsBySearch(string searchText)
{
List <PhoneDetails> phoneDetails = new List <PhoneDetails>();
var context = new PhoneContext();
if (context.dbPhoneDetails.Any())
{
phoneDetails = context.dbPhoneDetails.Where(a => a.FirstName.Contains(searchText) ||
a.MiddleName.Contains(searchText) || a.LastName.Contains(searchText) ||
a.PhoneNo.Contains(searchText) || a.Email.Contains(searchText)).ToList <PhoneDetails>();
}
return(phoneDetails);
}
public List <PhoneVO> FindPhonesByPersonId(PhoneContext ctx, int personId)
{
List <PhoneVO> model = new List <PhoneVO>();
try
{
model = ctx.Phones.Where(x => x.PersonId == personId).ToList();
}
catch
{
throw;
}
return(model);
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
using (var db = new PhoneContext())
{
db.Database.Migrate();
}
app.UseMvc();
}
public PhoneController(PhoneContext context)
{
db = context;
if (!db.Phones.Any())
{
db.Phones.Add(new Phone {
ModelName = "iPhone X", Processor = "ARM", CameraMP = 20, Cores = 4, MemerySizeMB = 10240, RAMSizeMB = 2048, PhoneIMGName = "phone.jpg"
});
db.Phones.Add(new Phone {
ModelName = "Galaxy S8", Processor = "ARM", CameraMP = 30, Cores = 8, MemerySizeMB = 10240, RAMSizeMB = 2048, PhoneIMGName = "phone.jpg"
});
db.SaveChanges();
}
}
public static void DeletePhoneBookDetailsById(int phoneBookId)
{
try
{
var context = new PhoneContext();
PhoneDetails detail = new PhoneDetails {
PhoneBookId = phoneBookId
};
context.Entry(detail).State = EntityState.Deleted;
context.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public static PhoneDetails GetPhoneBookDetailsById(int phoneBookId)
{
try
{
PhoneDetails phoneDetails = new PhoneDetails();
var context = new PhoneContext();
if (context.dbPhoneDetails.Any())
{
phoneDetails = context.dbPhoneDetails.Where(a => a.PhoneBookId == phoneBookId).FirstOrDefault();
}
return(phoneDetails);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <PhoneDetails> GetAllPhoneBookDetails()
{
try
{
List <PhoneDetails> phoneDetails = new List <PhoneDetails>();
var context = new PhoneContext();
if (context.dbPhoneDetails.Any())
{
phoneDetails = context.dbPhoneDetails.ToList <PhoneDetails>();
}
return(phoneDetails);
}
catch (Exception ex)
{
throw ex;
}
}
public CvVO GetCvByMemberId(int memberId)
{
CvVO model = new CvVO();
try
{
using (var ctx = new CvContext())
{
model = new CvDA().FindCvByMemberId(ctx, memberId);
if (model.Id != 0 && model.Member != null && model.MemberId != 0 && model.Member.Person != null && model.Member.PersonId != 0)
{
Task <List <AddressVO> > addrTask;
using (var ctxAddr = new AddressContext())
{
addrTask = Task.Run(() => new AddressDA().FindAddressesByPersonId(ctxAddr, model.Member.PersonId));
using (var ctxEmail = new EmailContext())
{
Task <List <EmailVO> > emailTask = Task.Run(() => new EmailDA().FindEmailsByPersonId(ctxEmail, model.Member.PersonId));
using (var ctxPhone = new PhoneContext())
{
Task <List <PhoneVO> > phoneTask = Task.Run(() => new PhoneDA().FindPhonesByPersonId(ctxPhone, model.Member.PersonId));
Task.WhenAll(phoneTask, addrTask, emailTask);
model.Member.Person.Addresses = addrTask.Result;
model.Member.Person.Emails = emailTask.Result;
model.Member.Person.Phones = phoneTask.Result;
}
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(model);
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, PhoneContext context)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Error");
// The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
app.UseHsts();
}
context.Database.Migrate();
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseSpaStaticFiles();
app.UseRouting();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllerRoute(
name: "default",
pattern: "{controller}/{action=Index}/{id?}");
});
app.UseSpa(spa =>
{
spa.Options.SourcePath = "ClientApp";
if (env.IsDevelopment())
{
spa.UseReactDevelopmentServer(npmScript: "start");
}
});
}
public DeletePhoneCheckController(PhoneContext phoneContext)
{
_phoneContext = phoneContext;
phoneIQ = phoneContext.Phones;
deletePhoneCheckManage = new DeletePhoneCheckManage(phoneContext);
}
public ReplacePhoneCheckManage(PhoneContext phoneContext)
{
phoneDao = new PhoneDao(phoneContext);
}
public FetchPhonesController(PhoneContext _db, UserContext _dbu)
{
db = _db;
dbu = _dbu;
}
public PromDAO(PhoneContext context) : base(context)
{
}
public SearchService(PhoneContext context)
{
this.context = context;
}
public PhoneDao(PhoneContext phoneContext)
{
_phoneContext = phoneContext;
phoneIQ = _phoneContext.Phones;
}
public ContactInfosController(PhoneContext context)
{
_context = context;
}
public FeeModel(PhoneContext context, IMapper mapper) : base(context, mapper)
{
}
public ProductDAO(PhoneContext context) : base(context)
{
}
public OrderDAO(PhoneContext context) : base(context)
{
}
public ImportDAO(PhoneContext context) : base(context)
{
}
