public void ทดสอบแก้ไขข้อมูล()
{
DonatorController service = new DonatorController();
DonatorData item = new DonatorData();
item.DonatorRunno = 2;
item.DonatorId = "0002";
item.DonatorPreName = "นาย";
item.DonatorName = "แก้ไขข้อมูล";
item.DonatorSurName = "ทดสอบมา";
item.DonatorCitizenId = "4";
item.DonatorRegisterNo = "";
item.DonatorTaxId = "";
item.HouseNumber = "8";
item.Soi = "3321";
item.Road = "";
item.Moo = "9";
item.Building = "";
item.Tambon = "";
item.Amphur = "";
item.Province = "";
item.ZipCode = "99999";
item.Telephone = "";
var result = service.EditDonatorData(item);
Assert.IsNotNull(result);
}
public void ทดสอบเพิ่มข้อมูลผู้บริจาค()
{
DonatorController service = new DonatorController();
DonatorData item = new DonatorData();
item.DonatorId = "0003";
item.DonatorPreName = "นาย";
item.DonatorName = "ทดสอบลบ";
item.DonatorSurName = "ลบได้เลย";
item.DonatorCitizenId = "4564567890123";
item.DonatorRegisterNo = "";
item.DonatorTaxId = "";
item.HouseNumber = "98";
item.Soi = "ซอย";
item.Road = "";
item.Moo = "5";
item.Building = "";
item.Tambon = "";
item.Amphur = "";
item.Province = "";
item.ZipCode = "10400";
item.Telephone = "";
var result = service.AddDonatorData(item);
Assert.IsNotNull(result);
}
public IHttpActionResult ListAllDonator()
{
List <DonatorData> result = new List <DonatorData>();
DBConnector.DBConnector conn = new DBConnector.DBConnector();
string SQLString;
if (conn.OpenConnection())
{
try
{
SQLString = @"SELECT * FROM donatordata order by DonatorId";
MySqlCommand qExe = new MySqlCommand
{
Connection = conn.connection,
CommandText = SQLString
};
MySqlDataReader dataReader = qExe.ExecuteReader();
while (dataReader.Read())
{
DonatorData detail = new DonatorData();
detail.DonatorRunno = int.Parse(dataReader["DonatorRunno"].ToString());
detail.DonatorId = dataReader["DonatorId"].ToString();
detail.DonatorPreName = dataReader["DonatorPreName"].ToString();
detail.DonatorName = dataReader["DonatorName"].ToString();
detail.DonatorSurName = dataReader["DonatorSurName"].ToString();
detail.DonatorCitizenId = dataReader["DonatorCitizenId"].ToString();
detail.DonatorRegisterNo = dataReader["DonatorRegisterNo"].ToString();
detail.DonatorTaxId = dataReader["DonatorTaxId"].ToString();
detail.HouseNumber = dataReader["HouseNumber"].ToString();
detail.Soi = dataReader["Soi"].ToString();
detail.Road = dataReader["Road"].ToString();
detail.Moo = dataReader["Moo"].ToString();
detail.Building = dataReader["Building"].ToString();
detail.Tambon = dataReader["Tambon"].ToString();
detail.Amphur = dataReader["Amphur"].ToString();
detail.Province = dataReader["Province"].ToString();
detail.ZipCode = dataReader["ZipCode"].ToString();
detail.Telephone = dataReader["Telephone"].ToString();
detail.DonatorFullName = dataReader["donatorPrename"].ToString() + dataReader["donatorname"].ToString() +
" " + dataReader["donatorSurname"].ToString();
result.Add(detail);
}
dataReader.Close();
dataReader.Dispose();
return(Json(result));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
else
{
return(BadRequest("Database connect fail!"));
}
}
public void ทดสอบลบข้อมูลผู้บริจาค()
{
DonatorController service = new DonatorController();
DonatorData item = new DonatorData();
item.DonatorRunno = 2;
var result = service.DeleteDonatorData(item.DonatorRunno.ToString());
Assert.IsNotNull(result);
}
public IHttpActionResult EditDonatorData([FromBody] DonatorData item)
{
DBConnector.DBConnector conn = new DBConnector.DBConnector();
string SQLString;
if (conn.OpenConnection())
{
SQLString = @"UPDATE donatordata SET DonatorRunno = @DonatorRunno, DonatorId = @DonatorId, DonatorPreName = @DonatorPreName,
DonatorName = @DonatorName, DonatorSurName = @DonatorSurName, DonatorCitizenId = @DonatorCitizenId,
DonatorRegisterNo = @DonatorRegisterNo, DonatorTaxId = @DonatorTaxId, HouseNumber = @HouseNumber,
Soi = @Soi, Road = @Road, Moo = @Moo, Building = @Building, Tambon = @Tambon, Amphur = @Amphur,
Province = @Province, Zipcode = @Zipcode, Telephone = @Telephone WHERE DonatorRunno = @DonatorRunno ";
MySqlCommand qExe = new MySqlCommand
{
Connection = conn.connection,
CommandText = SQLString
};
qExe.Parameters.AddWithValue("@DonatorRunno", item.DonatorRunno);
qExe.Parameters.AddWithValue("@DonatorId", item.DonatorId);
qExe.Parameters.AddWithValue("@DonatorPreName", item.DonatorPreName);
qExe.Parameters.AddWithValue("@DonatorName", item.DonatorName);
qExe.Parameters.AddWithValue("@DonatorSurName", item.DonatorSurName);
qExe.Parameters.AddWithValue("@DonatorCitizenId", item.DonatorCitizenId);
qExe.Parameters.AddWithValue("@DonatorRegisterNo", item.DonatorRegisterNo);
qExe.Parameters.AddWithValue("@DonatorTaxId", item.DonatorTaxId);
qExe.Parameters.AddWithValue("@HouseNumber", item.HouseNumber);
qExe.Parameters.AddWithValue("@Soi", item.Soi);
qExe.Parameters.AddWithValue("@Road", item.Road);
qExe.Parameters.AddWithValue("@Moo", item.Moo);
qExe.Parameters.AddWithValue("@Building", item.Building);
qExe.Parameters.AddWithValue("@Tambon", item.Tambon);
qExe.Parameters.AddWithValue("@Amphur", item.Amphur);
qExe.Parameters.AddWithValue("@Province", item.Province);
qExe.Parameters.AddWithValue("@ZipCode", item.ZipCode);
qExe.Parameters.AddWithValue("@Telephone", item.Telephone);
qExe.ExecuteNonQuery();
conn.CloseConnection();
return(Json(new ResultDataModel {
success = true, errorMessage = "", returnRunno = ""
}));
}
else
{
return(Json(new ResultDataModel {
success = false, errorMessage = "Database connect fail!", returnRunno = ""
}));
}
}
public IHttpActionResult AddDonatorData([FromBody] DonatorData item)
{
DBConnector.DBConnector conn = new DBConnector.DBConnector();
string SQLString;
if (conn.OpenConnection())
{
SQLString = @"INSERT INTO donatordata (DonatorId, DonatorPreName, DonatorName, DonatorSurName,
DonatorCitizenId, DonatorRegisterNo, DonatorTaxId, HouseNumber, Soi, Road, Moo, Building, Tambon,
Amphur, Province, ZipCode, Telephone) VALUES (@DonatorId, @DonatorPreName,
@DonatorName, @DonatorSurName, @DonatorCitizenId, @DonatorRegisterNo, @DonatorTaxId, @HouseNumber,
@Soi, @Road, @Moo, @Building, @Tambon, @Amphur, @Province, @ZipCode, @Telephone)";
MySqlCommand qExe = new MySqlCommand
{
Connection = conn.connection,
CommandText = SQLString
};
qExe.Parameters.AddWithValue("@DonatorId", item.DonatorId);
qExe.Parameters.AddWithValue("@DonatorPreName", item.DonatorPreName);
qExe.Parameters.AddWithValue("@DonatorName", item.DonatorName);
qExe.Parameters.AddWithValue("@DonatorSurName", item.DonatorSurName);
qExe.Parameters.AddWithValue("@DonatorCitizenId", item.DonatorCitizenId);
qExe.Parameters.AddWithValue("@DonatorRegisterNo", item.DonatorRegisterNo);
qExe.Parameters.AddWithValue("@DonatorTaxId", item.DonatorTaxId);
qExe.Parameters.AddWithValue("@HouseNumber", item.HouseNumber);
qExe.Parameters.AddWithValue("@Soi", item.Soi);
qExe.Parameters.AddWithValue("@Road", item.Road);
qExe.Parameters.AddWithValue("@Moo", item.Moo);
qExe.Parameters.AddWithValue("@Building", item.Building);
qExe.Parameters.AddWithValue("@Tambon", item.Tambon);
qExe.Parameters.AddWithValue("@Amphur", item.Amphur);
qExe.Parameters.AddWithValue("@Province", item.Province);
qExe.Parameters.AddWithValue("@ZipCode", item.ZipCode);
qExe.Parameters.AddWithValue("@Telephone", item.Telephone);
qExe.ExecuteNonQuery();
long returnid = qExe.LastInsertedId;
conn.CloseConnection();
return(Json(new ResultDataModel {
success = true, errorMessage = "", returnRunno = returnid.ToString()
}));
}
else
{
return(Json(new ResultDataModel {
success = false, errorMessage = "Database connect fail!", returnRunno = ""
}));
}
}
