public DataTable SearchDocument(DClient client) { DataTable DtResult = new DataTable("client"); SqlConnection SqlCon = new SqlConnection(); try { SqlCon.ConnectionString = Conection.cn; SqlCommand SqlCmd = new SqlCommand(); SqlCmd.Connection = SqlCon; SqlCmd.CommandText = "spsearch_client_document"; SqlCmd.CommandType = CommandType.StoredProcedure; SqlParameter ParSearch = new SqlParameter(); ParSearch.ParameterName = "@textsearch"; ParSearch.SqlDbType = SqlDbType.VarChar; ParSearch.Size = 50; ParSearch.Value = client.SearchText; SqlCmd.Parameters.Add(ParSearch); SqlDataAdapter SqlData = new SqlDataAdapter(SqlCmd); SqlData.Fill(DtResult); } catch (Exception ex) { DtResult = null; } return(DtResult); }
public string Delete(DClient client) { string resp = ""; SqlConnection SqlCon = new SqlConnection(); try { SqlCon.ConnectionString = Conection.cn; SqlCon.Open(); SqlCommand SqlCmd = new SqlCommand(); SqlCmd.Connection = SqlCon; SqlCmd.CommandText = "spdelete_client"; SqlCmd.CommandType = CommandType.StoredProcedure; //Initialize variables SqlParameter ParId = new SqlParameter(); ParId.ParameterName = "@id"; //same name as in the procedure ParId.SqlDbType = SqlDbType.Int; ParId.Value = client.Id; SqlCmd.Parameters.Add(ParId); //Execute the command resp = SqlCmd.ExecuteNonQuery() == 1 ? "OK" : "Not deleted"; } catch (Exception ex) { resp = "Something went wrong: " + ex.Message; } finally { if (SqlCon.State == ConnectionState.Open) { SqlCon.Close(); } } return(resp); }
public string Edit(DClient client) { string resp = ""; SqlConnection SqlCon = new SqlConnection(); try { SqlCon.ConnectionString = Conection.cn; SqlCon.Open(); SqlCommand SqlCmd = new SqlCommand(); SqlCmd.Connection = SqlCon; SqlCmd.CommandText = "spedit_client"; SqlCmd.CommandType = CommandType.StoredProcedure; //Initialize variables SqlParameter ParId = new SqlParameter(); ParId.ParameterName = "@id"; ParId.SqlDbType = SqlDbType.Int; ParId.Value = client.Id; SqlCmd.Parameters.Add(ParId); SqlParameter ParName = new SqlParameter(); ParName.ParameterName = "@name"; ParName.SqlDbType = SqlDbType.VarChar; ParName.Size = 50; ParName.Value = client.Name; SqlCmd.Parameters.Add(ParName); SqlParameter ParSurname = new SqlParameter(); ParSurname.ParameterName = "@surname"; ParSurname.SqlDbType = SqlDbType.VarChar; ParSurname.Size = 50; ParSurname.Value = client.Surname; SqlCmd.Parameters.Add(ParSurname); SqlParameter ParGender = new SqlParameter(); ParGender.ParameterName = "@gender"; ParGender.SqlDbType = SqlDbType.VarChar; ParGender.Size = 1; ParGender.Value = client.Gender; SqlCmd.Parameters.Add(ParGender); SqlParameter ParDob = new SqlParameter(); ParDob.ParameterName = "@date_birth"; ParDob.SqlDbType = SqlDbType.DateTime; ParDob.Value = client.Dob; SqlCmd.Parameters.Add(ParDob); SqlParameter ParDocumentType = new SqlParameter(); ParDocumentType.ParameterName = "@document_type"; ParDocumentType.SqlDbType = SqlDbType.VarChar; ParDocumentType.Size = 50; ParDocumentType.Value = client.TypeDocument; SqlCmd.Parameters.Add(ParDocumentType); SqlParameter ParDocumentNumber = new SqlParameter(); ParDocumentNumber.ParameterName = "@document_number"; ParDocumentNumber.SqlDbType = SqlDbType.VarChar; ParDocumentNumber.Size = 50; ParDocumentNumber.Value = client.DocumentNumber; SqlCmd.Parameters.Add(ParDocumentNumber); SqlParameter ParAddress = new SqlParameter(); ParAddress.ParameterName = "@address"; ParAddress.SqlDbType = SqlDbType.VarChar; ParAddress.Size = 150; ParAddress.Value = client.Address; SqlCmd.Parameters.Add(ParAddress); SqlParameter ParPhone = new SqlParameter(); ParPhone.ParameterName = "@phone"; ParPhone.SqlDbType = SqlDbType.VarChar; ParPhone.Size = 20; ParPhone.Value = client.Phone; SqlCmd.Parameters.Add(ParPhone); SqlParameter ParEmail = new SqlParameter(); ParEmail.ParameterName = "@email"; ParEmail.SqlDbType = SqlDbType.VarChar; ParEmail.Size = 50; ParEmail.Value = client.Email; SqlCmd.Parameters.Add(ParEmail); //Execute the command resp = SqlCmd.ExecuteNonQuery() == 1 ? "OK" : "Not Edited"; } catch (Exception ex) { resp = "Something went wrong: " + ex.Message; } finally { if (SqlCon.State == ConnectionState.Open) { SqlCon.Close(); } } return(resp); }
/// <summary> /// Data Order object /// </summary> /// <param name="product">product</param> /// <param name="amount">amount</param> /// <param name="client">client</param> public DOrder(Product product, int amount, DClient client) { Product = product; Amount = amount; Client = client; }