public void DeleteModel(PbknitfinishModel model)
{
PbknitfinishTable table = new PbknitfinishTable();
DataAccess.DefaultDB.Delete(table)
.Execute();
}
public void CheckModel(PbknitfinishModel model, bool isNew)
{
Validator v = new Validator();
//Check model's data here.
if (!v.IsValid)
{
throw new ValidationException(v);
}
}
protected bool Exists(PbknitfinishModel model, bool isNew)
{
PbknitfinishTable table = new PbknitfinishTable();
SelectSqlSection sql = DataAccess.DefaultDB.Select(table, QueryColumn.All().Count())
.Where(table.FinishingCode == model.FinishingCode &&
table.FinishingName == model.FinishingName &&
table.Description == model.Description &&
table.WashingFlag == model.WashingFlag &&
table.IsActive == model.IsActive
);
return(sql.ToScalar <int>() > 0);
}
public void UpdateModel(PbknitfinishModel model)
{
//model.UpdateTime = System.DateTime.Now;
PbknitfinishTable table = new PbknitfinishTable();
DataAccess.DefaultDB.Update(table)
.AddColumn(table.FinishingCode, model.FinishingCode)
.AddColumn(table.FinishingName, model.FinishingName)
.AddColumn(table.Description, model.Description)
.AddColumn(table.WashingFlag, model.WashingFlag)
.AddColumn(table.IsActive, model.IsActive)
.Execute();
}
public PbknitfinishModelList GetModelList(PbknitfinishModel model)
{
PbknitfinishTable table = new PbknitfinishTable();
SelectSqlSection sql = DataAccess.DefaultDB.Select(table, table.AllColumns())
;
using (SafeDataReader sdr = new SafeDataReader(sql.ToDataReader()))
{
PbknitfinishModelList result = new PbknitfinishModelList();
while (sdr.Read())
{
PbknitfinishModel m = new PbknitfinishModel();
m.FinishingCode = sdr.GetString(table.FinishingCode);
m.FinishingName = sdr.GetString(table.FinishingName);
m.Description = sdr.GetString(table.Description);
m.WashingFlag = sdr.GetString(table.WashingFlag);
m.IsActive = sdr.GetString(table.IsActive);
result.Add(m);
}
return(result);
}
}