public ActionResult Ver(string id)
{
ConsultationBL oBL = new ConsultationBL();
int pIntID = 0;
int.TryParse(id, out pIntID);
ConsultationViewModel pConsultationViewModel = oBL.Obtener(pIntID);
NotificationBL oNotificationBL = new NotificationBL();
oNotificationBL.ActualizarNotificacionLeido("/Consultation/Ver/" + id, AuthorizeUserAttribute.UsuarioLogeado().user_id);
SelectorBL oSelectorBL = new SelectorBL();
pConsultationViewModel.interest_areasMultiSelectList = new MultiSelectList(oSelectorBL.InterestAreasSelector(), "Value", "Text");
List <SelectOptionItem> oConsultationTypes = oSelectorBL.ConsultationTypesSelector();
List <SelectListItem> consultation_types = Helper.ConstruirDropDownList <SelectOptionItem>(oConsultationTypes, "Value", "Text", "", false, "", "");
ViewBag.consultation_types = consultation_types;
return(View(pConsultationViewModel));
}
public ActionResult Create(BillViewModel model)
{
if (ModelState.IsValid)
{
var Db = new ApricotContext();
FillBillsViewModel fbvm = new FillBillsViewModel(Db);
fbvm.CreateNewBill(User.Identity.Name, model);
//Get BillID
BillDetailRepository billdetailrepo = new BillDetailRepository(Db);
var billdetail = billdetailrepo.GetAll().Where(bd => (bd.Bill_Date == model.BillDate &&
bd.Bill_Type == model.BillType &&
bd.Bill_ModeOfPayment == model.ModeOfPayment));
model.BillID = billdetail.Select(bd => bd.Bill_ID).Single();
//Create Notification for New Bill
NotificationBL notibl = new NotificationBL(Db);
notibl.NotifyManager(model.BillID);
return(RedirectToAction("Index"));
}
//Something Went wrong, redisplay form
return(View(model));
}
private void NotificacionCalificadoConcepto(ConceptViewModel pConceptViewModel)
{
var base_url = ConfigurationManager.AppSettings["site.url"];
UserBL userBL = new UserBL();
UserViewModel investigador = userBL.ObtenerUser(pConceptViewModel.user_id_created.Value);
SendEmailNotificationBL oSendEmailNotificationBL = new SendEmailNotificationBL();
NotificationConceptViewModel oNotificationConceptViewModel = new NotificationConceptViewModel();
oNotificationConceptViewModel.name = investigador.contact_name;
oNotificationConceptViewModel.url_view_concept = base_url + @"/Concept";
oNotificationConceptViewModel.to = investigador.user_email;
oNotificationConceptViewModel.url_politicas = ConfigurationManager.AppSettings["site.url.politicas"];
oNotificationConceptViewModel.url_contacto = ConfigurationManager.AppSettings["site.url.contacto"];
oNotificationConceptViewModel.url_privacidad = ConfigurationManager.AppSettings["site.url.privacidad"];
oNotificationConceptViewModel.draft_law_title = pConceptViewModel.title;
oSendEmailNotificationBL.EnviarNotificacionConcepto(oNotificationConceptViewModel, "notificacion.concept.calificado");
NotificationBL oNotificationBL = new NotificationBL();
NotificationViewModel pNotificationViewModel = new NotificationViewModel();
pNotificationViewModel.user_id = investigador.id;
pNotificationViewModel.message = "El concepto con número '" + pConceptViewModel.concept_id + "' ha sido calificado.";
pNotificationViewModel.url = @"/Concept";
oNotificationBL.Agregar(pNotificationViewModel);
}
public CallContext NotificationSave(Notification entity, CallContext resultContext)
{
resultContext.securitySettings = ETEMEnums.SecuritySettings.NotificationSave;
CallContext resContext = new NotificationBL().EntitySave<Notification>(entity, resultContext);
return resContext;
}
public void SaveNotification(string loginid = "0", string notificationmsg = "0", string userid = "0", string pprid = "0", string notificationtype = "0", string actionurl = "#", string sentbyurl = "#", string docid = "0")
{
NotificationBL obj = new NotificationBL();
obj.saveNotificationBL(loginid, notificationmsg, userid, pprid, notificationtype, actionurl, sentbyurl, docid);
//"~/Authenticate/LinMin/Default.aspx"
}
public List <NotificationBO> GetTradeNotifications()
{
List <NotificationBO> lstNotificationBO = new List <NotificationBO>();
UserLoginBO objUserLoginBO = new UserLoginBO();
TradeBO objBO = new TradeBO();
objUserLoginBO = HttpContext.Current.Session["UserDetails"] as UserLoginBO;
if (objUserLoginBO == null)
{
objBO.UserId = new Guid();
lstNotificationBO = null;
return(lstNotificationBO);
}
else
{
objBO.UserId = (Guid)objUserLoginBO.UserId;
try
{
// Guid userId = new Guid(Convert.ToString(HttpContext.Current.Session["UserId"]));
lstNotificationBO = new NotificationBL().GetTradeNotifications(objBO.UserId);
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
return(lstNotificationBO);
}
}
public CallContext NotificationSave(Notification entity, CallContext resultContext)
{
resultContext.securitySettings = ETEMEnums.SecuritySettings.NotificationSave;
CallContext resContext = new NotificationBL().EntitySave <Notification>(entity, resultContext);
return(resContext);
}
public ActionResult ConfirmDecision(String decision, String Department, Int64 id)
{
ApricotContext Db = new ApricotContext();
BillRepository billrepo = new BillRepository(Db);
Bill bill = billrepo.GetByBillID(id);
if (decision == "yes")
{
bill.Bill_Status = Data.Models.ApricotEnums.BillSatusEnum.APPROVED;
billrepo.UpdateBill(bill);
FinanceManagerBL fmbl = new FinanceManagerBL(Db);
fmbl.AlloteFinanceManager(id, Department);
NotificationBL notibl = new NotificationBL(Db);
notibl.NotificationOfApproval(id);
}
else if (decision == "no")
{
bill.Bill_Status = Data.Models.ApricotEnums.BillSatusEnum.REJECTED;
billrepo.UpdateBill(bill);
NotificationBL notibl = new NotificationBL(Db);
notibl.NotificationOfRejection(bill.Bill_ID);
}
return(RedirectToAction("Index", "Manager"));
}
public static int ObtenerNroNoNotificados()
{
CurrentUserViewModel user = (CurrentUserViewModel)HttpContext.Current.Session[ConfigurationManager.AppSettings["session.usuario.actual"]];
NotificationBL oNotificationBL = new NotificationBL();
return(oNotificationBL.ObtenerNroNoNotificados(user.user_id));
}
// Toggles read status of notifications
protected void BtnOnNotif_Click(object sender, EventArgs e)
{
var lbl = (LinkButton)sender;
var item = (ListViewItem)lbl.NamingContainer;
int id = Convert.ToInt32(((Label)item.FindControl("lblID")).Text);
NotificationBL.ToggleReadNotification(id);
FillNotifications();
}
public DataAccessLayer()
{
_workerLogic = new WorkerBL();
_truckLogic = new TruckBL();
_driveLogic = new DriveBL();
_userLogic = new UserBL();
_notificationLogic = new NotificationBL();
_fuelLogic = new FuelBL();
_brandLogic = new BrandsBL();
}
public HttpResponseMessage AddNotificationToSpesficUser(NotificationForUser userNotification)
{
int id = NotificationBL.AddNotification(userNotification.message);
if (id != -1)
{
NotificationBL.AddNotificationForUser(userNotification.userId, id);
return(Request.CreateResponse(HttpStatusCode.OK, true));
}
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, true));
}
public IHttpActionResult Notifications(int user_id)
{
NotificationBL oNotificationBL = new NotificationBL();
var num_notificaciones_pendientes = oNotificationBL.ObtenerNroNoNotificados(user_id);
var result = new
{
notifications = oNotificationBL.ObtenerPorUsuario(user_id)
};
return(Ok(result));
}
public HttpResponseMessage AddNewNotification(int fromEmpId, int toEmpId, string type, string content)
{
try
{
NotificationBL.AddNewNotification(fromEmpId, toEmpId, type, content);
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception e)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message));
}
}
// Sets up Notification dropdown
public void FillNotifications()
{
int empId = (int)Session["empId"];
notifList = NotificationBL.GetNotifications(empId);
lblNotifCount.Text = notifList.Where(x => x.IsRead == false).Count().ToString();
notifList = notifList.OrderByDescending(x => x.NotificationDateTime).Take(10).ToList();
lstNotifications.DataSource = notifList;
lstNotifications.DataBind();
}
// POST api/<controller>
public IHttpActionResult Post([FromBody] Notification n)
{
try
{
NotificationBL.AddNotification(n);
return(Ok());
}
catch
{
throw;
}
}
public JsonResult ActualizarNotificacion(int notification_id)
{
NotificationBL oNotificationBL = new NotificationBL();
oNotificationBL.ActualizarLeido(notification_id);
return(Json(new
{
// this is what datatables wants sending back
status = "1",
}));
}
public BaseServiceResult <bool> CheckIfNotificationRead(long ReceiverNotificationID)
{
try
{
using (INotificationBL NotificationBL = new NotificationBL())
{
return(NotificationBL.CheckIfNotificationRead(ReceiverNotificationID));
}
} catch (Exception ex)
{
Logger.Error("GetNotificationContent", ex);
return(BaseServiceResult <bool> .InternalErrorResult);
}
}
public string GetUserID(string pprid)
{
NotificationBL obj = new NotificationBL();
DataTable dt = new DataTable();
dt = obj.GetUserIDBL(pprid);
string id = "0";
if (dt.Rows.Count > 0)
{
id = dt.Rows[0][0].ToString();
}
return(id);
}
public BaseServiceResult AddNotification(byte[] NotificationContent, byte[] NotificationPreviewContent, IEnumerable <string> oldReceiverIdList)
{
try
{
using (var notificationBL = new NotificationBL())
{
notificationBL.AddNotification(NotificationContent, NotificationPreviewContent, oldReceiverIdList);
return(new BaseServiceResult(ResultStatusCodes.OK, null));
}
} catch (Exception ex)
{
Logger.Error("AddNotification", ex);
return(BaseServiceResult.InternalErrorResult);
}
}
public HttpResponseMessage SendNotificationForUserNotPay(List <NotificationForUser> userNotification)
{
int id = NotificationBL.AddNotification(userNotification[0].message);
if (id != -1)
{
foreach (var t in userNotification)
{
NotificationBL.AddNotificationForUser(t.userId, id);
}
return(Request.CreateResponse(HttpStatusCode.OK, true));
}
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, true));
}
public HttpResponseMessage AddNotificationForAllUsers(NotificationForUser userNotification)
{
int id = NotificationBL.AddNotification(userNotification.message);
if (id != -1)
{
List <tenant_tbl> tenants = TenantBL.GetAllTenantByBuilding(userNotification.userId);
foreach (var t in tenants)
{
NotificationBL.AddNotificationForUser(t.user_id, id);
}
return(Request.CreateResponse(HttpStatusCode.OK, true));
}
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, true));
}
//[AuthorizeUser(Permissions = new AuthorizeUserAttribute.Permission[] { AuthorizeUserAttribute.Permission.list_programs })]
public JsonResult ObtenerLista(DataTableAjaxPostModel ofilters)//DataTableAjaxPostModel model
{
NotificationBL oNotificationBL = new NotificationBL();
//ProgramFiltersViewModel ofilters = new ProgramFiltersViewModel();
CurrentUserViewModel user = (CurrentUserViewModel)Session[ConfigurationManager.AppSettings["session.usuario.actual"]];
GridModel <NotificationViewModel> grid = oNotificationBL.ObtenerLista(ofilters, user.user_id);
return(Json(new
{
// this is what datatables wants sending back
draw = ofilters.draw,
recordsTotal = grid.total,
recordsFiltered = grid.recordsFiltered,
data = grid.rows
}));
}
public IHttpActionResult NotificationUpdateRead(ConceptQualificationViewModel filter)
{
NotificationBL oNotificationBL = new NotificationBL();
NotificationViewModel notification = oNotificationBL.ObtenerPorUrl(filter);
if (notification != null && notification.notification_id >= 0)
{
oNotificationBL.ActualizarLeido(notification.notification_id);
}
var result = new
{
status = 1
};
return(Ok(result));
}
public ActionResult ConfirmDecision(String decision, Int64 id)
{
ApricotContext Db = new ApricotContext();
BillRepository billrepo = new BillRepository(Db);
Bill bill = billrepo.GetByBillID(id);
if (decision == "yes")
{
bill.Bill_Status = Data.Models.ApricotEnums.BillSatusEnum.CLOSED;
billrepo.UpdateBill(bill);
NotificationBL notibl = new NotificationBL(Db);
notibl.NotificationOfCriditing(id);
}
//This means Bill is Still not Closed, Send Back the Index
return(RedirectToAction("Index", "FManager"));
}
public BaseServiceResult <byte[]> GetNotificationContent(long NotificationId, string NotificationAccessKey, string ReceiverToken, long ReceiverId)
{
try
{
using (IReceiverBL ReceiverBL = new ReceiverBL())
{
if (!ReceiverBL.CheckTokenValid(ReceiverToken, ReceiverId))
{
return(new BaseServiceResult <byte[]>(ResultStatusCodes.UnAuthorised, null));
}
}
using (var NotificationBL = new NotificationBL())
{
return(NotificationBL.GetNotificationContent(NotificationId, NotificationAccessKey));
}
} catch (Exception ex)
{
Logger.Error("GetNotificationContent", ex);
return(BaseServiceResult <byte[]> .InternalErrorResult);
}
}
private void NotificacionNuevaSolicitud(ConsultationViewModel pConsultationViewModel, string subject)
{
var base_url = ConfigurationManager.AppSettings["site.url"];
UserBL userBL = new UserBL();
List <UserViewModel> evaluadores = userBL.ObtenerPorPermiso(118);// 12 = perfil evaluador
foreach (UserViewModel evaluador in evaluadores)
{
SendEmailNotificationBL oSendEmailNotificationBL = new SendEmailNotificationBL();
NotificationGeneralAccountViewModel oNotificationConceptViewModel = new NotificationGeneralAccountViewModel();
oNotificationConceptViewModel.name = evaluador.contact_name;
oNotificationConceptViewModel.url_solicitud_concepto = base_url + @"/Consultation/Ver/" + pConsultationViewModel.consultation_id;
oNotificationConceptViewModel.to = evaluador.user_email;
oNotificationConceptViewModel.url_home = ConfigurationManager.AppSettings["site.url"];
oNotificationConceptViewModel.url_politicas = ConfigurationManager.AppSettings["site.url.politicas"];
oNotificationConceptViewModel.url_contacto = ConfigurationManager.AppSettings["site.url.contacto"];
oNotificationConceptViewModel.url_privacidad = ConfigurationManager.AppSettings["site.url.privacidad"];
oSendEmailNotificationBL.EnviarNotificacionSolicitudConcepto(oNotificationConceptViewModel, subject);
NotificationBL oNotificationBL = new NotificationBL();
NotificationViewModel pNotificationViewModel = new NotificationViewModel();
pNotificationViewModel.user_id = evaluador.id;
pNotificationViewModel.message = "Hay una nueva solicitud de concepto con número '" + pConsultationViewModel.consultation_id + "'";
pNotificationViewModel.url = @"/Consultation/Ver/" + pConsultationViewModel.consultation_id;
oNotificationBL.Agregar(pNotificationViewModel);
}
}
static void Main(string[] args)
{
try
{
new Program();
logger.Info("Inicio Proceso: Notificacion.Nuevos.Proyectos.Ley");
DraftLawBL oDraftLawBL = new DraftLawBL();
List <DraftLawViewModel> list = oDraftLawBL.ObtenerNotificables();
logger.Info("Proceso Notificacion.Nuevos.Proyectos.Ley: " + list.Count());
if (list.Count() > 0)
{
UserBL oUserBL = new UserBL();
List <InvestigatorViewModel> investigadores = oUserBL.ObtenerInvestigadores();
SendEmailNotificationBL oSendEmailNotificationBL = new SendEmailNotificationBL();
foreach (InvestigatorViewModel investigador in investigadores)
{
try
{
logger.Info("Inicio Investigador: " + investigador.contact_name);
List <DraftLawViewModel> proyectos_asociados = list.Where(a => investigador.commissions.Contains(a.commission_id.Value) && investigador.interest_areas.Contains(a.interest_area_id.Value)).ToList();
logger.Info("Proyectyso Nuevos: " + proyectos_asociados.Count());
if (proyectos_asociados != null && proyectos_asociados.Count > 0)
{
NotificationDraftLawViewModel oNotification = new NotificationDraftLawViewModel();
oNotification.name = investigador.contact_name;
oNotification.url = ConfigurationManager.AppSettings["site.url"] + "/Investigator/MisProyectosLey";
oNotification.to = investigador.user_email;
oNotification.DraftLaws = proyectos_asociados;
oNotification.url_home = ConfigurationManager.AppSettings["site.url"];
oNotification.url_politicas = ConfigurationManager.AppSettings["site.url.politicas"];
oNotification.url_contacto = ConfigurationManager.AppSettings["site.url.contacto"];
oNotification.url_privacidad = ConfigurationManager.AppSettings["site.url.privacidad"];
oSendEmailNotificationBL.EnviarNotificacionInvestigadorProyectosNuevos(oNotification);
NotificationBL oNotificationBL = new NotificationBL();
NotificationViewModel pNotificationViewModel = new NotificationViewModel();
pNotificationViewModel.user_id = investigador.user_id;
pNotificationViewModel.message = "Se han registrado proyecto(s) de ley de sus áreas de interés";
pNotificationViewModel.url = @"/Investigator/MisProyectosLey";
oNotificationBL.Agregar(pNotificationViewModel);
}
logger.Info("Fin Investigador: " + investigador.contact_name);
}
catch (Exception ex)
{
logger.Info("Error en Notificacion.Nuevos.Proyectos.Ley:");
logger.Info("Mensaje: " + ex.Message);
logger.Info("StackTrace: " + ex.StackTrace);
logger.Error("Notificacion.Nuevos.Proyectos.Ley: ", ex);
}
}
oDraftLawBL.ActualizarNotificacion(list);
}
logger.Info("Fin de Proceso: Notificacion.Nuevos.Proyectos.Ley");
}
catch (Exception ex)
{
logger.Info("Error en Notificacion.Nuevos.Proyectos.Ley:");
logger.Info("Mensaje: " + ex.Message);
logger.Info("StackTrace: " + ex.StackTrace);
logger.Error("Notificacion.Nuevos.Proyectos.Ley: ", ex);
}
}
public void NotificationRead(string notificationId)
{
NotificationBL obj = new NotificationBL();
obj.NotificationReadBL(notificationId);
}
// GET api/<controller>/5
public Notification Get(int id)
{
return(NotificationBL.GetById(id));
}
// GET api/<controller>
public List <Notification> Get()
{
return(NotificationBL.GetAll());
}
public List<CarsInfo.UsedCarsInfo> MobileCarsNotificationSearch(string carMake, string CarModal,
string Mileage, string Year, string Price, string Orderby, string Zipcode, string exteriorColor, string interiorColor,
string Transmission, string VehiceCondition, string DriveTrain, string numberOfCylinder, string numberOfDoors, string fuelType, string AuthenticationID, string CustomerID)
{
CarsFilter objCarsFilter = new CarsFilter();
Filter objFilter = new Filter();
List<CarsInfo.UsedCarsInfo> objFilterdata = new List<CarsInfo.UsedCarsInfo>();
CarsInfo.UsedCarsInfo OBJ = new CarsInfo.UsedCarsInfo();
string sort = string.Empty;
objCarsFilter.CarMakeid = carMake;
objCarsFilter.CarModalId = CarModal;
objCarsFilter.Orderby = Orderby;
objCarsFilter.ZipCode = Zipcode;
switch (Mileage)
{
case "Mileage1":
objCarsFilter.Mileage1 = "Mileage1";
break;
case "Mileage2":
objCarsFilter.Mileage2 = "Mileage2";
break;
case "Mileage3":
objCarsFilter.Mileage3 = "Mileage3";
break;
case "Mileage4":
objCarsFilter.Mileage4 = "Mileage4";
break;
case "Mileage5":
objCarsFilter.Mileage5 = "Mileage5";
break;
case "Mileage6":
objCarsFilter.Mileage6 = "Mileage6";
break;
case "Mileage7":
objCarsFilter.Mileage7 = "Mileage7";
break;
}
switch (Year)
{
case "Year1a":
objCarsFilter.Year1a = "Year1a";
break;
case "Year1b":
objCarsFilter.Year1b = "Year1b";
break;
case "Year1":
objCarsFilter.Year1 = "Year1";
break;
case "Year2":
objCarsFilter.Year2 = "Year2";
break;
case "Year3":
objCarsFilter.Year3 = "Year3";
break;
case "Year4":
objCarsFilter.Year4 = "Year4";
break;
case "Year5":
objCarsFilter.Year5 = "Year5";
break;
case "Year6":
objCarsFilter.Year6 = "Year6";
break;
case "Year7":
objCarsFilter.Year7 = "Year7";
break;
}
switch (Price)
{
case "Price1":
objCarsFilter.Price1 = "Price1";
break;
case "Price2":
objCarsFilter.Price2 = "Price2";
break;
case "Price3":
objCarsFilter.Price3 = "Price3";
break;
case "Price4":
objCarsFilter.Price4 = "Price4";
break;
case "Price5":
objCarsFilter.Price5 = "Price5";
break;
};
NotificationBL objFilterCars = new NotificationBL();
MobileBL objMobileBL = new MobileBL();
if (CustomerID.Trim() != "")
{
string parameter = carMake + "," + CarModal + "," + Mileage + "," + Year + "," + Price + "," + Orderby + "," + Zipcode;
DataSet dsSaveCustInfo = objMobileBL.SaveMobileCustomerInfo("MobileCarsNotificationSearch", CustomerID, AuthenticationID, parameter);
}
if (AuthenticationID == ConfigurationManager.AppSettings["AppleID"].ToString())
{
objFilterdata = (List<CarsInfo.UsedCarsInfo>)objFilterCars.GetMobileNotificationSearch(objCarsFilter, exteriorColor.Trim(), interiorColor.Trim(), Transmission.Trim(), VehiceCondition.Trim(),
DriveTrain.Trim(), numberOfCylinder.Trim(), numberOfDoors.Trim(), fuelType.Trim());
}
return objFilterdata;
}
