public List<TransactionModel> GetAllTransaction() { List<TransactionModel> transactionlList =new List<TransactionModel>(); string url = @"server=faruk\SQLEXPRESS; database=ShopManagement; integrated security=true"; SqlConnection connection = new SqlConnection(url); connection.Open(); string query = "select * from t_transaction"; SqlCommand command = new SqlCommand(query, connection); SqlDataReader aReader = command.ExecuteReader(); int count = 1; if (aReader.HasRows) { while (aReader.Read()) { TransactionModel transaction = new TransactionModel(); transaction.Id = Convert.ToInt32((count++).ToString()); transaction.Name = aReader[1].ToString(); transaction.Date = Convert.ToDateTime(aReader[2].ToString()); transaction.Quantity= Convert.ToDouble((string)aReader[3]); transaction.TotalPrice = Convert.ToDouble(aReader[4].ToString()); transaction.PaidPrice = Convert.ToDouble(aReader[5].ToString()); transactionlList.Add(transaction); } } connection.Close(); return transactionlList; }
public string Save(TransactionModel atransaction) { if (atransaction.Name == string.Empty || atransaction.Date.ToString() == string.Empty ) { return "Please Fill all field"; } else { return gateway.Save(atransaction); } }
private void saveButton_Click(object sender, EventArgs e) { TransactionModel atransaction=new TransactionModel(); atransaction.Name = nameTextBox.Text; atransaction.Date = dateTimePicker.Value; atransaction.Quantity = Convert.ToDouble(quantityTextBox.Text); atransaction.TotalPrice = Convert.ToDouble(totalPrice.Text); atransaction.PaidPrice = Convert.ToDouble(paidPrice.Text); string msg = transactionBll.Save(atransaction); MessageBox.Show(msg); SeeAll(); }
public string Save(TransactionModel atransaction) { string url = @"server=faruk\SQLEXPRESS; database=ShopManagement; integrated security=true"; SqlConnection connection = new SqlConnection(url); connection.Open(); string query = string.Format("insert into t_transaction values ('{0}','{1}','{2}','{3}','{4}')", atransaction.Name, atransaction.Date, atransaction.Quantity,atransaction.TotalPrice,atransaction.PaidPrice); SqlCommand command = new SqlCommand(query, connection); int affectedrow = command.ExecuteNonQuery(); if (affectedrow > 0) return "Data inserted"; return "Some Error"; }