public List <PositionComboVm> GetCombo(PositionVm p, ref string msg)
{
List <PositionComboVm> items = new List <PositionComboVm>();
DataTable dt = db.GetList(MapProperties(p), ref msg);
if (msg != "")
{
return(new List <PositionComboVm>());
}
try
{
foreach (DataRow row in dt.Rows)
{
PositionComboVm item = new PositionComboVm();
item.Id = row["PositionId"].GetString();
item.Title = row["title"].GetString();
item.PositionType = row["positionType"].GetString();
item.Details = row["details"].GetString();
items.Add(item);
}
return(items);
}
catch (Exception ex)
{
msg = ef.GetExceptionMessage(ex, msg);
return(new List <PositionComboVm>());
}
}
public bool DeleteOne(PositionVm viewModel, ref string msg)
{
if (!EntryChecker.IsNotZeroOrNull(viewModel.Id.GetInt(), ref msg))
{
return(false);
}
return(db.DeleteOne(MapProperties(viewModel), ref msg));
}
public bool EditOne(PositionVm viewModel, ref string msg)
{
if (!EntryChecker.IsNotNullOrNotWhiteSpace(viewModel.Title, ref msg))
{
return(false);
}
return(db.EditOne(MapProperties(viewModel), ref msg));
}
public PositionVm GetOne(PositionVm p, ref string msg)
{
try
{
return(GetList(p, ref msg).Single());
}
catch (Exception ex)
{
msg = ef.GetExceptionMessage(ex, msg);
return(new PositionVm());
}
}
private Position MapProperties(PositionVm p)
{
Position baseObj = new Position();
baseObj.Id = p.Id.GetInt();
baseObj.Title = p.Title.GetString();
baseObj.PositionType = p.PositionType.GetString();
baseObj.Details = p.Details.GetString();
baseObj.CreatedById = p.CreatedById.GetInt();
baseObj.CreatedOn = p.CreatedOn.GetDateTime();
baseObj.ModifiedById = p.ModifiedById.GetInt();
baseObj.ModifiedOn = p.ModifiedOn.GetNullableDateTime();
return(baseObj);
}
public void ResetVmParams()
{
VmParams = new PositionVm();
}
public void ResetVmItem()
{
VmItem = new PositionVm();
}
