public static List <SetWardModel> DtToSetWardModelList(DataTable dt)
{
List <SetWardModel> results = new List <SetWardModel>();
foreach (DataRow row in dt.Rows)
{
SetWardModel ward = new SetWardModel();
ward.WardCode = row["WardCode"].ToString();
ward.WardDesc = row["WardDesc"].ToString();
results.Add(ward);
}
return(results);
}
private void btnSave_Click(object sender, EventArgs e)
{
List <SetWardModel> setWardList = new List <SetWardModel>();
foreach (var item in listboxWard.Items)
{
var setWard = new SetWardModel();
setWard.WardCode = (item as SetWardModel).WardCode;
setWard.WardDesc = (item as SetWardModel).WardDesc;
setWardList.Add(setWard);
}
if (SqlServerDA.ExecuteNonQuery(QueryString.TruncateTable("SetWard"), Constants.Svh21CHKConnectionString))
{
Helper.SetWardToDb(setWardList);
}
Helper.GetCurrentSetWard();
this.Close();
}
