/// <summary>
/// F35050_s the calculate amount.
/// </summary>
/// <param name="scheduleItemId">The schedule item id.</param>
/// <param name="rollYear">The roll year.</param>
/// <param name="year">The year.</param>
/// <param name="deprDescription">The depr description.</param>
/// <returns>schedulelineitem dataset</returns>
public static F35050ScheduleLineItemDataSet F35050_CalculateAmount(int scheduleItemId, int rollYear, int year, int deprDescription)
{
F35050ScheduleLineItemDataSet scheduleLineItemdata = new F35050ScheduleLineItemDataSet();
Hashtable ht = new Hashtable();
ht.Add("@ScheduleItemID", scheduleItemId);
ht.Add("@Rollyear", rollYear);
if (year >= 0)
{
ht.Add("@Year", year);
}
else
{
ht.Add("@Year", null);
}
if (deprDescription >= 0)
{
ht.Add("@DeprTableID", deprDescription);
}
else
{
ht.Add("@DeprTableID", null);
}
Utility.LoadDataSet(scheduleLineItemdata.AccountDetails, "f35050_pcget_Amount", ht);
return(scheduleLineItemdata);
}
/// <summary>
/// F35050_GetScheduleCategory
/// </summary>
/// <returns>Dataset</returns>
public static F35050ScheduleLineItemDataSet F35050_GetScheduleCategory()
{
F35050ScheduleLineItemDataSet scheduleLineItemdata = new F35050ScheduleLineItemDataSet();
Hashtable ht = new Hashtable();
Utility.LoadDataSet(scheduleLineItemdata.SchedlueCategoryTable, "f35050_pclst_SchedlueCategory", ht);
return(scheduleLineItemdata);
}
/// <summary>
/// F35050_GetScheduleLineItemDetails
/// </summary>
/// <param name="scheduleId">scheduleId</param>
/// <returns>DataSet</returns>
public static F35050ScheduleLineItemDataSet F35050_GetScheduleLineItemDetails(int scheduleId)
{
F35050ScheduleLineItemDataSet scheduleLineItemdata = new F35050ScheduleLineItemDataSet();
Hashtable ht = new Hashtable();
ht.Add("@ScheduleID", scheduleId);
string[] tableName = new string[] { scheduleLineItemdata.SchedlueLineItemTable.TableName, scheduleLineItemdata.SchedlueItemTable.TableName, scheduleLineItemdata.SchedlueCategoryTable.TableName, scheduleLineItemdata.RollYearTable.TableName };
Utility.LoadDataSet(scheduleLineItemdata, "f35050_pclst_SchedlueLineItem", ht, tableName);
return(scheduleLineItemdata);
}
/// <summary>
/// F35050_s the get depr percentage.
/// </summary>
/// <param name="rollyear">The rollyear.</param>
/// <param name="deprtableID">The deprtable ID.</param>
/// <param name="year">The year.</param>
/// <returns>schedulelineitem dataset.</returns>
public static F35050ScheduleLineItemDataSet F35050_GetDeprPercentage(int rollyear, int deprtableID, int year)
{
F35050ScheduleLineItemDataSet scheduleLineItemdata = new F35050ScheduleLineItemDataSet();
Hashtable ht = new Hashtable();
ht.Add("@Rollyear", rollyear);
ht.Add("@DeprTableID", deprtableID);
ht.Add("@Year", year);
Utility.LoadDataSet(scheduleLineItemdata.ListDeprTable, "f36050_pcget_PPDepreciationPercent", ht);
return(scheduleLineItemdata);
}
/// <summary>
/// GetDepreciationValue
/// </summary>
/// <param name="scheduleId">scheduleId</param>
/// <param name="recv">recv</param>
/// <param name="rollYear">rollYear</param>
/// <returns>DataSet</returns>
public static F35050ScheduleLineItemDataSet F35050_GetDepreciationValue(int scheduleId, int recv, int rollYear)
{
F35050ScheduleLineItemDataSet scheduleLineItemdata = new F35050ScheduleLineItemDataSet();
Hashtable ht = new Hashtable();
ht.Add("@ScheduleID", scheduleId);
ht.Add("@Recovery", recv);
ht.Add("@RollYear", rollYear);
Utility.LoadDataSet(scheduleLineItemdata, "f35050_pcget_RollYear", ht);
return(scheduleLineItemdata);
}
/// <summary>
/// F35050_s the get list out table details.
/// </summary>
/// <param name="scheduleId">The schedule ID.</param>
/// <returns>schedulelineitem dataset</returns>
public static F35050ScheduleLineItemDataSet F35050_GetListOutTableDetails(int scheduleId)
{
F35050ScheduleLineItemDataSet scheduleLineItemdata = new F35050ScheduleLineItemDataSet();
Hashtable ht = new Hashtable();
if (scheduleId == 0)
{
ht.Add("@ScheduleID", DBNull.Value);
}
else
{
ht.Add("@ScheduleID", scheduleId);
}
Utility.LoadDataSet(scheduleLineItemdata.pclstDeprTable, "f35050_pclst_DeprTable", ht);
return(scheduleLineItemdata);
}
/// <summary>
/// F35050_s the get list table details.
/// </summary>
/// <param name="itemcategoryID">The itemcategory ID.</param>
/// <returns>scheduleline item dataset.</returns>
public static F35050ScheduleLineItemDataSet F35050_GetListTableDetails(int itemcategoryID)
{
F35050ScheduleLineItemDataSet scheduleLineItemdata = new F35050ScheduleLineItemDataSet();
Hashtable ht = new Hashtable();
if (itemcategoryID == 0)
{
ht.Add("@ItemCategoryID", DBNull.Value);
}
else
{
ht.Add("@ItemCategoryID", itemcategoryID);
}
Utility.LoadDataSet(scheduleLineItemdata.ListTableDetails, "f35050_pclst_DeprName", ht);
return(scheduleLineItemdata);
}
