public IHttpActionResult AdminLogin(LogInModel Model) { LogInResult resModel = new LogInResult(); String newID = Shuffle(Model.ID); resModel.ID = newID; resModel.Result = false; SQL_function sql_function = new SQL_function(); String strQuery_auth = @"SELECT COUNT(*) FROM [DuLieuTotNghiep].[dbo].[Account] WHERE [UserName] = @UserName and [Password] =@Password "; SqlCommand cmd_auth = new SqlCommand(strQuery_auth); cmd_auth.Parameters.Add("@UserName", SqlDbType.NVarChar).Value = Model.UserName; cmd_auth.Parameters.Add("@Password", SqlDbType.NVarChar).Value = Model.Password; String[,] array_auth = sql_function.xml_deserialize(sql_function.GetData(cmd_auth, "sqlconnString")); if (array_auth[0, 0] == "1") { String strQuery = @"UPDATE [dbo].[Session] SET ID =@newID ,[UserName] = @UserName WHERE ID = @ID"; SqlCommand cmd = new SqlCommand(strQuery); cmd.Parameters.Add("@newID", SqlDbType.NVarChar).Value = newID; cmd.Parameters.Add("@UserName", SqlDbType.NVarChar).Value = "admin"; cmd.Parameters.Add("@ID", SqlDbType.NVarChar).Value = Model.ID; String insertRes = sql_function.InsertUpdateData(cmd, "sqlconnString"); if (insertRes == "1") { resModel.Result = true; } } return(Json(resModel)); }
public String[] SoHieu() { SQL_function sql_function = new SQL_function(); String strQuery = @"SELECT DISTINCT [SoHieu] FROM [DuLieuTotNghiep].[dbo].[DataTotNghiep]"; SqlCommand cmd = new SqlCommand(strQuery); String[,] array = sql_function.xml_deserialize(sql_function.GetData(cmd, "sqlconnString")); string[] res = new string[array.GetLength(0)]; for (int i = 0; i < array.GetLength(0); i++) { res[i] = array[i, 0]; } return(res); }
public String[] DanToc() { SQL_function sql_function = new SQL_function(); String strQuery = @"SELECT[DanTocID],[TenDanToc],[Moet_DanTocID] FROM[DuLieuTotNghiep].[dbo].[T_DM_DanToc]"; SqlCommand cmd = new SqlCommand(strQuery); String[,] array = sql_function.xml_deserialize(sql_function.GetData(cmd, "sqlconnString")); string[] res = new string[array.GetLength(0)]; for (int i = 0; i < array.GetLength(0); i++) { res[i] = array[i, 0]; } return(res); }