public List<EmployeeModel> GetAllEmployee() { List<EmployeeModel> empoList=new List<EmployeeModel>(); string url = @"server=faruk\SQLEXPRESS; database=ShopManagement; integrated security=true"; SqlConnection connection = new SqlConnection(url); connection.Open(); string query = "select * from t_employee"; SqlCommand command = new SqlCommand(query, connection); SqlDataReader aReader = command.ExecuteReader(); int count = 1; if (aReader.HasRows) { while (aReader.Read()) { EmployeeModel employee = new EmployeeModel(); employee.Id = (count++).ToString(); employee.Name = aReader[1].ToString(); employee.Phone = aReader[2].ToString(); employee.Address = aReader[3].ToString(); empoList.Add(employee); } } connection.Close(); return empoList; }
private void saveButton_Click(object sender, EventArgs e) { EmployeeModel anModel=new EmployeeModel(); anModel.Name = nameTextBox.Text; anModel.Phone = mobileTextBox.Text; anModel.Address = addressTextBox.Text; string msg = anEmployeeBll.Save(anModel); MessageBox.Show(msg); SeeAll(); }
public string Save(EmployeeModel anModel) { if (anModel.Name == string.Empty || anModel.Phone == string.Empty || anModel.Address == string.Empty) { return "please fill all the field"; } else { return gateWay.Save(anModel); } }
public string Save(EmployeeModel anModel) { string url = @"server=faruk\SQLEXPRESS; database=ShopManagement; integrated security=true"; SqlConnection connection = new SqlConnection(url); connection.Open(); string query = string.Format("insert into t_employee values ('{0}','{1}','{2}')", anModel.Name, anModel.Phone, anModel.Address); SqlCommand command = new SqlCommand(query, connection); int affectedrow = command.ExecuteNonQuery(); if (affectedrow > 0) return "Data inserted"; return "Some Error"; }