public List<Center> GetCenterAccordingToThana(int id) { List<Center> centerList = new List<Center>(); SqlConnection connection = new SqlConnection(connectionstring); string query = "SELECT center_Id,center_Name FROM Table_Center WHERE center_ThanaId='" + id + "'"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Center center = new Center(); center.Id = int.Parse(reader["center_Id"].ToString()); center.Name = reader["center_Name"].ToString(); centerList.Add(center); } reader.Close(); connection.Close(); return centerList; }
public string Insert(Center center) { if (center.Name == "") { return "center name is missing"; } else { int value = centerGateway.Insert(center); if (value > 0) { return "Saved Successfully"; } else { return "Operation Failed"; } } }
public string Insert(Center center) { if (center.Name == "") { return "center name is missing"; } else if (centerGateway.HasThisCenterNameExists(center.Name, center.ThanaId)) { return "This center is already exists under this thana ,please try again"; } else { int value = centerGateway.Insert(center); if (value > 0) { return "Saved Successfully"; } else { return "Operation Failed"; } } }
public int Insert(Center center) { SqlConnection connection = new SqlConnection(connectionstring); string query = "INSERT INTO Table_Center VALUES('" + center.Name + "','" + center.Code + "','" + center.Password + "','" + center.DistrictId + "','" + center.ThanaId + "')"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); int rowsAffected = command.ExecuteNonQuery(); connection.Close(); return rowsAffected; }