public string SaveCenter(Center aCenter, int thanaId, string centerCode, string password)
{
int value = centerGateway.SaveCenter(aCenter, thanaId, centerCode, password);
if (value > 0)
{
return "Center has been Saved!";
}
else return "Failed";
}
public List<Center> GetAllDistrict()
{
List<Center> districtList=new List<Center>();
string query = "SELECT * FROM DistrictTBL";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Center center=new Center();
center.Id=int.Parse(reader["Id"].ToString());
center.DistrictName = reader["DistrictName"].ToString();
districtList.Add(center);
}
reader.Close();
connection.Close();
return districtList;
}
public List<Center> GetAllThana(int id)
{
List<Center> thanaList = new List<Center>();
string query = "SELECT * FROM ThanaTBL WHERE DistrictId='"+id+"'";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Center center = new Center();
center.Id = int.Parse(reader["Id"].ToString());
center.ThanaName = reader["ThanaName"].ToString();
thanaList.Add(center);
}
reader.Close();
connection.Close();
return thanaList;
}
protected void saveButton_Click(object sender, EventArgs e)
{
Center aCenter = new Center();
aCenter.CenterName = centerNameTextBox.Text;
if (centerManager.IsCenterNameExists(aCenter))
{
megLabel.Text = "Center name already exists!";
}
else
{
int thanaId = int.Parse(thanaCenterDropDownList.SelectedValue);
string newPassword = CreatePassword();
string password = EncryptSHA512Managed(newPassword);
int centerCount = centerManager.CenterCountInThana(thanaId) + 1;
string centerCode = CreateCenterCode(thanaCenterDropDownList.SelectedItem.ToString(), centerCount);
Session["centerName"] = aCenter.CenterName;
Session["centerCode"] = centerCode;
Session["password"] = newPassword;
megLabel.Text = centerManager.SaveCenter(aCenter, thanaId, centerCode, password);
Response.Redirect("CenterPasswordAndCodeUI.aspx");
}
}
public List<Center> CenterCountInThana(int id)
{
int count = 0;
List<Center> centerList=new List<Center>();
string query = "SELECT * FROM CenterTBL WHERE ThanaId='" + id + "'";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Center aCenter=new Center();
aCenter.Id =int.Parse( reader["Id"].ToString());
aCenter.CenterName = reader["CenterName"].ToString();
count++;
aCenter.Count = count;
centerList.Add(aCenter);
}
reader.Close();
connection.Close();
return centerList;
}
public bool IsCenterNameExists(Center aCenter)
{
return centerGateway.IsCenterNameExists(aCenter);
}
public int SaveCenter(Center aCenter, int thanaId, string centerCode, string password)
{
string query = "INSERT INTO CenterTBL VALUES('" + aCenter.CenterName + "','" + thanaId + "','" + centerCode + "','" + password + "')";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return rowAffected;
}
public bool IsCenterNameExists(Center aCenter)
{
bool exists = false;
string query = "SELECT * FROM CenterTBL WHERE CenterName='" + aCenter.CenterName + "'";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
exists = true;
}
reader.Close();
connection.Close();
return exists;
}
protected void showButton_Click(object sender, EventArgs e)
{
string dateFrom = Request.Form["dateFrom"];
string dateTo = Request.Form["dateTo"];
int yearFrom = int.Parse(dateFrom.Substring(0, 4));
int monthFrom = int.Parse(dateFrom.Substring(5, 2));
int dayFrom = int.Parse(dateFrom.Substring(8, 2));
int monthTo = int.Parse(dateTo.Substring(5, 2));
int dayTo = int.Parse(dateTo.Substring(8, 2));
int yearTo = int.Parse(dateTo.Substring(0, 4));
List<int> observaIdList = new List<int>();
if (yearTo < yearFrom)
{
megLabel.Text = "Incorrect date formet!";
}
else if (yearFrom == yearTo && monthTo < monthFrom)
{
megLabel.Text = "Incorrect date formet!";
}
else if (yearFrom == yearTo && monthTo == monthFrom && dayTo < dayFrom)
{
megLabel.Text = "Incorrect date formet!";
}
else
{
megLabel.Text = "";
for (int i = dayFrom; ; i++)
{
if (yearTo == yearFrom && monthTo == monthFrom && i == dayTo)
{
string date2 = yearFrom + "-" + monthFrom + "-" + i;
int patient2 = treatmentManager.GetObservationIdForDistrict(date2);
observaIdList.Add(patient2);
break;
}
string date = yearFrom + "-" + monthFrom + "-" + i;
int patient = treatmentManager.GetObservationIdForDistrict(date);
observaIdList.Add(patient);
if (i == 31 && monthFrom != 12)
{
monthFrom++;
i = 0;
}
else if (monthFrom == 12 && dayFrom == 31)
{
yearFrom++;
monthFrom = 1;
i = 0;
}
}
}
List<int> observationIdList = new List<int>();
int diseaseId = int.Parse(diseaseDropDownList.SelectedValue);
foreach (int id in observaIdList)
{
int ObId = treatmentManager.GetObsId(id, diseaseId);
observationIdList.Add(ObId);
}
List<int> centerIdList = new List<int>();
foreach (int id in observationIdList)
{
int centerId = treatmentManager.GetCenterIdForDistrict(id);
centerIdList.Add(centerId);
}
List<Center> districtNameList = new List<Center>();
List<Center> allDistrictNameList = centerManager.GetAllDistrict();
foreach (int id in centerIdList)
{
List<int> districtIdList = centerManager.GetDistrictIdList(id);
foreach (int disId in districtIdList)
{
Center aCenter = new Center();
aCenter.DistrictName = centerManager.GetDistrict(disId);
districtNameList.Add(aCenter);
}
}
List<Center> aCenterList = new List<Center>();
foreach (var districtName in allDistrictNameList)
{
int count = 0;
foreach (var nameOfDistrict in districtNameList)
{
if (districtName.DistrictName.Equals(nameOfDistrict.DistrictName))
{
count++;
}
}
Center aCenter = new Center();
aCenter.DistrictName = districtName.DistrictName;
decimal population = centerManager.GetDistrictPopulation(aCenter.DistrictName);
aCenter.Population = (count / population) * 100;
aCenter.Count = count;
aCenterList.Add(aCenter);
}
reportGridView.DataSource = aCenterList;
reportGridView.DataBind();
}
