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;
}
