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