public IActionResult checkRegister([FromBody] User data) { ResponseErr res = new ResponseErr(); try { var db = new ConMySQL(); string sql = $"SELECT * FROM User WHERE UserName = '******'"; DataTable dataTable = db.getData(sql); // Console.WriteLine(dataTable.Rows); User obj = new User(); foreach (DataRow dr in dataTable.Rows) { obj.userName = dr["userName"].ToString(); } // Console.WriteLine(obj.userName); if (obj.userName != null) { return(Ok("notEmpty")); } else { res.msg = "empty"; return(Ok("empty")); } } catch (Exception ex) { res.msg = ex.Message; res.data = data; // return res; return(BadRequest(res)); } }
public IActionResult GetPhotoShare(DataFile data) { var db = new ConMySQL(); try { Request.Headers.TryGetValue("Authorization", out var token); token = ((string)token).Replace("Bearer ", ""); var handler = new JwtSecurityTokenHandler(); JwtSecurityToken decodedValue = handler.ReadJwtToken(token); List <Claim> claimsList = decodedValue.Claims.ToList(); var id = claimsList.Find(x => x.Type == "unique_name").Value; string sql = string.Format("SELECT * FROM DataFile WHERE wwwPath like '%{0}'and Share = '{1}'", data.Path, id); DataTable SqlDataSet = db.getData(sql); Console.WriteLine(sql); DataFile obj = new DataFile(); foreach (DataRow dr in SqlDataSet.Rows) { obj.wwwPath = dr["wwwpath"].ToString(); } return(Ok(obj)); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public IActionResult login([FromBody] User data) { ResponseErr res = new ResponseErr(); try { var db = new ConMySQL(); string sql = $"SELECT * FROM User WHERE UserName = '******' and PassWord = '******'"; DataTable dataTable = db.getData(sql); // Console.WriteLine(dataTable.Rows); User obj = new User(); foreach (DataRow dr in dataTable.Rows) { obj.id = Convert.ToInt32(dr["id"]); obj.userName = dr["userName"].ToString(); // obj.passWord = dr["passWord"].ToString(); } // foreach (DataRow dataRow in dataTable.Rows) // { // foreach(var item in dataRow.ItemArray) // { // Console.WriteLine(item); // } // } data.id = obj.id; // Console.WriteLine(obj.userName); IActionResult response = Unauthorized(); if (obj.userName != null) { res.msg = "okay"; var tokenString = GenerateJSONWebToken(data); response = Ok(new { token = tokenString, Username = obj.userName }); return(Ok(response)); } else { res.msg = "empty"; return(Ok("empty")); } } catch (Exception ex) { res.msg = ex.Message; res.data = data; // return res; return(BadRequest(res)); } }
// IEnumerable<DataFile> public IEnumerable <DataFile> GetDataFiles([FromBody] DataFile GetData) { ResponseErr res = new ResponseErr(); DataFile data = new DataFile(); var db = new ConMySQL(); List <DataFile> list_result = new List <DataFile>(); try { Request.Headers.TryGetValue("Authorization", out var token); token = ((string)token).Replace("Bearer ", ""); var handler = new JwtSecurityTokenHandler(); JwtSecurityToken decodedValue = handler.ReadJwtToken(token); List <Claim> claimsList = decodedValue.Claims.ToList(); var id = claimsList.Find(x => x.Type == "unique_name").Value; // Console.WriteLine(claimsList); int share = 0; // int id = 23; // string sql = $"SELECT * FROM DataFile"; // string sql = string.Format("SELECT * FROM DataFile WHERE Path = '{0}'and IdUser = '******'", datafile.Path, id); string sql = string.Format("SELECT * FROM DataFile WHERE Path = '{0}'and IdUser = '******' and Share = '{2}'", GetData.Path, id, share); // Console.WriteLine(sql); DataTable SqlDataSet = db.getData(sql); foreach (DataRow dr in SqlDataSet.Rows) { DataFile obj = new DataFile(); obj.Id = Convert.ToInt32(dr["id"]); obj.NameFile = dr["namefile"].ToString(); obj.Path = dr["path"].ToString(); obj.Type = dr["type"].ToString(); obj.wwwPath = dr["wwwpath"].ToString(); obj.IdUser = Convert.ToInt32(dr["iduser"]); obj.MainFolder = Convert.ToInt32(dr["MainFolder"]); list_result.Add(obj); } // return Ok(claimsList); } catch (Exception ex) { res.msg = ex.Message; res.listdata = list_result; Console.WriteLine(ex.Message); // return BadRequest(); } // Console.WriteLine(JsonConvert.SerializeObject(list_result, Formatting.Indented)); return(list_result); }
public IActionResult fristFolder(string userName, int id) { try { var db = new ConMySQL(); var pathfrist = "/uploads"; string sqlfile = $"INSERT INTO DataFile(NameFile, Path, Type ,IdUser) VALUES ('{userName}','{pathfrist}', 'Folder', '{id}')"; db.executeQuery(sqlfile); // Console.WriteLine(sqlfile); return(Ok()); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public IActionResult GetUser([FromBody] User data) { try{ var db = new ConMySQL(); string sqlUser = string.Format("SELECT * FROM User WHERE id = '{0}'", data.id); DataTable SqlData = db.get(sqlUser); User objUser = new User(); foreach (DataRow dr in SqlData.Rows) { objUser.userName = dr["username"].ToString(); } return(Ok(objUser)); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public IActionResult Register([FromBody] User data) { ResponseErr res = new ResponseErr(); try { var db = new ConMySQL(); var pathsql = "/uploads/" + data.userName; string sqluser = $"INSERT INTO User(UserName, Password, Email) VALUES ('{data.userName}','{data.passWord}','{data.email}')"; db.executeQuery(sqluser); string sqlgetuser = $"SELECT * FROM User WHERE UserName = '******'"; DataTable dataTableGet = db.getData(sqlgetuser); User obj = new User(); foreach (DataRow dr in dataTableGet.Rows) { obj.id = Convert.ToInt32(dr["id"]); } Console.WriteLine(obj.id); // Console.WriteLine(pathsql); // string sqlfile = $"INSERT INTO DataFile(NameFile, Path, Type ,IdUser) VALUES ('{data.userName}','{pathsql}', 'Folder', '{obj.id}')"; // Console.WriteLine(sqlfile); // db.executeQuery(sqlfile); var pathFristFolder = "/" + data.userName; fristFolder(data.userName, obj.id); // Console.WriteLine(data.userName); string startupPath = Environment.CurrentDirectory; string path = startupPath + "/wwwroot/uploads/" + data.userName; Directory.CreateDirectory(path); res.msg = "okay"; return(Ok(res)); } catch (Exception ex) { res.msg = ex.Message; res.data = data; // return res; return(BadRequest(res)); } }
/// <summary> /// Constructor de Entrada. Instancia una sesion de facturacion electronica /// </summary> /// <param name="Config">Path de ubicacion del archivo de configuracion</param> /// <param name="User">Usuario de sistema</param> //Constructor de Entrada public FacturacionElectronica(string Config, string User) { //Verificacion de existencia de archivo de configuracion if (!File.Exists(Config)) { throw new Exception("Archivo de configuracion no existe"); } //Seteo de varuales de control this.ConfigFile = Config; this.UserSystem = User; //Intanciamiento de clases globales this.utl = new Utils(); string errorPath = utl.convertirString(utl.getConfigValue(this.ConfigFile, "SERVICES", "errors")); this.con = new ConMySQL(this.ConfigFile, this.UserSystem); this.err = new Errors(this.UserSystem, "ElecDocs", errorPath); this.ftp = new FtpAccess(this.ConfigFile, this.UserSystem); }
public IActionResult Register() { try { var db = new ConMySQL(); db.Open(); string sql = $"SELECT * FROM User"; System.Data.DataTable SqlData = db.get(sql); List <User> list_result = new List <User>(); foreach (DataRow dr in SqlData.Rows) { User objUser = new User(); objUser.userName = dr["username"].ToString(); list_result.Add(objUser); } return(Ok(list_result)); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public IActionResult ReportExcel(string Username) { List <Author> authors = new List <Author> { new Author { Id = 1, FirstName = "Joydip", LastName = "Kanjilal" }, new Author { Id = 2, FirstName = "Steve", LastName = "Smith" }, new Author { Id = 3, FirstName = "Anand", LastName = "Narayaswamy" } }; string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; string fileName = "authors.xlsx"; try { var db = new ConMySQL(); db.Open(); if (Username != "All") { string sqlUser = $"SELECT * FROM User Where UserName = '******'"; System.Data.DataTable SqlData = db.get(sqlUser); User objUser = new User(); foreach (DataRow dr in SqlData.Rows) { objUser.id = Convert.ToInt32(dr["id"]); } using (var workbook = new XLWorkbook()) { IXLWorksheet worksheet = workbook.Worksheets.Add(Username); worksheet.Cell(1, 1).Value = "File(Owner)"; // worksheet.Cell(1, 2).Value = "File(Share)"; // worksheet.Cell(1, 3).Value = "File(receiver Share)"; int index = 1; string sqlFileOwner = $"SELECT * FROM DataFile Where IdUser = '******' and Share = '0'"; System.Data.DataTable SqlDataFileOwner = db.get(sqlFileOwner); foreach (DataRow dr in SqlDataFileOwner.Rows) { worksheet.Cell(index + 1, 1).Value = dr["path"].ToString() + "/" + dr["namefile"].ToString(); index++; } index += 2; worksheet.Cell(index, 1).Value = "File(Share)"; worksheet.Cell(index, 2).Value = "File(Share TO)"; // worksheet.Cell(index, 1).Value += "eiei"; // index++; // string namefilearr = null; //edit string sqlFileShare1 = $"SELECT * FROM DataFile Where IdUser = '******' and Share = '0'"; System.Data.DataTable SqlDataFileShare1 = db.get(sqlFileShare1); string sqlFileShare2 = $"SELECT * FROM DataFile Where IdUser = '******' and Share != '0'"; System.Data.DataTable SqlDataFileShare2 = db.get(sqlFileShare2); foreach (DataRow dr in SqlDataFileShare1.Rows) { var x = 0; foreach (DataRow dt in SqlDataFileShare2.Rows) { if (Convert.ToInt32(dr["id"]) == Convert.ToInt32(dt["mainfolder"]) && Convert.ToInt32(dr["share"]) != Convert.ToInt32(dt["share"])) { if (x == 0) { worksheet.Cell(index, 1).Value = dr["path"].ToString() + "/" + dr["namefile"].ToString(); int drNum = Convert.ToInt32(dt["share"]); string sqlUsernameShareTo = $"SELECT * FROM user Where Id = '{drNum}'"; System.Data.DataTable SqlDataFileShareTo = db.get(sqlUsernameShareTo); // Console.WriteLine("index"); foreach (DataRow drTo in SqlDataFileShareTo.Rows) { worksheet.Cell(index, 2).Value = drTo["username"].ToString(); } // return Ok(SqlDataFileShareTo.Rows); // Console.WriteLine(SqlDataFileShareTo.Rows.length); // worksheet.Cell(index, 2).Value = Convert.ToInt32(dr["share"]) + ", " + Convert.ToInt32(dt["share"]); } else { int drNum = Convert.ToInt32(dt["share"]); string sqlUsernameShareTo1 = $"SELECT * FROM user Where Id = '{drNum}'"; System.Data.DataTable SqlDataFileShareTo1 = db.get(sqlUsernameShareTo1); foreach (DataRow dr1 in SqlDataFileShareTo1.Rows) { worksheet.Cell(index, 2).Value += ", " + dr1["username"].ToString(); } // worksheet.Cell(index, 2).Value += ", " + Convert.ToInt32(dt["share"]); } x++; } } //edit2 // int IdUsernameShare = Convert.ToInt32(dr["share"]); // string sqlUsernameShareTo = $"SELECT * FROM user Where Id = '{IdUsernameShare}'"; // System.Data.DataTable SqlDataFileShareTo = db.get(sqlUsernameShareTo); // foreach (DataRow datar in SqlDataFileShareTo.Rows) // { // worksheet.Cell(index, 2).Value = datar["username"].ToString(); // } // worksheet.Cell(index + 1, 2).Value = Convert.ToInt32(dr["share"]); index++; } index += 1; worksheet.Cell(index, 1).Value = "File(Receiver Share)"; worksheet.Cell(index, 2).Value = "File(Share From)"; string sqlFileReceiverShare = $"SELECT * FROM DataFile Where Share = '{objUser.id}'"; System.Data.DataTable SqlDataFileReceiverShare = db.get(sqlFileReceiverShare); foreach (DataRow dr in SqlDataFileReceiverShare.Rows) { worksheet.Cell(index + 1, 1).Value = dr["path"].ToString() + "/" + dr["namefile"].ToString(); int drNum = Convert.ToInt32(dr["IdUser"]); string sqlUsernameShareTo1 = $"SELECT * FROM user Where Id = '{drNum}'"; System.Data.DataTable SqlDataFileShareTo1 = db.get(sqlUsernameShareTo1); foreach (DataRow dr1 in SqlDataFileShareTo1.Rows) { worksheet.Cell(index + 1, 2).Value = dr1["username"].ToString(); } // worksheet.Cell(index + 1, 2).Value = Convert.ToInt32(dr["IdUser"]); index++; } // worksheet.Cell(index + 1, 2).Value = // authors[index - 1].FirstName; // worksheet.Cell(index + 1, 3).Value = // authors[index - 1].LastName; // return Ok(listFileOwner); using (var stream = new MemoryStream()) { workbook.SaveAs(stream); var content = stream.ToArray(); return(File(content, contentType, fileName)); } } } else if (Username == "All") { // Console.WriteLine("Key"); string sqlAllUsername = $"SELECT * FROM user"; System.Data.DataTable SqlDataAllUsername = db.get(sqlAllUsername); var workbook = new XLWorkbook(); foreach (DataRow drAll in SqlDataAllUsername.Rows) { string name = drAll["username"].ToString(); // Console.WriteLine(name); string sqlUser = $"SELECT * FROM User Where UserName = '******'"; System.Data.DataTable SqlData = db.get(sqlUser); User objUser = new User(); foreach (DataRow dr in SqlData.Rows) { objUser.id = Convert.ToInt32(dr["id"]); } //edit // var workbook = new XLWorkbook(); IXLWorksheet worksheet = workbook.Worksheets.Add(name); worksheet.Cell(1, 1).Value = "File(Owner)"; // worksheet.Cell(1, 2).Value = "File(Share)"; // worksheet.Cell(1, 3).Value = "File(receiver Share)"; int index = 1; string sqlFileOwner = $"SELECT * FROM DataFile Where IdUser = '******' and Share = '0'"; System.Data.DataTable SqlDataFileOwner = db.get(sqlFileOwner); foreach (DataRow dr in SqlDataFileOwner.Rows) { worksheet.Cell(index + 1, 1).Value = dr["path"].ToString() + "/" + dr["namefile"].ToString(); index++; } index += 2; worksheet.Cell(index, 1).Value = "File(Share)"; worksheet.Cell(index, 2).Value = "File(Share TO)"; // worksheet.Cell(index, 1).Value += "eiei"; // index++; // string namefilearr = null; //edit string sqlFileShare1 = $"SELECT * FROM DataFile Where IdUser = '******' and Share = '0'"; System.Data.DataTable SqlDataFileShare1 = db.get(sqlFileShare1); string sqlFileShare2 = $"SELECT * FROM DataFile Where IdUser = '******' and Share != '0'"; System.Data.DataTable SqlDataFileShare2 = db.get(sqlFileShare2); foreach (DataRow dr in SqlDataFileShare1.Rows) { var x = 0; foreach (DataRow dt in SqlDataFileShare2.Rows) { if (Convert.ToInt32(dr["id"]) == Convert.ToInt32(dt["mainfolder"]) && Convert.ToInt32(dr["share"]) != Convert.ToInt32(dt["share"])) { if (x == 0) { worksheet.Cell(index, 1).Value = dr["path"].ToString() + "/" + dr["namefile"].ToString(); int drNum = Convert.ToInt32(dt["share"]); string sqlUsernameShareTo = $"SELECT * FROM user Where Id = '{drNum}'"; System.Data.DataTable SqlDataFileShareTo = db.get(sqlUsernameShareTo); // Console.WriteLine("index"); foreach (DataRow drTo in SqlDataFileShareTo.Rows) { worksheet.Cell(index, 2).Value = drTo["username"].ToString(); } // return Ok(SqlDataFileShareTo.Rows); // Console.WriteLine(SqlDataFileShareTo.Rows.length); // worksheet.Cell(index, 2).Value = Convert.ToInt32(dr["share"]) + ", " + Convert.ToInt32(dt["share"]); } else { int drNum = Convert.ToInt32(dt["share"]); string sqlUsernameShareTo1 = $"SELECT * FROM user Where Id = '{drNum}'"; System.Data.DataTable SqlDataFileShareTo1 = db.get(sqlUsernameShareTo1); foreach (DataRow dr1 in SqlDataFileShareTo1.Rows) { worksheet.Cell(index, 2).Value += ", " + dr1["username"].ToString(); } // worksheet.Cell(index, 2).Value += ", " + Convert.ToInt32(dt["share"]); } x++; } } //edit2 // int IdUsernameShare = Convert.ToInt32(dr["share"]); // string sqlUsernameShareTo = $"SELECT * FROM user Where Id = '{IdUsernameShare}'"; // System.Data.DataTable SqlDataFileShareTo = db.get(sqlUsernameShareTo); // foreach (DataRow datar in SqlDataFileShareTo.Rows) // { // worksheet.Cell(index, 2).Value = datar["username"].ToString(); // } // worksheet.Cell(index + 1, 2).Value = Convert.ToInt32(dr["share"]); index++; } index += 1; worksheet.Cell(index, 1).Value = "File(Receiver Share)"; worksheet.Cell(index, 2).Value = "File(Share From)"; string sqlFileReceiverShare = $"SELECT * FROM DataFile Where Share = '{objUser.id}'"; System.Data.DataTable SqlDataFileReceiverShare = db.get(sqlFileReceiverShare); foreach (DataRow dr in SqlDataFileReceiverShare.Rows) { worksheet.Cell(index + 1, 1).Value = dr["path"].ToString() + "/" + dr["namefile"].ToString(); int drNum = Convert.ToInt32(dr["IdUser"]); string sqlUsernameShareTo1 = $"SELECT * FROM user Where Id = '{drNum}'"; System.Data.DataTable SqlDataFileShareTo1 = db.get(sqlUsernameShareTo1); foreach (DataRow dr1 in SqlDataFileShareTo1.Rows) { worksheet.Cell(index + 1, 2).Value = dr1["username"].ToString(); } // worksheet.Cell(index + 1, 2).Value = Convert.ToInt32(dr["IdUser"]); index++; } // worksheet.Cell(index + 1, 2).Value = // authors[index - 1].FirstName; // worksheet.Cell(index + 1, 3).Value = // authors[index - 1].LastName; // return Ok(listFileOwner); // using (var stream = new MemoryStream()) // { // workbook.SaveAs(stream); // var content = stream.ToArray(); // return File(content, contentType, fileName); // } } using (var stream = new MemoryStream()) { workbook.SaveAs(stream); var content = stream.ToArray(); return(File(content, contentType, fileName)); } } return(Ok()); } catch (Exception ex) { return(BadRequest(ex.Message)); } }