public ActionResult VISITA_ASSIGN_Create([DataSourceRequest] DataSourceRequest request, VISITA_ASSIGN vISITA_ASSIGN)
{
DateTime now = DateTime.Now;
now.ToString("yyyy-MM-dd HH:mm:ss"); //Outputs 2014-04-08 12:50:35
now.ToString("HH:mm:ss");
var fecha = vISITA_ASSIGN.visi_date.ToString();
if (ModelState.IsValid)
{
var entity = new VISITA_ASSIGN
{
inst_id = vISITA_ASSIGN.inst_id,
cust_id = vISITA_ASSIGN.cust_id,
visi_date = vISITA_ASSIGN.visi_date,
visi_op = vISITA_ASSIGN.visi_op,
visi_status = 0,
visi_hora = vISITA_ASSIGN.visi_hora,
visi_km = 25
};
db.VISITA_ASSIGN.Add(entity);
db.SaveChanges();
vISITA_ASSIGN.visi_id = entity.visi_id;
}
return(Json(new[] { vISITA_ASSIGN }.ToDataSourceResult(request, ModelState)));
}
// GET: GetCheckIn
public ActionResult Index()
{
int inst_id = Convert.ToInt32(Request.QueryString["inst_id"]);
int visitid = Convert.ToInt32(Request.QueryString["visit_id"]);
int custid = Convert.ToInt32(Request.QueryString["cust_id"]);
string lat = Convert.ToString(Request.QueryString["lat"]);
string lon = Convert.ToString(Request.QueryString["lon"]);
string hr = Convert.ToString(Request.QueryString["hr"]);
string fcha = Convert.ToString(Request.QueryString["fcha"]);
int emo = Convert.ToInt32(Request.QueryString["emo"]);
var succes = "";
using (AppDTEntities objDataContext = new AppDTEntities())
{
try
{
VISITA_REGISTRO vISITA = new VISITA_REGISTRO();
// fields to be insert
vISITA.inst_id = inst_id;
vISITA.reg_lat = lat;
vISITA.reg_lon = lon;
vISITA.cust_id = custid;
vISITA.reg_date = fcha;
vISITA.reg_ini = hr;
vISITA.reg_end = hr;
vISITA.visi_id = visitid;
vISITA.reg_status = 1;
vISITA.reg_emo = 0;
objDataContext.VISITA_REGISTRO.Add(vISITA);
objDataContext.SaveChanges();
var result = from r in objDataContext.VISITA_ASSIGN where r.visi_id == visitid select r;
// Get the first record from the result
VISITA_ASSIGN vISITA_ASSIGN = result.First();
// Update the product name
vISITA_ASSIGN.visi_status = 1;
objDataContext.SaveChanges();
succes = "Ok";
}
catch (Exception e)
{
succes = "NoOk";
}
}
return(Json(new { succes }, JsonRequestBehavior.AllowGet));
}
public ActionResult SetVisita(int Inst, int Cust, int Prio, string Fecha)
{
try
{
int user = Convert.ToInt32(Session["Usua_id"].ToString());
char[] delimiterChars = { ' ', '\t' };
string[] words = Fecha.Split(delimiterChars);
var fecha = words[0];
var hora = words[1];
var km = db.CUSTOMER.Where(a => a.cust_id == Cust).ToList();
var k = Convert.ToInt32(km[0].cust_km);
string ok = "";
var buscar = db.VISITA_ASSIGN.Where(a => a.inst_id == Inst && a.visi_hora == hora);
if (buscar.Count() == 0)
{
var entity = new VISITA_ASSIGN
{
inst_id = Inst,
cust_id = Cust,
visi_op = Prio,
visi_date = fecha,
visi_status = 0,
visi_hora = hora,
visi_km = k,
user_id = user
};
db.VISITA_ASSIGN.Add(entity);
db.SaveChanges();
return(Json(new { success = true, responseText = "Cita Asignada con Exito.!" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, responseText = "El instructor seleccionado ya tiene cita programada a las " + hora + "." }, JsonRequestBehavior.AllowGet));
}
// return Json(new { succes = ok });
}
catch (Exception e)
{
return(Json(new { success = false, responseText = "Error!" }, JsonRequestBehavior.AllowGet));
}
}
// GET: GetCheckOut
public ActionResult Index()
{
int inst_id = Convert.ToInt32(Request.QueryString["inst_id"]);
int visitid = Convert.ToInt32(Request.QueryString["visit_id"]);
int custid = Convert.ToInt32(Request.QueryString["cust_id"]);
string lat = Convert.ToString(Request.QueryString["lat"]);
string lon = Convert.ToString(Request.QueryString["lon"]);
string hr = Convert.ToString(Request.QueryString["hr"]);
string fcha = Convert.ToString(Request.QueryString["fcha"]);
int emo = Convert.ToInt32(Request.QueryString["emo"]);
var succes = "";
using (AppDTEntities db = new AppDTEntities())
{
try
{
var result = from r in db.VISITA_REGISTRO where r.visi_id == visitid select r;
VISITA_REGISTRO vISITA_REGISTRO = result.First();
vISITA_REGISTRO.reg_end = hr;
vISITA_REGISTRO.reg_emo = emo;
db.SaveChanges();
//status
var result2 = from r in db.VISITA_ASSIGN where r.visi_id == visitid select r;
VISITA_ASSIGN vISITA_ASSIGN = result2.First();
vISITA_ASSIGN.visi_status = 2;
db.SaveChanges();
succes = "Ok";
}
catch (Exception e)
{
succes = "NoOk";
}
}
return(Json(new { succes }, JsonRequestBehavior.AllowGet));
}
public ActionResult VISITA_ASSIGN_Update([DataSourceRequest] DataSourceRequest request, VISITA_ASSIGN vISITA_ASSIGN)
{
if (ModelState.IsValid)
{
var entity = new VISITA_ASSIGN
{
inst_id = vISITA_ASSIGN.inst_id,
cust_id = vISITA_ASSIGN.cust_id,
visi_id = vISITA_ASSIGN.visi_id,
visi_date = vISITA_ASSIGN.visi_date,
visi_op = vISITA_ASSIGN.visi_op,
visi_status = vISITA_ASSIGN.visi_status,
visi_hora = vISITA_ASSIGN.visi_hora,
visi_km = vISITA_ASSIGN.visi_km
};
db.VISITA_ASSIGN.Attach(entity);
db.Entry(entity).State = EntityState.Modified;
db.SaveChanges();
}
return(Json(new[] { vISITA_ASSIGN }.ToDataSourceResult(request, ModelState)));
}
