public void PublicConfidentialTest() { WebForm1 client = new WebForm1(); string message = "This is confidential information and only available over TCP behind the company FireWall"; string result = client.GetConfidentialServiceClient(); Assert.AreEqual(message, result, "Pełna zgodność."); }
public void Prueba_nuevo_Cliente() { WebForm1 a = new WebForm1(); a.coneccion = new Coneccion(); a.coneccion.SetCadena("data source = HILBERTPC; initial catalog = Taller; integrated security = True;"); Assert.IsTrue(a.AgregarCliente("Juan", "Pedro", "Casas", "Casas", "2222222")); }
public void Test_ComputemothlyPayment() { var webform = new WebForm1(); double monthlyPayment = webform.ComputeMonthlyPayment(1000, 3, 2.5); monthlyPayment = Math.Round(monthlyPayment, 2); Assert.AreEqual(monthlyPayment, 28.86); }
public AnotherClass(WebForm1 wf) { Button btnConfirm = new Button(); btnConfirm.Text = "Confirm"; btnConfirm.CommandName = "Variable1,Variable2,Variable3"; wf.Form.Controls.Add(btnConfirm); btnConfirm.Click += new EventHandler(wf.btnConfirmBook_Click); }
public void Prueba_ObtenerCLientes() { WebForm1 a = new WebForm1(); a.coneccion = new Coneccion(); a.coneccion.SetCadena("data source = HILBERTPC; initial catalog = Taller; integrated security = True;"); Assert.IsNotNull(a.getClientes()); }
public void PublicServiceTest() { // Arrange WebForm1 client = new WebForm1(); string message = "This is public information and available over HTTP to all general public outside the FireWall"; // Act string result = client.GetPublicServiceClient(); // Assert Assert.AreEqual(message, result, "Pełna zgodność."); }
protected void Page_Load(object sender, EventArgs e) { Session.Clear(); Session["answers"] = new Dictionary <int, Answer>(); Session["answeredQuestion"] = false; Session["gaveImportanceFactor"] = false; Session["ActiveViewIndex"] = 0; Session["allMarkedButtons"] = new List <String>(); WebForm1 wf = new WebForm1(); wf.Page_Load(null, EventArgs.Empty); }
public bool error(string row_str, int row, string file_name) { WebForm1 Edit_Html = new WebForm1(); bool error_bool = false; string error_message = ""; int Col_count = row_str.Split(',').Length; string header = "No error \n"; string[] cells = row_str.Split(','); SqlConnection conn = WebForm1.conn; try { if (row == 0) { header = row_str; header_count = Col_count; } //Below is the list of errors the program is searching for //number of Columns and headers dont' match up in the local file if (header_count != Col_count && row != 0) { error_bool = true; error_message = "Either there is a header with no data, or a Column with no header. Please make sure each column has just one header, and double check the headers are correct.\n"; header_count = Col_count; } //If on Database side, if database does not allow null then check to verify local file has same number of rows. string ifnullStr = "select COLUMN_NAME , IS_NULLABLE, DATA_TYPE from INFORMATION_SCHEMA.COLUMNS where (TABLE_SCHEMA + '.' + TABLE_NAME) = '" + WebForm1.selected_table + "'"; SqlCommand ifnull = new SqlCommand(ifnullStr, conn); SqlDataReader reader_ = ifnull.ExecuteReader(); int Col_Num = 0; while (reader_.Read() && row == 0)//Get if it's null or not and put it into a list { isnull.Add(reader_["IS_NULLABLE"].ToString()); header_name.Add(reader_["COLUMN_NAME"].ToString()); datatype.Add(reader_["DATA_TYPE"].ToString()); Col_Num++; } reader_.Close(); if (row == 0 && Col_count == Col_Num)//Checks to see if the Column name on the local file (Header) is the same on the database { for (int i = 0; i < Col_Num; i++) { if (cells[i] != header_name[i])//If header on file is not the same as the Database header, give error { error_bool = true; error_message = "Error with Column \"" + cells[i] + "\". The name needs to be the same name as the column in the database. Make sure that there are no extra spaces at the end.\n"; } } } else if (row == 0) { error_bool = true; error_message = "Wrong Nuber of Columns in the file. The error's below are stating the indivudal rows.\n"; } error_message = error_message + " \n Row number : " + row; } catch (Exception ex) { error_message = ex.Message.ToString(); error_bool = true; } Logs log_error = new Logs(); if (error_bool == true) { log_error.failed_uploads(row_str, file_name, error_message); } Edit_Html.SendToForm(error_message, error_bool); error_message = ""; return(error_bool); }
public void upload(int new_row, int row, string row_str, string file_name) { string username = Environment.UserName; //Microsfot user account name var path = System.Web.HttpContext.Current.Server.MapPath("/temp/"); //Path for temp file string temp_file = (path + file_name + username + ".csv"); File.AppendAllText(temp_file, "");//inits file Error_detect error = new Error_detect(); SqlConnection conn = WebForm1.conn; string table_name = WebForm1.selected_table; bool error_result = error.error(row_str, row, file_name); SqlDataAdapter updateSQLcmd = new SqlDataAdapter(); DataSet ds = new DataSet(); string sql_row = ""; bool resume_old_file = File.ReadAllText(temp_file).Contains(row_str)? true : false; string temp_row = ""; Logs log = new Logs(); if (resume_old_file == false) { if (error_result == false && new_row != 0) { try { sql_row = row_str.Insert(0, "'") + "'"; sql_row = sql_row.Replace(",", "','"); string insert_sql = "INSERT INTO " + table_name + " VALUES(" + sql_row + ")"; SqlCommand insert_sql_cmd = new SqlCommand(insert_sql, conn); updateSQLcmd.SelectCommand = insert_sql_cmd; updateSQLcmd.Fill(ds); log.successful_upload(row_str, file_name); ////Sends row to temp file File.AppendAllText(path + file_name + username + ".csv", row_str + "\n"); } catch (SqlException ex) { //This is dealing with Errors on Database/SQL side. WebForm1 issue = new WebForm1(); Logs log_advaced_errors = new Logs(); string message; if (ex.Number == 2627) { message = "You have a duplicate unique ID. Please make sure all rows have a unique ID. More info is below. \n" + ex.Message + "\n Row number : " + row + "\n Error number : " + ex.Number; } else if (ex.Number == 245) { message = "You are trying to put a word into a number column, or a number into a word column. Please make sure numbers go in number columns and word's go into word columns. More info is below : \n" + ex.Message + "\nRow number : " + row; } else if (ex.Number == 241) { message = "You can only put a date in a date column. See more details below. \n" + ex.Message + "\n Row number : " + row + "\n Error number : " + ex.Number + "\n" + row_str; } else { message = "There was an error in processing the data. More details are below. Please contact your administrator for questions.\n" + ex.Message + "\n Row number : " + row + "\n Error number : " + ex.Number; } issue.SendToForm(message, true); log_advaced_errors.failed_uploads(row_str, file_name, message); } } else { //If no Error's then Upload data } } }