/// <summary> /// This function changes the "ActiveStatus" of the CompanyDB Detail object to "False" /// </summary> /// <param name="CompanyDBId"></param> /// <returns></returns> public Boolean DeleteCompanyDB(CompanyDBDTO CompanyDBDTOobject) { bool flag = false; try { using (UnitOfWork uow = new UnitOfWork()) { CompanyDB companydbObj = new CompanyDB(); companydbObj.CompanyDBId = CompanyDBDTOobject.CompanyDBId; companydbObj.FkCompanyId = CompanyDBDTOobject.FkCompanyId; companydbObj.FkDatabaseInfoId = CompanyDBDTOobject.FkDatabaseInfoId; companydbObj.Active = false; companydbObj.RecordStatus = CompanyDBDTOobject.RecordStatus; companydbObj.CreatedBy = CompanyDBDTOobject.CreatedBy; companydbObj.CreatedDate = CompanyDBDTOobject.CreatedDate; companydbObj.LastModifiedBy = DateTime.Now; companydbObj.LastModifiedDate = DateTime.Now.Date; uow.CompanyDBRepo.Update(companydbObj); uow.Complete(); flag = true; } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e.Message); } return(flag); }
protected void btn_editarRazaoSocial_Click(object sender, EventArgs e) { if (txt_RazaoSocial.ReadOnly == false) { if (CompanyDB.UpdateRazaoSocial(txt_RazaoSocial.Text, Convert.ToInt32(Session["id"])) == 0) { ltl_status.Text = "<script type=text/javascript> toastr.success('Dados atualizados com sucesso') </script>"; txt_RazaoSocial.ReadOnly = true; txt_nomeFantasia.Enabled = false; btn_editarRazaoSocial.Text = ""; btn_editarRazaoSocial.Text = "<i class='fa fa-pencil-alt'></i>"; Page_Load(this, EventArgs.Empty); } else { ltl_status.Text = "<script type=text/javascript> toastr.error('Algo deu errado, tente novamente mais tarde') </script>"; } } else { btn_editarRazaoSocial.Text = "<i class='fa fa-check'></i>"; txt_RazaoSocial.ReadOnly = false; txt_RazaoSocial.Enabled = true; } }
protected void btn_alterarSenha_Click(object sender, EventArgs e) { if (UserDB.Criptografia(txt_oldSenha.Text) == UserDB.select_CompanyUserPassword(Convert.ToInt32(Session["id"]))) { if (txt_newSenha.Text == txt_newSenhaC.Text) { if (CompanyDB.UpdateSenha(UserDB.Criptografia(txt_newSenha.Text), Convert.ToInt32(Session["id"])) == 0) { ltl_status.Text = "<script type=text/javascript> toastr.success('Senha alterada com sucesso') </script>"; VisitorBD.SendEmailSenhaAtualizada(txt_email.Text); } else { ltl_status.Text = "<script type=text/javascript> toastr.error('Algo deu errado, tente novamente mais tarde') </script>"; } } else { ltl_status.Text = "<script type=text/javascript> toastr.error('As senhas digitadas não são iguais!') </script>"; } } else { ltl_status.Text = "<script type=text/javascript> toastr.error('Senha atual inválida') </script>"; } }
/// <summary> /// This function updates Company's Database Details in the database on the basis of "edited" details provided by the user /// </summary> /// <param name="CompanyDBDTOobject"></param> /// <returns></returns> public Boolean UpdateCompanyDBInfo(CompanyDBDTO CompanyDBDTOobject) { bool flag = false; try { using (UnitOfWork uow = new UnitOfWork()) { CompanyDB companydbObj = new CompanyDB(); DatabaseInfo databaseinfoObj = new DatabaseInfo(); databaseinfoObj.DatabaseInfoId = CompanyDBDTOobject.DatabaseInfo.DatabaseInfoId; databaseinfoObj.ServerName = CompanyDBDTOobject.DatabaseInfo.ServerName; databaseinfoObj.Authentication = CompanyDBDTOobject.DatabaseInfo.Authentication; databaseinfoObj.UserName = CompanyDBDTOobject.DatabaseInfo.UserName; databaseinfoObj.Password = CompanyDBDTOobject.DatabaseInfo.Password; databaseinfoObj.Active = CompanyDBDTOobject.DatabaseInfo.Active; databaseinfoObj.RecordStatus = CompanyDBDTOobject.DatabaseInfo.RecordStatus; databaseinfoObj.CreatedBy = CompanyDBDTOobject.DatabaseInfo.CreatedBy; databaseinfoObj.CreatedDate = CompanyDBDTOobject.DatabaseInfo.CreatedDate; databaseinfoObj.LastModifiedBy = DateTime.Now; databaseinfoObj.LastModifiedDate = DateTime.Now.Date; uow.DatabaseInfoRepo.Update(databaseinfoObj); uow.Complete(); flag = true; } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e.Message); } return(flag); }
public ActionResult Edit(CompanyViewModel viewModel)//nedds to take GUID not model, and need another POST method { Panta.Admin.Company.Models.Company model = AutoMapper.Mapper.Map <CompanyViewModel, Panta.Admin.Company.Models.Company>(viewModel); CompanyDB Dal = new CompanyDB(); Dal.Edit(model); return(View("Detail", viewModel)); }
public IHttpActionResult company(CompanyDB cdb) { PickMe2Entities pe = new PickMe2Entities(); pe.CompanyInsert(cdb.Company_id, cdb.Company_name, cdb.Company_address, cdb.Company_vendor_name, cdb.Company_email, cdb.Company_contact); pe.SaveChanges(); return(Ok()); }
public ActionResult DeleteConfirmed(int id) { CompanyDB company = db.CompanyDB.Find(id); db.CompanyDB.Remove(company); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create(CompanyViewModel viewModel) { Panta.Admin.Company.Models.Company model = AutoMapper.Mapper.Map <CompanyViewModel, Panta.Admin.Company.Models.Company>(viewModel); CompanyDB Dal = new CompanyDB(); Dal.Create(model); return(View("Detail", viewModel)); }
protected void Page_Load(object sender, EventArgs e) { firstload = false; int aux = (int)Session["id"]; name = (CompanyDB.selectEmpresa3(aux)); lbl_nomeEmp.Text = name; }
public ActionResult Edit([Bind(Include = "ID,Name,Address,Specialization")] CompanyDB company) { if (ModelState.IsValid) { db.Entry(company).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(company)); }
/// <summary> /// This function returns the details of CompanyDBData on the basis of CompanyDBId given by the user /// </summary> /// <param name="CompanyDBId"></param> /// <returns></returns> public CompanyDBDTO GetById(int CompanyDBId) { CompanyDBDTO CompanyDBDTOobject = new CompanyDBDTO(); try { using (UnitOfWork uow = new UnitOfWork()) { CompanyDB companydbObj = uow.CompanyDBRepo.GetById(CompanyDBId); CompanyDBDTOobject.CompanyDBId = companydbObj.CompanyDBId; CompanyDBDTOobject.Active = companydbObj.Active; CompanyDBDTOobject.RecordStatus = companydbObj.RecordStatus; CompanyDBDTOobject.CreatedBy = companydbObj.CreatedBy; CompanyDBDTOobject.CreatedDate = companydbObj.CreatedDate; CompanyDBDTOobject.LastModifiedBy = companydbObj.LastModifiedBy; CompanyDBDTOobject.LastModifiedDate = companydbObj.LastModifiedDate; CompanyDBDTOobject.FkCompanyId = companydbObj.FkCompanyId; CompanyDBDTOobject.FkDatabaseInfoId = companydbObj.FkDatabaseInfoId; CompanyDBDTOobject.Company = new CompanyDTO { CompanyId = companydbObj.Company.CompanyId, Company1 = companydbObj.Company.Company1, CompanyCode = companydbObj.Company.CompanyCode, Active = companydbObj.Company.Active, RecordStatus = companydbObj.Company.RecordStatus, CreatedBy = companydbObj.Company.CreatedBy, CreatedDate = companydbObj.Company.CreatedDate, LastModifiedBy = companydbObj.Company.LastModifiedBy, LastModifiedDate = companydbObj.Company.LastModifiedDate }; CompanyDBDTOobject.DatabaseInfo = new DatabaseInfoDTO { DatabaseInfoId = companydbObj.DatabaseInfo.DatabaseInfoId, ServerName = companydbObj.DatabaseInfo.ServerName, Authentication = companydbObj.DatabaseInfo.Authentication, UserName = companydbObj.DatabaseInfo.UserName, Password = companydbObj.DatabaseInfo.Password, Active = companydbObj.DatabaseInfo.Active, RecordStatus = companydbObj.DatabaseInfo.RecordStatus, CreatedBy = companydbObj.DatabaseInfo.CreatedBy, CreatedDate = companydbObj.DatabaseInfo.CreatedDate, LastModifiedBy = companydbObj.DatabaseInfo.LastModifiedBy, LastModifiedDate = companydbObj.DatabaseInfo.LastModifiedDate }; } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e.Message); } return(CompanyDBDTOobject); }
protected void btn_logar_Click(object sender, EventArgs e) { Usuario usu = new Usuario(); usu.Usu_email = userEmail.Text; usu.Usu_senha = UserDB.Criptografia(userSenha.Text.ToString()); int usu_id = UserDB.selectUser(usu); if (usu_id != 0) { if (UserDB.selectHashConf(usu_id).ToString().Equals("Confirmado")) { if (CompanyDB.selectEmpresa(Convert.ToString(usu_id)) == 1) { Session["cliente"] = false; Session["id"] = CompanyDB.selectEmpresa2(Convert.ToString(usu_id)); Session["empresa"] = true; Response.Redirect("../ToCompany/Home_emp.aspx"); } else if (UserDB.selectUser3(Convert.ToString(usu_id)) == 1) { Session["cliente"] = true; Session["id"] = UserDB.selectUser4(Convert.ToString(usu_id)); Session["empresa"] = false; if (Session["CaravanID"] == null || Session["CaravanID"].Equals(false)) { Response.Redirect("../ToUser/Home_User.aspx"); } else { int CaravanID = Convert.ToInt32(Session["CaravanID"]); Response.Redirect("http://localhost:50783/Pages/ToUser/Caravana.aspx?iud=" + CaravanDB.selectInviteIdCaravan(CaravanID)); } } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "script", "<script>$('#loginModal').modal('show');</script>", false); ltl_statusM.Text = "<script type=text/javascript> toastr.error('Ocorreu algum erro, tente novamente mais tarde') </script>"; } } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "script", "<script>$('#loginModal').modal('show');</script>", false); ltl_statusM.Text = "<script type=text/javascript> toastr.error('Por Favor, confirme o e-mail para acessar a conta') </script>"; } } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "script", "<script>$('#loginModal').modal('show');</script>", false); ltl_statusM.Text = "<script type=text/javascript> toastr.error('E-mail e/ou Senha incorretos') </script>"; } }
public JsonResult GetCompanyByIdForDisplaying(int _id) { try { var company = CompanyDB.GetInstance().GetCompanyByIdForDisplaying(_id); return(Json(company)); } catch (Exception) { throw; } }
public ActionResult Create([Bind(Include = "Name,Address,Specialization")] CompanyDB company) { if (ModelState.IsValid) { company.ID = db.CompanyDB.ToList().Last().ID + 1; db.CompanyDB.Add(company); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(company)); }
public JsonResult DeleteCompany(int _id) { try { CompanyDB.GetInstance().DeleteCompany(_id); return(Json(true)); } catch (Exception) { throw; } return(Json(false)); }
public ActionResult GetCompanyList(int _kullanimDurumu, int _firmaTipi, string _firmaKodu) { try { _firmaKodu = _firmaKodu == null ? "" : _firmaKodu; var companyList = CompanyDB.GetInstance().GetCompanyList(userObj, _kullanimDurumu, _firmaTipi, _firmaKodu); return(PartialView("_CompanyList", companyList)); } catch (Exception exc) { throw exc; } }
// GET: CompanyDB/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CompanyDB company = db.CompanyDB.Find(id); if (company == null) { return(HttpNotFound()); } return(View(company)); }
protected void btnRecusar_Click(object sender, EventArgs e) { Button button = (Button)sender; string buttonId = button.ID; buttonId = Regex.Replace(buttonId, "[^0-9.]", ""); if (CompanyDB.UpdateProposta("Negado", Convert.ToInt32(buttonId)) == 0) { ltl_status.Text = ""; ltl_status.Text = "<script type=text/javascript> toastr.error('Você recusou uma proposta') </script>"; } else { } }
public IActionResult ExportFile() { var companyList = CompanyDB.GetInstance().GetAllDBCompaniesForExcel(); var stream = new MemoryStream(); using (var package = new ExcelPackage(stream)) { var sheet = package.Workbook.Worksheets.Add("Şirketler"); sheet.Cells.LoadFromCollection(companyList, true); package.Save(); } stream.Position = 0; var fileName = $"Şirketler_{DateTime.Now.ToString("yyyyMMddHHmmss")}.xlsx"; return(File(stream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName)); }
public IActionResult Index() { //CompanyList = CompanyDB.Instance.GetCompanyList(), var returnModel = new CompanyViewModel() { CompanyTypeList = CompanyTypeDB.GetInstance().GetAllCompanyTypes(), CompanyList = CompanyDB.GetInstance().GetAllCompaniesForAdminPanel(userObj), Platforms = PlatformDB.GetInstance().GetAllPlatforms(), Sectors = SectorDB.GetInstance().GetAllSectors(), /*Users = UserDB.GetInstance().GetAllUsers(),*/ Distributors = DistributorDB.GetInstance().GetAllDistributors(userObj), CompanyPartners = CompanyPartnerDB.GetInstance().GetAllCompanyPartners() }; return(View(returnModel)); }
/// <summary> /// This function adds Company's Database Details in the database on the basis of data provided by the user /// </summary> /// <param name="CompanyDBDTOobject"></param> /// <returns></returns> public Boolean AddCompanyDBInfo(CompanyDBDTO CompanyDBDTOobject) { bool flag = false; try { using (UnitOfWork uow = new UnitOfWork()) { CompanyDB companydbObj = new CompanyDB(); DatabaseInfo databaseinfoObj = new DatabaseInfo(); databaseinfoObj.ServerName = CompanyDBDTOobject.DatabaseInfo.ServerName; databaseinfoObj.Authentication = CompanyDBDTOobject.DatabaseInfo.Authentication; databaseinfoObj.UserName = CompanyDBDTOobject.DatabaseInfo.UserName; databaseinfoObj.Password = CompanyDBDTOobject.DatabaseInfo.Password; databaseinfoObj.Active = true; databaseinfoObj.RecordStatus = 1; databaseinfoObj.CreatedBy = 123; databaseinfoObj.CreatedDate = DateTime.Now.Date; databaseinfoObj.LastModifiedBy = DateTime.Now; databaseinfoObj.LastModifiedDate = DateTime.Now.Date; uow.DatabaseInfoRepo.Add(databaseinfoObj); uow.Complete(); companydbObj.FkDatabaseInfoId = uow.DatabaseInfoRepo.GetAll().Where(a => a.ServerName == CompanyDBDTOobject.DatabaseInfo.ServerName && a.Authentication == CompanyDBDTOobject.DatabaseInfo.Authentication && a.UserName == CompanyDBDTOobject.DatabaseInfo.UserName && a.Password == CompanyDBDTOobject.DatabaseInfo.Password).SingleOrDefault().DatabaseInfoId; companydbObj.FkCompanyId = CompanyDBDTOobject.FkCompanyId; companydbObj.Active = true; companydbObj.RecordStatus = 1; companydbObj.CreatedBy = 123; companydbObj.CreatedDate = DateTime.Now.Date; companydbObj.LastModifiedDate = DateTime.Now.Date; companydbObj.LastModifiedBy = DateTime.Now; uow.CompanyDBRepo.Add(companydbObj); uow.Complete(); flag = true; } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e.Message); } return(flag); }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IWebHostEnvironment env, CompanyDB db) { db.Database.EnsureCreated(); if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); app.UseSwagger(); app.UseSwaggerUI(c => c.SwaggerEndpoint("/swagger/v1/swagger.json", "WebAPIService v1")); } app.UseRouting(); app.UseAuthorization(); app.UseEndpoints(endpoints => { endpoints.MapControllers(); }); }
private void initConfig() { try { //new LogWriter("d", "BangnaQueueDB initConfig "); stfDB = new StaffDB(conn); queDateDB = new BQueueDateDB(conn); queDB = new BQueueDB(conn); tqueDB = new TQueueDB(conn); quecDB = new BQueueCallerDB(conn); tcallDB = new TCallDB(conn); compDB = new CompanyDB(conn); queDB.getlStf(); } catch (Exception ex) { new LogWriter("e", "BangnaQueueDB initConfig " + ex.Message); } }
public IActionResult Index() { var model = new DeviceViewModel() { //Devices = DeviceDB.GetInstance().GetAllDevices(userObj), TerminalProtocols = TerminalProtocolDB.GetInstance().GetAllTerminalProtocols(), Gateways = GatewayDB.GetInstance().GetAllGateways(), DeviceMontageTypes = DeviceMontageTypeDB.GetInstance().GetAllDeviceMontageTypes(), RefTelemetryTypes = RefTelemetryTypeDB.GetInstance().GetAllRefTelemetryTypes(), ServiceTypes = ServiceTypeDB.GetInstance().GetAllServiceTypes(), TerminalTypes = TerminalTypeDB.GetInstance().GetAllTerminalTypes(), UsingStatus = UsingStatusDB.GetInstance().GetAllUsingStatuses(), Vehicles = VehicleDB.GetInstance().GetAllVehicles(), WocheckerFlags = WocheckerFlagDB.GetInstance().GetAllWocheckerFlags(), Companies = CompanyDB.GetInstance().GetAllCompaniesForAdminPanel(userObj), Messagings = MessagingDB.GetInstance().GetAllMessagings(), CompanyTypes = CompanyTypeDB.GetInstance().GetAllCompanyTypes() }; return(View(model)); }
protected void btnAceitar_Click(object sender, EventArgs e) { Button button = (Button)sender; string buttonId = button.ID; buttonId = Regex.Replace(buttonId, "[^0-9.]", ""); if (CompanyDB.UpdateProposta("Aceito", Convert.ToInt32(buttonId)) == 0) { DataSet ds = UserDB.select_Interessados(Convert.ToInt32(Session["CaravanID"])); foreach (DataRow dr in ds.Tables[0].Rows) { VisitorBD.SendEmailAtualizacaoCaravana2(dr["email"].ToString(), dr["tituloCaravana"].ToString(), dr["nomeCliente"].ToString(), dr["convite"].ToString()); } ltl_status.Text = "<script type='text/javascript'> swal('Sucesso!', 'Você aceitou a proposta', 'success')"; ltl_status.Text += ".then((value) => {window.location.replace('Caravana_Criador.aspx')}); </script> "; } else { } }
protected void btnAvancar1_Click(object sender, EventArgs e) { Proposta pro = (Proposta)Session["cadastro"]; pro.Pro_status = "Aguardando"; pro.Pro_data = DateTime.UtcNow; int id = CompanyDB.MakePropostas(pro); if (id != 0) { if (CompanyDB.insertProposta_has_Motorista(pro, id) == 0) { if (CompanyDB.insertProposta_has_Veiculo(pro, id) == 0) { if (CompanyDB.insertCaravana_has_Proposta(pro, id) == 0) { ltl_status.Text = "<script type='text/javascript'> swal('Sucesso!', 'Sua proposta foi enviada', 'success')"; ltl_status.Text += ".then((value) => {window.location.replace('Propostas_Realizadas.aspx')}); </script> "; } else { // Algo deu errado } } else { // Algo deu errado } } else { // Algo deu errado } } else { // Algo deu errado } }
protected void Page_Load(object sender, EventArgs e) { DataSet ds = CompanyDB.selectEmpresa4(Convert.ToInt32(Session["id"])); foreach (DataRow dr in ds.Tables[0].Rows) { if (txt_RazaoSocial.Text.Equals(dr["emp_razaosocial"].ToString()) || !IsPostBack) { txt_RazaoSocial.Text = dr["emp_razaosocial"].ToString(); lbl_razaoSocial.Text = dr["emp_razaosocial"].ToString(); } if (txt_nomeFantasia.Text.Equals(dr["emp_nome"].ToString()) || !IsPostBack) { txt_nomeFantasia.Text = dr["emp_nome"].ToString(); lbl_nomeFantasia.Text = dr["emp_nome"].ToString(); } if (txt_email.Text.Equals(dr["usu_email"].ToString()) || !IsPostBack) { txt_email.Text = dr["usu_email"].ToString(); } } }
protected void card_Click(object sender, EventArgs e) { Button button = (Button)sender; string buttonId = button.ID; buttonId = Regex.Replace(buttonId, "[^0-9.]", ""); DataSet ds = CompanyDB.SelectThisProposta(Convert.ToInt32(buttonId)); foreach (DataRow dr in ds.Tables[0].Rows) { Session["CaravanID"] = dr["car_id"].ToString(); lblValor.Text = dr["valor"].ToString(); lbl_Placa.Text = dr["Placa"].ToString().ToUpper(); lbl_Marca.Text = dr["Marca"].ToString(); lbl_caravana.Text = dr["titulo"].ToString(); lbl_nome.Text = dr["NomeMotorista"].ToString(); var data = DateTime.Today; var nasc = Convert.ToDateTime(dr["DataNascimento"]); var idade = data.Year - nasc.Year; lbl_idade.Text = idade + " Anos"; lbl_Ano.Text = dr["ano"].ToString(); } Page.ClientScript.RegisterStartupScript(this.GetType(), "script", "<script>$('#myModal').modal('show');</script>", false); }
public CompanyBiz() : base() { m_db = new CompanyDB(); }
public Depatments(CompanyDB db) { _db = db; }