private IEnumerable <dynamic> GetDataStatus()
{
poseidon_dbEntities db = new poseidon_dbEntities();
var result = from a in db.Logger
join b in db.zones
on a.zone_id equals b.zone_id into zo
from f in zo.DefaultIfEmpty()
join c in db.User
on a.user_instalation equals c.user_id into zu
from g in zu.DefaultIfEmpty()
join d in db.Company
on a.company_id equals d.company_id
select new
{
a.logger_id,
a.logger_sites_name,
f.zone_name,
a.status,
a.user_instalation_start_date,
a.approval_date,
user_instalation = g.user_name,
company_id = d.company_name,
};
return(result);
}
private IEnumerable <dynamic> GetDataStatus()
{
poseidon_dbEntities db = new poseidon_dbEntities();
int company_id = Convert.ToInt32(Session["COMPANYID"].ToString());
var result = from a in db.Logger
join b in db.zones
on a.zone_id equals b.zone_id into zo
from f in zo.DefaultIfEmpty()
join c in db.User
on a.user_instalation equals c.user_id into zu
from g in zu.DefaultIfEmpty()
where a.company_id == company_id
select new
{
a.logger_id,
a.logger_sites_name,
a.logger_sms,
f.zone_name,
a.instalation_type,
a.necessary_key,
a.contact_detail,
a.status,
a.user_instalation_start_date,
a.user_instalation_end_date,
a.approval_date,
user_instalation = g.user_name
};
return(result);
}
public JsonResult GetCompany()
{
var db = new poseidon_dbEntities();
var rol_result = from a in db.Company
select new
{
a.company_id,
a.company_name
};
return(Json(rol_result.Select(o => new { o.company_id, o.company_name }), JsonRequestBehavior.AllowGet));
}
public JsonResult GetZone()
{
var db = new poseidon_dbEntities();
var rol_result = from a in db.zones
select new
{
a.zone_id,
a.zone_name
};
return(Json(rol_result.Select(o => new { o.zone_id, o.zone_name }), JsonRequestBehavior.AllowGet));
}
public ActionResult Index(User u)
{
// this action is for handle post (login)
if (ModelState.IsValid) // this is check validity
{
using (poseidon_dbEntities dc = new poseidon_dbEntities())
{
var v = dc.User.Where(a => a.user_login.Equals(u.user_login) && a.user_pass.Equals(u.user_pass)).FirstOrDefault();
if (v != null)
{
Session["USERID"] = v.user_id.ToString();
Session["USERNAME"] = v.user_name.ToString();
if (v.company_id.ToString() != null)
{
Session["COMPANYID"] = v.company_id.ToString();
}
Session["USERTYPE"] = v.user_type_id.ToString();
FormsAuthentication.SetAuthCookie(v.user_name.ToString(), true);
if (v.user_type_id == 1)
{
return(RedirectToAction("ListStatus", "Status"));
}
else if (v.user_type_id == 2)
{
return(RedirectToAction("ListUser", "Status"));
}
else if (v.user_type_id == 3)
{
return(RedirectToAction("ListLogger", "UserLogger"));
}
}
else
{
ModelState.AddModelError("", "Usuario Invalido");
}
}
}
return(View(u));
}
private IEnumerable <dynamic> GetData1()
{
poseidon_dbEntities db = new poseidon_dbEntities();
var result = from a in db.Logger
join b in db.zones
on a.zone_id equals b.zone_id into zo
from f in zo.DefaultIfEmpty()
where a.status == 1
select new
{
a.logger_id,
a.logger_sites_name,
a.logger_sms,
f.zone_name,
a.instalation_type,
a.necessary_key,
a.contact_detail,
a.status
};
return(result);
}
public ActionResult ErrorCorrection([DataSourceRequest] DataSourceRequest request, Logger us, FormCollection colletion)
{
if (ModelState.IsValid)
{
string to_name = "", to_email = "", logger_sites_name = "", zone_name = ""
, logger_sms = "", company_name = "";
using (var db = new poseidon_dbEntities())
{
string myCheckBoxValue = Request.Form["Check"].ToString();
string[] selectedList = myCheckBoxValue.Split(',');
Boolean error_value = Convert.ToBoolean(selectedList[0]);
if (error_value == true)
{
var result = from u in db.Logger where (u.logger_id == us.logger_id) select u;
if (result.Count() != 0)
{
var dblogger = result.First();
dblogger.status = 1;
db.SaveChanges();
logger_sites_name = dblogger.logger_sites_name;
zone_name = dblogger.zone_name;
logger_sms = dblogger.logger_sms.ToString();
var company_from = from u in db.Company where (u.company_id == dblogger.company_id) select u;
company_name = company_from.First().company_name;
var user_from = from u in db.Customers where (u.customer_company_id == dblogger.company_id && u.cc.HasValue == true) select u;
var detail_user_from = user_from.First();
to_name = "Jonathan"; //detail_user_from.customer_name;
to_email = "*****@*****.**"; // detail_user_from.customer_email;
}
}
}
MailMessage mail = new MailMessage();
mail.From = new MailAddress("*****@*****.**", "Instalaciones", System.Text.Encoding.UTF8);
mail.Subject = "Notificación Corrección de problema - " + company_name;//titulo
mail.SubjectEncoding = System.Text.Encoding.UTF8;
string body = "";
body = @"<p><h3>Estimado(a) " + to_name + ",</h3><p>" +
"<p></p><p>Se ha generado el siguiente email para notificar que el problema de instalación detectado se ha solucionado:" +
"<p>Ubicación:" + logger_sites_name +
"<p>Localidad:" + logger_sites_name +
"<p>Región:" + zone_name +
"<p>SMS:" + logger_sms;
AlternateView htmlView = AlternateView.CreateAlternateViewFromString(body, new ContentType("text/html"));
mail.AlternateViews.Add(htmlView);
mail.To.Add(to_email);
mail.CC.Add("*****@*****.**");
mail.Priority = MailPriority.High;
SmtpClient smtp = new SmtpClient();
smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "dnkinstalaciones2015");
smtp.Port = 587;//puerto
smtp.Host = "smtp.gmail.com";
smtp.EnableSsl = true;
smtp.Send(mail);
}
return(RedirectToAction("ListLogger", "UserLogger"));
}
//ERROR CORRECTION
public ActionResult ErrorCorrection(int logger_id)
{
poseidon_dbEntities db = new poseidon_dbEntities();
return(View("ErrorCorrection", db.Logger.Find(logger_id)));
}
