private LossCategory getDataObject(DataRow row)
{
LossCategory ls = new LossCategory();
ls.Id = Convert.ToInt32(row["CatID"]);
ls.ParentCatID = Convert.ToInt32(row["ParentCatID"]);
ls.Name = row["CatName"].ToString();
ls.SpanishName = row["SpanishCatName"].ToString();
ls.Rank = Convert.ToInt32(row["Rank"]);
ls.Description = row["Description"].ToString();
return(ls);
}
public bool Update(LossCategory ls)
{
string sql = string.Format(@"UPDATE LossCategory SET ");
sql += string.Format("ParentCatID='{0}', ", ls.ParentCatID);
sql += string.Format("CatName='{0}', ", ls.Name);
sql += string.Format("SpanishCatName='{0}', ", ls.SpanishName);
sql += string.Format("Rank='{0}', ", ls.Rank);
sql += string.Format("Description='{0}' ", ls.Description);
sql += string.Format("WHERE CatID='{0}'", ls.Id);
return(DB.Update(sql));
}
