public bool Modify(EmployerData dataEmployer)
{
int iRel = -1;
bool bRel = false;
CommonDB objDB = new CommonDB();
try
{
objDB.OpenConnection();
string strSql = "update agreement set EmployerName=@EmployerName,EmployerSite=@EmployerSite where EmployerId = @EmployerId";
objDB.Command.CommandType = System.Data.CommandType.Text;
objDB.Command.CommandText = strSql;
objDB.Command.Parameters.AddWithValue("@EmployerName", dataEmployer.EmployerName);
objDB.Command.Parameters.AddWithValue("@EmployerSite", dataEmployer.EmployerSite);
objDB.Command.Parameters.AddWithValue("@EmployerId", dataEmployer.EmployerId);
iRel = objDB.Command.ExecuteNonQuery();
}
catch (Exception ex)
{
//iRel = -1;
throw new Exception(ex.ToString());
}
objDB.CloseConnection();
objDB.Dispose();
objDB = null;
bRel = (iRel.Equals(1) ? true : false); return(bRel);
}
public IHttpActionResult Update(EmployerModel employer)
{
u = credenciales.getUsuario();
c = credenciales.getUsuario();
var consulta = EmployerData.Actualizar(employer.EmployerId, employer.Nombre, employer.Apellidop, employer.Apellidom, employer.Rfc, employer.RolesId, employer.InstitucionId, u);
return(Ok(consulta));
}
public IHttpActionResult Show()
{
u = credenciales.getUsuario();
c = credenciales.getUsuario();
var consulta = EmployerData.Mostrar(u);
return(Ok(consulta));
}
public IHttpActionResult Create([FromBody] EmployerModel employer)
{
u = credenciales.getUsuario();
c = credenciales.getUsuario();
var consulta = EmployerData.Crear(employer.Nombre, employer.Apellidop, employer.Apellidom, employer.Rfc, employer.RolesId, employer.InstitucionId, u);
return(Ok(consulta));
}
public ActionResult AddEmployment(EmployerData employment)
{
employment.UserId = User != null?User.Identity.GetUserId() : "";
_employerSaveService.SaveEmployer(employment);
if (Request != null && Request.IsAjaxRequest())
{
return(PartialView("AddEmployment", _employerQueryService.GetEmployers()));
}
return(RedirectToAction("Index", "Profile"));
}
internal static void Load(MatchingDbContext context)
{
context.AddRange(EmailTemplateData.Create().ToList());
context.AddRange(EmployerData.Create().ToList());
context.AddRange(RouteAndPathData.Create().ToList());
context.AddRange(ProviderVenueData.Create());
context.AddRange(OpportunityData.Create());
context.AddRange(ServiceStatusHistoryData.Create().ToList());
context.AddRange(LearningAimReferenceData.Create().ToList());
context.AddRange(OpportunityData.CreateReferralSingle());
context.AddRange(OpportunityData.CreateProvisionGapSingle());
context.AddRange(OpportunityData.CreateReferralMultiple());
context.AddRange(OpportunityData.CreateReferralMultipleAndProvisionGap());
context.AddRange(OpportunityData.CreateReferralSingleAndProvisionGap());
context.AddRange(OpportunityData.CreateProvidersMultiple());
context.AddRange(OpportunityData.CreateNReferrals(1000));
context.SaveChanges();
}
public EmployerData[] Select(string EmployerId)
{
//int iRel = -1;
CommonDB objDB = new CommonDB();
EmployerData[] dataEmployer = new EmployerData[1];
string sql = "select * from Employer where EmployerId= " + EmployerId + " ";
try
{
objDB.OpenConnection();
DataSet ds = objDB.QueryData(sql, "departmentinfo");
if (ds.Tables.Count > 0)
{
long nRow = ds.Tables[0].Rows.Count;
if (nRow > 0)
{
dataEmployer = new EmployerData[nRow];
for (int i = 0; i < nRow; i++)
{
dataEmployer[i] = new EmployerData();
dataEmployer[i].EmployerName = ds.Tables[0].Rows[i]["EmployerName"].ToString();
dataEmployer[i].EmployerSite = ds.Tables[0].Rows[i]["EmployerSite"].ToString();
}
}
}
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
//iRel = -1;
}
objDB.CloseConnection();
objDB.Dispose();
objDB = null;
return(dataEmployer);
}
public IHttpActionResult Delete(EmployerModel employer)
{
var consulta = EmployerData.Eliminar(employer.EmployerId);
return(Ok(consulta));
}
public IHttpActionResult ShowActualizar(EmployerModel employer)
{
var consulta = EmployerData.MostrarActualizar(employer.EmployerId);
return(Ok(consulta));
}
public IHttpActionResult ShowRol()
{
var consulta = EmployerData.ObtenerRol();
return(Ok(consulta));
}
public void SaveEmployer(EmployerData employer)
{
_dataAccess.Employers.Insert(_mapper.Map <DataLayer.Entities.Profile.Employer>(employer));
}
