/// <summary>
/// Deletes the mergerFund.
/// </summary>
/// <param name="mergerFund">The mergerFund.</param>
/// <returns></returns>
public string DeleteMergerFund(MergerFundEntity mergerFund)
{
const string sql = @"uspDelete_MergerFund";
object[] parms = { "@MergerFundID", mergerFund.MergerFundId };
return(Db.Delete(sql, true, parms));
}
/// <summary>
/// Takes the specified mergerFund.
/// </summary>
/// <param name="mergerFund">The mergerFund.</param>
/// <returns></returns>
private object[] Take(MergerFundEntity mergerFund)
{
return(new object[]
{
"@MergerFundID", mergerFund.MergerFundId,
"@MergerFundCode", mergerFund.MergerFundCode,
"@MergerFundName", mergerFund.MergerFundName,
"@ParentID", mergerFund.ParentId,
"@Description", mergerFund.Description,
"@IsSystem", mergerFund.IsSystem,
"@IsActive", mergerFund.IsActive,
"@Grade", mergerFund.Grade,
"@ForeignName", mergerFund.ForeignName
});
}
/// <summary>
/// Updates the mergerFund.
/// </summary>
/// <param name="mergerFund">The mergerFund.</param>
/// <returns></returns>
public string UpdateMergerFund(MergerFundEntity mergerFund)
{
const string sql = "uspUpdate_MergerFund";
return(Db.Update(sql, true, Take(mergerFund)));
}
/// <summary>
/// Inserts the mergerFund.
/// </summary>
/// <param name="mergerFund">The mergerFund.</param>
/// <returns></returns>
public int InsertMergerFund(MergerFundEntity mergerFund)
{
const string sql = "uspInsert_MergerFund";
return(Db.Insert(sql, true, Take(mergerFund)));
}