public List <SubDistrictInfo> GetAllSubDistrict(int aDistrictId)
{
List <SubDistrictInfo> subDistrictInfos = null;
string query = "SELECT * FROM SubDistrictInfo WHERE DistrictInfoId='" + aDistrictId + "'";
Connection.Open();
Command = new SqlCommand(query, Connection);
Reader = Command.ExecuteReader();
if (Reader.HasRows)
{
subDistrictInfos = new List <SubDistrictInfo>();
while (Reader.Read())
{
SubDistrictInfo aSubDistrictInfo = new SubDistrictInfo()
{
Id = (int)Reader ["Id"],
SubDistrictName = Reader ["SubDistrictName"].ToString(),
DistrictInfoId = (int)Reader ["DistrictInfoId"]
};
subDistrictInfos.Add(aSubDistrictInfo);
}
Reader.Close();
}
Connection.Close();
return(subDistrictInfos);
}
public int SaveSubDistrictInfo(SubDistrictInfo aSubDistrictInfo)
{
int rowAffected = 0;
string query = "INSERT INTO SubDistrictInfo VALUES('" + aSubDistrictInfo.SubDistrictName + "','" + aSubDistrictInfo.DistrictInfoId + "',GETDATE() )";
Connection.Open();
Command = new SqlCommand(query, Connection);
rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public string SaveSubDistrictInfo(SubDistrictInfo aSubDistrictInfo)
{
/* bool isDuplicateExist = _subDistrictInfoGateway.IsDuplicateDataExist(aSubDistrictInfo);*/
/* if (!isDuplicateExist)*/
{
int rowAffected = _subDistrictInfoGateway.SaveSubDistrictInfo(aSubDistrictInfo);
if (rowAffected > 0)
{
return("success");
}
else
{
return("failed");
}
}
/* else
* {
* return "exist";
* }*/
}
public List <SubDistrictInfo> GetAllSubDistrict()
{
List <SubDistrictInfo> aDistrictInfos = null;
string query = "SELECT * FROM SubDistrictInfo ORDER BY Id DESC";
Connection.Open();
Command = new SqlCommand(query, Connection);
Reader = Command.ExecuteReader();
if (Reader.HasRows)
{
aDistrictInfos = new List <SubDistrictInfo>();
while (Reader.Read())
{
SubDistrictInfo aDistrictInfo = new SubDistrictInfo();
aDistrictInfo.Id = (int)Reader["Id"];
aDistrictInfo.SubDistrictName = Reader["SubDistrictName"].ToString();
aDistrictInfos.Add(aDistrictInfo);
}
Reader.Close();
}
Connection.Close();
return(aDistrictInfos);
}
