public ActionResult Upload(HttpPostedFileBase file)
{
ProposalModel proposal = (ProposalModel)Session["Proposal"];
if (file == null)
{
ViewBag.Error = "No selecciono un archivo";
return(View("RegisterUserProposal", null));
}
string archivo = (DateTime.Now.ToString("yyyyMMddHHmmss") + "-" + file.FileName).ToLower();
string ruta = Server.MapPath("~/Files/" + archivo);
file.SaveAs(Server.MapPath("~/Files/" + archivo));
if (RegistroMasivo(ruta, ((ProposalModel)Session["Proposal"]).ContracEthereumProposal, ((ProposalModel)Session["Proposal"]).ProposalName))
{
ViewBag.Success = "Se enviaron las invitaciones con éxito.";
ProposalBussiness ProposalLogic = new ProposalBussiness();
ProposalFilter Filtro = new ProposalFilter();
UserModel user = (UserModel)Session["User"];
Filtro.Email = user.Email;
Filtro.QuestionType = null;
List <ProposalModel> ListProposal = new List <ProposalModel>();
ListProposal = ProposalLogic.SearchProposalByUser(Filtro);
return(View("ProposalList", ListProposal));
}
else
{
ViewBag.Error = "Hay Correos Invalidos";
return(View("RegisterUserProposal", null));
}
// return View("ProposalList");
}
// GET: Votes
public ActionResult Index(string id)
{
Session["propId"] = id;
UserModel user = (UserModel)Session["User"];
if (user == null)
{
return(RedirectToAction("Index", "Home"));
}
else
{
ProposalFilter Filtro = new ProposalFilter();
Filtro.Email = user.Email;
// Filtro.TypeVoting = 0;
ProposalBussiness ProposalLogic = new ProposalBussiness();
List <ProposalModel> ListProposal = new List <ProposalModel>();
ListProposal = ProposalLogic.SearchProposalByUser(Filtro);
ProposalModel currentProposal = ListProposal.Where(x => x.ContracEthereumProposal == id).FirstOrDefault();
ViewBag.UserEmail = user.Email;
return(View(currentProposal));
}
}
//public ActionResult RegistrarOption(UserModel Data)
//{
// if (ModelState.IsValid)
// {
// ProposalBussiness ProposalLogic = new ProposalBussiness();
// ProposalLogi.
// bool existUser = false;
// bool valid = false;
// valid = RegisterUser(Data, out existUser);
// if (existUser)
// {
// //si es true el usuario existe mesaje de que existe en la vista
// ViewBag.ErrorUsuarioExiste = "El usuario " + Data.UserName + " ya fue registrado anteriormente";
// }
// else
// {
// if (valid)
// {
// return RedirectToAction("UserList", "User");
// }
// else
// {
// ViewBag.ErrorDesconocido = "Occurió un error insertando. Por favor intentelo nuevamente.";
// }
// }
// }
// else
// {
// return View("NewUser", Data);
// }
// return View("NewUser", Data);
//}
public ActionResult NewOption(string p, string n)
{
try
{
UserModel user = (UserModel)Session["User"];
if (user == null)
{
return(RedirectToAction("Index", "Home"));
}
else
{
ProposalFilter Filtro = new ProposalFilter();
Filtro.Email = user.Email;
// Filtro.TypeVoting = 0;
ProposalBussiness ProposalLogic = new ProposalBussiness();
List <ProposalModel> ListProposal = new List <ProposalModel>();
NewOptionModel NewOption = new NewOptionModel();
NewOption.ProposalId = p;
NewOption.ProposalName = n;
NewOption.Proposals = ProposalLogic.SearchProposalByUser(Filtro);
return(View(NewOption));
}
}
catch
{
return(View("Error"));
}
}
public ActionResult Proposals(ProposalFilter filter)
{
var model = new ProposalsViewModel
{
Filter = filter
};
return(View(model));
}
public ActionResult ProposalsList(ProposalFilter filter, int page = 1)
{
PagingOption option = GetPagingOption15(page);
var model = new ProposalsViewModel
{
Proposals = bll.ProposalManager.SelectProposals(filter, option),
PagingOption = new WebPagingOption {
CurrentPage = page, ItemsPerPage = PageSize15, TotalItems = option.RecordCount
}
};
return(PartialView(model));
}
public List <Proposal> SelectProposals(ProposalFilter filter, PagingOption option)
{
List <Proposal> list = new List <Proposal>();
string sql = "SELECT * FROM dbo.Proposal WHERE 1 = 1" + filter.GetFilterString();
string orderBy = "";
var table = ExecuteDataTable(sql, option, orderBy);
foreach (DataRow row in table.Rows)
{
list.Add(DataRowToProposal(row));
}
return(list);
}
public ActionResult EditSummit(ProposalModel proposal)
{
try
{
proposal.ContracEthereumProposal = ((ProposalModel)Session["Proposal"]).ContracEthereumProposal;
proposal.QuestionType = ((ProposalModel)Session["Proposal"]).QuestionType;
UserModel user = (UserModel)Session["User"];
using (ProposalDataAccess proposalDataAccess = new ProposalDataAccess())
{
if (proposalDataAccess.UpdateProposal(proposal))
{
ProposalFilter Filtro = new ProposalFilter();
Filtro.Email = user.Email;
// Filtro.TypeVoting = 0;
ProposalBussiness ProposalLogic = new ProposalBussiness();
List <ProposalModel> ListProposal = new List <ProposalModel>();
ListProposal = ProposalLogic.SearchProposalByUser(Filtro);
ViewBag.Success = "Se modificó correctamente";
return(View("ProposalList", ListProposal));
}
else
{
ProposalBussiness ProposalLogic = new ProposalBussiness();
ProposalModel Filtro = new ProposalModel();
Filtro.ContracEthereumProposal = proposal.ContracEthereumProposal;
ProposalModel CurrentProposal = new ProposalModel();
CurrentProposal = ProposalLogic.SearchProposal(Filtro)[0];
ViewBag.SucceErrorss = "Se modificó correctamente";
return(View("Edit", CurrentProposal));
}
}
}
catch
{
return(View("error"));
}
}
public List <ProposalModel> SearchProposalByUser(ProposalFilter filter)
{
List <ProposalModel> list = null;
if (filter != null && filter.Email != null && filter.Email != string.Empty)
{
using (ProposalDataAccess proposalDataAccess = new ProposalDataAccess())
{
if (filter != null)
{
list = proposalDataAccess.SearchProposalByUser(filter.Email, (EnumQuestionType?)filter.QuestionType);
}
list = proposalDataAccess.SearchProposal(null, null);
}
}
return(list);
}
public static string ToQueryParams(this ProposalFilter filter)
{
string queryParams = string.Empty;
if (!string.IsNullOrWhiteSpace(filter.Title))
{
queryParams = QueryParamsHelper.AddParams(queryParams, $"title={filter.Title}");
}
if (filter.Date.HasValue)
{
queryParams = QueryParamsHelper.AddParams(queryParams, $"date={filter.Date.Value.ToString("yyyy-MM-dd")}");
}
if (filter.IsActive.HasValue)
{
queryParams = QueryParamsHelper.AddParams(queryParams, $"isActive={filter.IsActive.Value}");
}
return(queryParams);
}
public ActionResult ProposalList()
{
UserModel user = (UserModel)Session["User"];
if (user == null)
{
return(RedirectToAction("Index", "Home"));
}
else
{
ProposalFilter Filtro = new ProposalFilter();
Filtro.Email = user.Email;
/// Filtro.QuestionType = EnumQuestionType.Papeleta;
ProposalBussiness ProposalLogic = new ProposalBussiness();
List <ProposalModel> ListProposal = new List <ProposalModel>();
ListProposal = ProposalLogic.SearchProposalByUser(Filtro);
return(View(ListProposal));
}
}
public List <ProposalModel> SearchProposalByUser(ProposalFilter filter)
{
ProposalBussiness bussiness = new ProposalBussiness();
return(bussiness.SearchProposalByUser(filter));
}
public List <Proposal> SelectProposals(ProposalFilter filter, PagingOption option)
{
return(_dal.ProposalRepository.SelectProposals(filter, option));
}
