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)); }