static public async Task <string> Save(ECompany eCompany) { if (eCompany.eCompanyConfig != null) { eCompany.config = JsonConvert.SerializeObject(eCompany.eCompanyConfig, Formatting.Indented); } using var context = new SMySQLContext(); eCompany.modificationDateUTC = DateTime.UtcNow; if (string.IsNullOrEmpty(eCompany.id)) { eCompany.id = Guid.NewGuid().ToString(); eCompany.creationDateUTC = DateTime.UtcNow; var e = await context.Companies.AddAsync(eCompany); await context.SaveChangesAsync(); return(e.Entity.id); } else { var e = context.Companies.Update(eCompany); await context.SaveChangesAsync(); return(e.Entity.id); } }
public void Update(ECompany eCompany) { eCompany.Validar(); dCompany.Update(eCompany); eCompany.Audit.TypeEvent = "Update"; bAudit.Insert(eCompany.Audit); }
static public ECompany GetByLabSite(string labSite) { using var context = new SMySQLContext(); ECompany eCompany = context.Companies.SingleOrDefault(x => labSite.ToLower().Contains(x.labSite)); return(eCompany); }
public void Delete(ECompany company) { DaCommand command = new DaCommand("dbo.CompanyDelete"); command.AddInParameter("@CodeCompany", DbType.String, company.CodeCompany); ExecuteNonQuery(command); }
private GenericBankFileDetail CreateBankFileDetail(int EmpID) { GenericBankFileDetail bankFileDetail = new GenericBankFileDetail(); EEmpPersonalInfo empInfo = new EEmpPersonalInfo(); empInfo.EmpID = EmpID; if (EEmpPersonalInfo.db.select(dbConn, empInfo)) { bankFileDetail.EmpID = empInfo.EmpID; bankFileDetail.EmpNo = empInfo.EmpNo; bankFileDetail.EmpName = empInfo.EmpEngFullName; } DBFilter empPosFilter = new DBFilter(); empPosFilter.add(new Match("EmpID", EmpID)); empPosFilter.add("EmpPosEffFr", false); ArrayList empPosList = EEmpPositionInfo.db.select(dbConn, empPosFilter); if (empPosList.Count > 0) { EEmpPositionInfo empPos = (EEmpPositionInfo)empPosList[0]; ECompany company = new ECompany(); company.CompanyID = empPos.CompanyID; ECompany.db.select(dbConn, company); bankFileDetail.CompanyID = company.CompanyID; bankFileDetail.CompanyName = company.CompanyName; } return(bankFileDetail); }
private void lblpdf_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(txtCodigo.Text) && lblOperacion.Text == "Consulta" && Encontro == true) { BLL.CompanyBLL bllComp = new BLL.CompanyBLL(); ECompany objC = bllComp.buscar(); DataTable dt = new DataTable(); dt = bllAct.informeBasico(txtCodigo.Text); Informes.FrmVerInforme frm = new Informes.FrmVerInforme(); ReportDocument reporte = new ReportDocument(); string ruta = AppDomain.CurrentDomain.BaseDirectory + "Reportes\\rptinfActBasico.rpt"; reporte.Load(ruta); reporte.SetDataSource(dt); // Asignacion de Parametros reporte.SetParameterValue("comp", objC.descripcion); reporte.SetParameterValue("nit", objC.nit); reporte.SetParameterValue("periodo", "Periodo Actual: " + BLL.Inicializar.periodo); frm.CReporte.ReportSource = reporte; frm.CReporte.Refresh(); frm.ShowDialog(); } else { MessageBox.Show("Seleccione un Activo (Valido O Registrado en el Sistem)", "SAE Control", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
static public ECompany GetByID(string id) { using (var context = new SMySQLContext()) { ECompany eCompany = context.Companies.SingleOrDefault(x => x.id == id); return(eCompany); } }
/// <summary> /// Retorna una lista de todas las Compañias /// </summary> /// <returns></returns> public List <ECompany> getAll() { ECompany objComp = null; List <ECompany> lista = new List <ECompany>(); string sql = "SELECT * FROM companias ORDER BY codigo"; using (conexion cnx = new conexion()) { cnx.cadena = ConfigSAE.Instanciar.cadenaSAE(); using (MySqlCommand cmd = new MySqlCommand()) { cmd.CommandText = sql; cmd.Connection = cnx.getConexion(); if (cnx.abrirConexion()) { MySqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { objComp = mapearObjeto(dr); lista.Add(objComp); } cnx.cerrarConexion(); } } return(lista); } }
private void generarUno() { ECompany objC = bllComp.buscar(); DataTable dt = new DataTable(); if (rbTodosPer.Checked == true) { dt = bllDep.tablaDepreciacion(txtCodActivo.Text, "Todos", "Todos"); } else { dt = bllDep.tablaDepreciacion(txtCodActivo.Text, cboInicial.Text, cboFinal.Text); } Informes.FrmVerInforme frm = new Informes.FrmVerInforme(); ReportDocument reporte = new ReportDocument(); string ruta = AppDomain.CurrentDomain.BaseDirectory + "Reportes\\RptInfDepreTabla.rpt"; reporte.Load(ruta); reporte.SetDataSource(dt); // Asignacion de Parametros reporte.SetParameterValue("comp", objC.descripcion); reporte.SetParameterValue("nit", objC.nit); reporte.SetParameterValue("periodo", "Periodo Actual: " + BLL.Inicializar.periodo); frm.CReporte.ReportSource = reporte; frm.CReporte.Refresh(); frm.ShowDialog(); }
protected void companyRepeater_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DataRowView row = (DataRowView)e.Item.DataItem; CheckBox cb = (CheckBox)e.Item.FindControl("ItemSelect"); WebFormUtils.LoadKeys(ECompany.db, row, cb); ECompany company = new ECompany(); ECompany.db.toObject(row.Row, company); cb.Text = string.Format("{0} - {1}", new string[] { company.CompanyCode, company.CompanyName }); DBFilter companyBankAccountMapFilter = new DBFilter(); companyBankAccountMapFilter.add(new Match("CompanyID", company.CompanyID)); companyBankAccountMapFilter.add(new Match("CompanyBankAccountID", CurID)); if (ECompanyBankAccountMap.db.count(dbConn, companyBankAccountMapFilter) > 0) { cb.Checked = true; } else { cb.Checked = false; } } }
/// <summary> /// Buscar Compañia /// </summary> /// <param name="login">Nombre o Sigla de la Compañia</param> /// <param name="clave">Clave de la Compañia</param> /// <returns></returns> public ECompany buscar(string login, string clave) { ECompany objComp = null; string sql = "SELECT * FROM companias WHERE login='******' AND clave='" + clave + "'"; using (conexion cnx = new conexion()) { cnx.cadena = ConfigSAE.Instanciar.cadenaSAE(); using (MySqlCommand cmd = new MySqlCommand()) { cmd.CommandText = sql; cmd.Connection = cnx.getConexion(); if (cnx.abrirConexion()) { MySqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows == true) { dr.Read(); objComp = mapearObjeto(dr); } cnx.cerrarConexion(); } } return(objComp); } }
public List <ECompany> listarcompany() { List <ECompany> lista = new List <ECompany>(); DCompany ocompany = new DCompany(); DataTable dt = ocompany.listarcompany(); for (int i = 0; i < dt.Rows.Count; i++) { ECompany ecompany = new ECompany(); ecompany.Companyid = Convert.ToInt32(dt.Rows[i]["Company_id"]); ecompany.idtypeDocument = dt.Rows[i]["id_typeDocument"].ToString(); ecompany.Type_Company = dt.Rows[i]["Type_Company"].ToString(); ecompany.Companynd = dt.Rows[i]["Company_nd"].ToString(); ecompany.CompanyName = dt.Rows[i]["Company_Name"].ToString(); ecompany.CompanyEmail = dt.Rows[i]["Company_Email"].ToString(); ecompany.CompanyPhone = dt.Rows[i]["Company_Phone"].ToString(); ecompany.CompanyAddres = dt.Rows[i]["Company_Addres"].ToString(); ecompany.Company_Foto = dt.Rows[i]["Company_Foto"].ToString(); ecompany.codCountry = dt.Rows[i]["cod_Country"].ToString(); ecompany.CompanyStatus = Convert.ToBoolean(dt.Rows[i]["Company_Status"]); ecompany.CompanyCreateBy = dt.Rows[i]["Company_CreateBy"].ToString(); ecompany.CompanyDateBy = dt.Rows[i]["Company_DateBy"].ToString(); ecompany.CompanyModiBy = dt.Rows[i]["Company_ModiBy"].ToString(); ecompany.CompanyDateModiBy = dt.Rows[i]["Company_DateModiBy"].ToString(); lista.Add(ecompany); } return(lista); }
/// <summary> ///Nombre Metodo: Register_Company ///Función: Permite el registro de Clientes Lucky /// </summary> /// se agreta parametro sCompany_Foto 21 de enero del 2011 Magaly Jiménez public ECompany Register_Company(string iidtypeDocument, string sTypeCompany, string sCompanynd, string sCompanyName, string sCompanyEmail, string sCompanyPhone, string sCompanyAddres, string sCompany_Foto, string scodCountry, bool bCompanyStatus, string sCompanyCreateBy, string sCompanyDate, string sCompanyModiBy, string sCompanyDateModiBy) { DataTable dt = oConn.ejecutarDataTable("UP_WEB_REGISTER_COMPANY", iidtypeDocument, sTypeCompany, sCompanynd, sCompanyName, sCompanyEmail, sCompanyPhone, sCompanyAddres, sCompany_Foto, scodCountry, bCompanyStatus, sCompanyCreateBy, sCompanyDate, sCompanyModiBy, sCompanyDateModiBy); ECompany ocrcompany = new ECompany(); ocrcompany.idtypeDocument = iidtypeDocument; ocrcompany.Companynd = sCompanynd; ocrcompany.Type_Company = sTypeCompany; ocrcompany.CompanyName = sCompanyName; ocrcompany.CompanyEmail = sCompanyEmail; ocrcompany.CompanyPhone = sCompanyPhone; ocrcompany.CompanyAddres = sCompanyAddres; ocrcompany.Company_Foto = sCompany_Foto; ocrcompany.codCountry = scodCountry; ocrcompany.CompanyStatus = bCompanyStatus; ocrcompany.CompanyCreateBy = sCompanyCreateBy; ocrcompany.CompanyDateBy = sCompanyDate; ocrcompany.CompanyModiBy = sCompanyModiBy; ocrcompany.CompanyDateModiBy = sCompanyDateModiBy; ocrcompany.Companyid = Convert.ToInt32(dt.Rows[0]["Company_id"].ToString()); return(ocrcompany); }
public Company Create(Company company) { ECompany eCompany = ECompany(company); eCompany = _iDCompany.Create(eCompany); return(Company(eCompany)); }
public DataRow Select(ECompany company) { DaCommand command = new DaCommand("dbo.CompanySelect"); command.AddInParameter("@CodeCompany", DbType.String, company.CodeCompany); return(ExecuteDataRow(command)); }
protected void CompanyRepeater_ItemDataBound(object sender, RepeaterItemEventArgs e) { ECompany company = (ECompany)e.Item.DataItem; Binding binding = new Binding(dbConn, ECompany.db); CheckBox chcekBox = (CheckBox)e.Item.FindControl("ItemSelect"); chcekBox.Text = company.CompanyCode + " - " + company.CompanyName; HtmlInputHidden hiddenInput = (HtmlInputHidden)e.Item.FindControl("CompanyID"); hiddenInput.Value = company.CompanyID.ToString(); binding.add(hiddenInput); binding.init(Request, Session); DBFilter filter = new DBFilter(); filter.add("HLevelSeqNo", true); ArrayList list = EHierarchyLevel.db.select(dbConn, filter); Repeater HierarchyLevel = (Repeater)e.Item.FindControl("HierarchyLevel"); HierarchyLevel.DataSource = list; HierarchyLevel.DataBind(); }
public ResponsibleAttribute(string firstName, string lastName, ECompany company, EOperationalTeam operationalTeam) { FirstName = firstName; LastName = lastName; Company = company; OperationalTeam = operationalTeam; }
public ActionResult DeleteConfirmed(string id) { ECompany company = db.companies.Find(id); db.companies.Remove(company); db.SaveChanges(); return(RedirectToAction("Index")); }
// End 0000185, KuangWei, 2015-05-05 private DataSet.HeadCountSummarySet.HeadCountSummaryRow CreateHeadCountRow(int EmpPosID) { DataSet.HeadCountSummarySet.HeadCountSummaryRow row = dataSet.HeadCountSummary.NewHeadCountSummaryRow(); EEmpPositionInfo empPos = new EEmpPositionInfo(); empPos.EmpPosID = EmpPosID; if (EEmpPositionInfo.db.select(dbConn, empPos)) { row.EmpID = empPos.EmpID; EEmpPersonalInfo empInfo = new EEmpPersonalInfo(); empInfo.EmpID = empPos.EmpID; if (EEmpPersonalInfo.db.select(dbConn, empInfo)) { row.EmpGender = empInfo.EmpGender; row.EmpAreaCode = empInfo.EmpResAddrAreaCode; ECompany company = new ECompany(); company.CompanyID = empPos.CompanyID; if (ECompany.db.select(dbConn, company)) { row.CompanyID = company.CompanyID; row.CompanyCode = company.CompanyCode; row.CompanyName = company.CompanyName; } EPayrollGroup payGroup = new EPayrollGroup(); payGroup.PayGroupID = empPos.PayGroupID; if (EPayrollGroup.db.select(dbConn, payGroup)) { row.PayGroupID = payGroup.PayGroupID; row.PayGroupCode = payGroup.PayGroupCode; row.PayGroupDesc = payGroup.PayGroupDesc; } EHierarchyElement hElement = getHierarchyElement(EmpPosID); if (hElement != null) { row.HElementID = hElement.HElementID; row.HElementCode = hElement.HElementCode; row.HElementDesc = hElement.HElementDesc; } else { row.HElementID = 0; row.HElementCode = " "; row.HElementDesc = " "; } } } row.PreviousCount = 0; row.CurrentCount = 0; row.NewJoinCount = 0; row.TerminateCount = 0; row.TransferInCount = 0; row.TransferOutCount = 0; return(row); }
protected void Delete_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); ArrayList list = new ArrayList(); foreach (RepeaterItem i in Repeater.Items) { CheckBox cb = (CheckBox)i.FindControl("ItemSelect"); if (cb.Checked) { ECompany o = new ECompany(); WebFormUtils.GetKeys(db, o, cb); list.Add(o); } } foreach (ECompany o in list) { if (ECompany.db.select(dbConn, o)) { DBFilter empPosFilter = new DBFilter(); empPosFilter.add(new Match("CompanyID", o.CompanyID)); empPosFilter.add("empid", true); ArrayList empPosList = EEmpPositionInfo.db.select(dbConn, empPosFilter); if (empPosList.Count > 0) { errors.addError(string.Format(HROne.Translation.PageErrorMessage.ERROR_CODE_USED_BY_EMPLOYEE, new string[] { HROne.Common.WebUtility.GetLocalizedString("Company Code"), o.CompanyCode })); foreach (EEmpPositionInfo empPos in empPosList) { EEmpPersonalInfo empInfo = new EEmpPersonalInfo(); empInfo.EmpID = empPos.EmpID; if (EEmpPersonalInfo.db.select(dbConn, empInfo)) { errors.addError("- " + empInfo.EmpNo + ", " + empInfo.EmpEngFullName); } else { EEmpPositionInfo.db.delete(dbConn, empPos); } } errors.addError(HROne.Translation.PageErrorMessage.ERROR_ACTION_ABORT); } else { WebUtils.StartFunction(Session, FUNCTION_CODE); db.delete(dbConn, o); EUserCompany.DeleteCompanyForAllUsers(dbConn, o.CompanyID); DBFilter companyBankAccountMapFilter = new DBFilter(); companyBankAccountMapFilter.add(new Match("CompanyID", o.CompanyID)); ECompanyBankAccountMap.db.delete(dbConn, companyBankAccountMapFilter); WebUtils.EndFunction(dbConn); } } } loadData(info, db, Repeater); }
protected DataTable loadExtraData(DataTable sourceTable) { DataTable destTable = sourceTable.Copy(); destTable.Columns.Add("CompanyCode", typeof(string)); destTable.Columns.Add("BusinessHierarchy", typeof(string)); destTable.Columns.Add("PositionCode", typeof(string)); destTable.Columns.Add("RankCode", typeof(string)); destTable.Columns.Add("StaffTypeCode", typeof(string)); destTable.Columns.Add("LeavePlanCode", typeof(string)); destTable.Columns.Add("PayGroupCode", typeof(string)); foreach (DataRow row in destTable.Rows) { EEmpPositionInfo empPos = EEmpPositionInfo.GetObject(dbConn, row["EmpPosID"]); if (empPos != null) { ECompany company = ECompany.GetObject(dbConn, row["CompanyID"]); if (company != null) { row["CompanyCode"] = company.CompanyCode; } row["BusinessHierarchy"] = empPos.GetBusinessHierarchyString(dbConn); EPosition position = EPosition.GetObject(dbConn, row["PositionID"]); if (position != null) { row["PositionCode"] = position.PositionCode; } ERank rank = ERank.GetObject(dbConn, row["RankID"]); if (rank != null) { row["RankCode"] = rank.RankCode; } EStaffType staffType = EStaffType.GetObject(dbConn, row["StaffTypeID"]); if (staffType != null) { row["StaffTypeCode"] = staffType.StaffTypeCode; } ELeavePlan leavePlan = ELeavePlan.GetObject(dbConn, row["LeavePlanID"]); if (leavePlan != null) { row["LeavePlanCode"] = leavePlan.LeavePlanCode; } EPayrollGroup payGroup = EPayrollGroup.GetObject(dbConn, (int)row["PayGroupID"]); if (payGroup != null) { row["PayGroupCode"] = payGroup.PayGroupCode; } } } return(destTable); }
public Company Create(int createdBy, Company company) { ECompany eCompany = ECompany(company); eCompany.CreatedDate = DateTime.Now; eCompany.CreatedBy = createdBy; eCompany = _iDCompany.Create(eCompany); return(Company(eCompany)); }
public Company Update(int updatedBy, Company company) { ECompany eCompany = ECompany(company); eCompany.UpdatedDate = DateTime.Now; eCompany.UpdatedBy = updatedBy; eCompany = _iDCompany.Update(eCompany); return(Company(eCompany)); }
public void Delete() { bool result = false; BUserCompany bUserCompany = new BUserCompany(); EUserCompany eUserCompany = new EUserCompany(); EUserCompany insertedUserCompany = new EUserCompany(); EUserCompany deletedUserCompany = new EUserCompany(); BCorporation bCorporation = new BCorporation(); ECorporation eCorporation = new ECorporation(); BCompany bCompany = new BCompany(); ECompany eCompany = new ECompany(); BUser bUser = new BUser(); EUser eUser = new EUser(); TransactionScope ts = new TransactionScope(TransactionScopeOption.RequiresNew); eCorporation.CodeCorporation = Aleatory.GetString(2); eCorporation.Name = Aleatory.GetString(15); eCorporation.State = Aleatory.GetShort(); eCorporation.Audit.UserRegister = Aleatory.GetString(8); bCorporation.Insert(eCorporation); eCompany.CodeCompany = Aleatory.GetString(2); eCompany.CodeCorporation = eCorporation.CodeCorporation; eCompany.Ruc = Aleatory.GetString(11); eCompany.LongName = Aleatory.GetString(15); eCompany.State = Aleatory.GetShort(); eCompany.Audit.UserRegister = Aleatory.GetString(8); bCompany.Insert(eCompany); eUser.CodeUser = Aleatory.GetString(8); eUser.Name = Aleatory.GetString(8); eUser.Password = Aleatory.GetString(8); eUser.State = Aleatory.GetShort(); eUser.Audit.UserRegister = Aleatory.GetString(8); bUser.Insert(eUser); eUserCompany.CodeUser = eUser.CodeUser; eUserCompany.CodeCompany = eCompany.CodeCompany; bUserCompany.Insert(eUserCompany); insertedUserCompany = bUserCompany.Select(eUserCompany); if (insertedUserCompany != null) { bUserCompany.Delete(eUserCompany); } deletedUserCompany = bUserCompany.Select(eUserCompany); if (deletedUserCompany == null) { result = true; } Assert.IsTrue(result); }
public ActionResult Edit([Bind(Include = "CompanyName,Address,Country,TIN,Recipients,ContactPerson,TelephoneNumber,FORDO,Tax,CompanyCode,Email,Wtpercent")] ECompany company) { if (ModelState.IsValid) { db.Entry(company).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(RedirectToAction("Index")); }
private void lblGenerar_Click(object sender, EventArgs e) { ECompany objC = bllComp.buscar(); DataTable dt = new DataTable(); string grupo = ""; string subgrupo = ""; string fInicio = ""; string fFinal = ""; if (rbtodosGrupo.Checked == true) { grupo = "Todos"; } else { grupo = cboGrupo.SelectedValue.ToString(); } if (rbtodosSubg.Checked == true) { subgrupo = "Todos"; } else { subgrupo = cboSubgrupo.SelectedValue.ToString(); } if (rbFecha.Checked == true) { fFinal = "Todos"; fInicio = "Todos"; } else { fInicio = UtilSystem.fFecha(dtpInicio.Value); fFinal = UtilSystem.fFecha(dtpFinal.Value); } dt = bllAct.informeGrupo(grupo, subgrupo, fInicio, fFinal); Informes.FrmVerInforme frm = new Informes.FrmVerInforme(); ReportDocument reporte = new ReportDocument(); string ruta = AppDomain.CurrentDomain.BaseDirectory + "Reportes\\RptInfGrupos.rpt"; reporte.Load(ruta); reporte.SetDataSource(dt); // Asignacion de Parametros reporte.SetParameterValue("comp", objC.descripcion); reporte.SetParameterValue("nit", objC.nit); reporte.SetParameterValue("periodo", "Periodo Actual: " + BLL.Inicializar.periodo); frm.CReporte.ReportSource = reporte; frm.CReporte.Refresh(); frm.ShowDialog(); }
/// <summary> ///Nombre Metodo: Register_Company ///Función: Permite el registro de Clientes Lucky /// </summary> /// se adiciona campo sCompany_Foto 21 de enero de 2010 Magaly jimenez public ECompany Register_Company(string iidtypeDocument, string sTypeCompany, string sCompanynd, string sCompanyName, string sCompanyEmail, string sCompanyPhone, string sCompanyAddres, string sCompany_Foto, string scodCountry, bool bCompanyStatus, string sCompanyCreateBy, string sCompanyDate, string sCompanyModiBy, string sCompanyDateModiBy) { Lucky.Data.Common.Application.DCompany odCompany = new Lucky.Data.Common.Application.DCompany(); ECompany oeCompany = odCompany.Register_Company(iidtypeDocument, sTypeCompany, sCompanynd, sCompanyName, sCompanyEmail, sCompanyPhone, sCompanyAddres, sCompany_Foto, scodCountry, bCompanyStatus, sCompanyCreateBy, sCompanyDate, sCompanyModiBy, sCompanyDateModiBy); odCompany = null; return(oeCompany); }
public ActionResult Create([Bind(Include = "CompanyName,Address,Country,TIN,Recipients,ContactPerson,TelephoneNumber,FORDO,Tax,CompanyCode,Wtpercent")] ECompany company) { if (ModelState.IsValid) { db.companies.Add(company); db.SaveChanges(); return(RedirectToAction("Index")); } return(RedirectToAction("Index")); }
protected void Page_Load(object sender, EventArgs e) { if (!WebUtils.CheckAccess(Response, Session, FUNCTION_CODE, WebUtils.AccessLevel.ReadWrite)) { return; } toolBar.FunctionCode = FUNCTION_CODE; binding = new Binding(dbConn, db); binding.add(HElementID); binding.add(CompanyID); binding.add(HLevelID); binding.add(HElementCode); binding.add(HElementDesc); binding.init(Request, Session); if (!int.TryParse(DecryptedRequest["HElementID"], out CurID)) { CurID = -1; } HROne.Common.WebUtility.WebControlsLocalization(this, this.Controls); if (!Page.IsPostBack) { if (CurID > 0) { loadObject(); } else { HLevelID.Value = DecryptedRequest["HLevelID"]; CompanyID.Value = DecryptedRequest["CompanyID"]; toolBar.DeleteButton_Visible = false; } } int intHLevelID, intCompanyID; HLevel = new EHierarchyLevel(); if (int.TryParse(HLevelID.Value, out intHLevelID)) { HLevel.HLevelID = intHLevelID; EHierarchyLevel.db.select(dbConn, HLevel); } Company = new ECompany(); if (int.TryParse(CompanyID.Value, out intCompanyID)) { Company.CompanyID = intCompanyID; ECompany.db.select(dbConn, Company); } }
public IActionResult GetByID(string id) { using var context = new SMySQLContext(); ECompany e = context.Companies.FirstOrDefault <ECompany>(x => x.id == id); if (!string.IsNullOrEmpty(e.config)) { e.eCompanyConfig = JsonConvert.DeserializeObject <ECompanyConfig>(e.config); } return(Ok(e)); }