public Customer GetByName(string name) { Customer _Customer = null; using (SqlConnection _Connection = RepositoryDBUtils.GetSqlConnection()) { SqlCommand _Command = new SqlCommand { Connection = _Connection, CommandType = CommandType.StoredProcedure, CommandText = "CRM_GetCustomerByName" }; SqlParameter parameter = new SqlParameter("@Name", SqlDbType.NVarChar) { Value = name }; _Command.Parameters.Add(parameter); _Connection.Open(); SqlDataReader _Reader = _Command.ExecuteReader(CommandBehavior.CloseConnection); while (_Reader.Read()) { _Customer = new Customer { ID = int.Parse(_Reader["CustomerID"].ToString()), Name = _Reader["Name"].ToString(), Address = _Reader["Address"].ToString() }; } } return(_Customer); }
public void Add(PartInvoice invoice) { using (SqlConnection _Connection = RepositoryDBUtils.GetSqlConnection()) { SqlCommand _Command = new SqlCommand { Connection = _Connection, CommandType = CommandType.StoredProcedure, CommandText = "PMS_AddPartInvoice" }; SqlParameter _StockCodeParameter = new SqlParameter("@StockCode", SqlDbType.VarChar, 50) { Value = invoice.StockCode }; _Command.Parameters.Add(_StockCodeParameter); SqlParameter QuantityParameter = new SqlParameter("@Quantity", SqlDbType.Int) { Value = invoice.Quantity }; _Command.Parameters.Add(QuantityParameter); SqlParameter CustomerIDParameter = new SqlParameter("@CustomerID", SqlDbType.Int) { Value = invoice.CustomerID }; _Command.Parameters.Add(CustomerIDParameter); _Connection.Open(); _Command.ExecuteNonQuery(); } }