public TB_UserVote Login(TB_UserVote userv, OleDbConnection db)
{
string pwd = Security.DesEncriptar(userv.password);
DataSet dataSet = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter("select * from TB_UserVote where Login='******'and Password ='******';", db);;
da.Fill(dataSet);
db.Close();
DataTable dt = dataSet.Tables[0];
TB_UserVote _Userv = null;
foreach (DataRow rows in dt.Rows)
{
_Userv = new TB_UserVote(
int.Parse(rows["Id"].ToString()),
rows["Login"].ToString(),
rows["Password"].ToString(),
int.Parse(rows["TypeUserId"].ToString()),
int.Parse(rows["VotationId"].ToString()),
rows["NameUser"].ToString(),
rows["LastNameUser"].ToString(),
rows["DocumentNumber"].ToString());
}
return(_Userv);
}
public List <TB_UserVote> lstUserinVotation(int id, OleDbConnection db)
{
List <TB_UserVote> lst = new List <TB_UserVote>();
DataSet ds = new DataSet();
try
{
OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM TB_USERVOTE WHERE VOTATIONID =" + id, db);
da.Fill(ds);
db.Close();
DataTable dt = ds.Tables[0];
foreach (DataRow rows in dt.Rows)
{
TB_UserVote uv = new TB_UserVote();
uv.id = int.Parse(rows["Id"].ToString());
uv.login = rows["Login"].ToString();
uv.votationid = int.Parse(rows["VotationId"].ToString());
uv.nameUser = rows["NameUser"].ToString();
uv.lastnameUser = rows["LastNameUser"].ToString();
uv.dni = rows["DocumentNumber"].ToString();
lst.Add(uv);
}
}
catch (Exception)
{
throw;
}
return(lst);
}
public JsonResult CreateUserVotation(TB_UserVote userVote)
{
string result = TB_vota.addVotantes(userVote, DBConnect.open());
// Session["Votation"] = tb_Votation;
return(Json(result));
}
public ActionResult UploadFileVotants()
{
if (Request.Files.Count > 0)
{
int idVotation = int.Parse(Request.Form[0].ToString());
string fullpath = "";
try
{
HttpFileCollectionBase files = Request.Files;
HttpPostedFileBase file = files[0];
string fname;
if (Request.Browser.Browser.ToUpper() == "IE" || Request.Browser.Browser.ToUpper() == "INTERNETEXPLORER")
{
string[] testfiles = file.FileName.Split(new char[] { '\\' });
fname = testfiles[testfiles.Length - 1];
}
else
{
string filen = Request.Files.AllKeys[0].ToString();
string path = Path.Combine(HttpRuntime.AppDomainAppPath, "Resource\\Upload\\Users\\");
fullpath = Path.Combine(path, filen);
file.SaveAs(fullpath);
}
using (var reader = new StreamReader(fullpath, Encoding.Default, true))
{
while (!reader.EndOfStream)
{
var line = reader.ReadLine();
var values = line.Split(';');
if (!values[0].Contains("Name"))
{
TB_UserVote userVote = new TB_UserVote();
userVote.nameUser = values[0].ToString();
userVote.lastnameUser = values[1].ToString();
userVote.votationid = idVotation;
userVote.typeUserid = 3;
userVote.dni = values[2].ToString();
userVote.login = values[3].ToString();
userVote.password = values[4].ToString();
TB_vota.addVotantes(userVote, DBConnect.open());
}
}
}
System.IO.File.Delete(fullpath);
}
catch (System.Exception ex)
{
return(Json("Error is " + ex.Message));
}
}
return(Json(""));
}
public JsonResult Login(TB_UserVote userv)
{
string MessageLogin = "";
TB_UserVote tbu = tu.Login(userv, DBConnect.open());
if (tbu.id != null)
{
Session["UserVote"] = tbu;
MessageLogin = "******";
}
else
{
MessageLogin = "******";
}
return(Json(MessageLogin, JsonRequestBehavior.AllowGet));
}
public string insertVotations(TB_UserVote uv, OleDbConnection db)
{
string pwd = Security.Encriptar(uv.password);
string result = "";
try
{
string sql = @"INSERT INTO TB_UserVote(Login,[Password],TypeUserId,Votationid,NameUser,LastNameUser,DocumentNumber) VALUES ('" + uv.login + "','" + pwd + "'," + uv.typeUserid + "," + uv.votationid + ",'" + uv.nameUser + "','" + uv.lastnameUser + "','" + uv.dni + "')";
OleDbCommand cmd = new OleDbCommand(sql, db);
cmd.ExecuteNonQuery();
db.Close();
result = "VOTACIÒN INICIADA";
}
catch (Exception)
{
throw;
}
return(result);
}
public string addVotantes(TB_UserVote uv, OleDbConnection db)
{
return(_Votation.insertVotations(uv, db));
}
public TB_UserVote Login(TB_UserVote userv, OleDbConnection db)
{
return(userVote.Login(userv, db));
}
