/// <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;
}
