/// <summary>
/// Deletes the PlanTemplateList.
/// </summary>
/// <param name="planTemplateList">The PlanTemplateList.</param>
/// <returns>System.String.</returns>
public string DeletePlanTemplateList(PlanTemplateListEntity planTemplateList)
{
const string sql = @"uspDelete_PlanTemplateList";
object[] parms = { "@PlanTemplateListID", planTemplateList.PlanTemplateListId };
return(Db.Delete(sql, true, parms));
}
/// <summary>
/// Takes the specified PlanTemplateList.
/// </summary>
/// <param name="planTemplateList">The PlanTemplateList.</param>
/// <returns>System.Object[][].</returns>
private static object[] Take(PlanTemplateListEntity planTemplateList)
{
return(new object[]
{
"@PlanTemplateListID", planTemplateList.PlanTemplateListId,
"@PlanTemplateListCode", planTemplateList.PlanTemplateListCode,
"@PlanTemplateListName", planTemplateList.PlanTemplateListName,
"@PlanType", planTemplateList.PlanType,
"@PlanYear", planTemplateList.PlanYear,
"@ParentID", planTemplateList.ParentId
});
}
/// <summary>
/// Updates the PlanTemplateList.
/// </summary>
/// <param name="planTemplateList">The PlanTemplateList.</param>
/// <returns>System.String.</returns>
public string UpdatePlanTemplateList(PlanTemplateListEntity planTemplateList)
{
const string sql = "uspUpdate_PlanTemplateList";
return(Db.Update(sql, true, Take(planTemplateList)));
}
/// <summary>
/// Inserts the PlanTemplateList.
/// </summary>
/// <param name="planTemplateList">The PlanTemplateList.</param>
/// <returns>System.Int32.</returns>
public int InsertPlanTemplateList(PlanTemplateListEntity planTemplateList)
{
const string sql = "uspInsert_PlanTemplateList";
return(Db.Insert(sql, true, Take(planTemplateList)));
}
