/// <summary> /// Takes the specified budgetSourceCategory. /// </summary> /// <param name="estimateDetailStatementPartB">The estimate detail statement part b.</param> /// <returns></returns> private static object[] Take(EstimateDetailStatementPartBEntity estimateDetailStatementPartB) { return(new object[] { "@EstimateDetailStatementPartBID", estimateDetailStatementPartB.EstimateDetailStatementPartBId, "@OrderNumber", estimateDetailStatementPartB.OrderNumber, "@Description", estimateDetailStatementPartB.Description, "@Note", estimateDetailStatementPartB.Note, "@Amount", estimateDetailStatementPartB.Amount, "@IsActive", estimateDetailStatementPartB.IsActive }); }
/// <summary> /// Updates the estimate detail statement. /// </summary> /// <param name="estimateDetailStatementPartB">The estimate detail statement part b.</param> /// <returns></returns> public string UpdateEstimateDetailStatementPartB(EstimateDetailStatementPartBEntity estimateDetailStatementPartB) { const string sql = @"uspUpdate_EstimateDetailStatementPartB"; return(Db.Update(sql, true, Take(estimateDetailStatementPartB))); }
/// <summary> /// Inserts the estimateDetailStatement. /// </summary> /// <param name="estimateDetailStatement">The estimateDetailStatement.</param> /// <returns></returns> public int InsertEstimateDetailStatementPartB(EstimateDetailStatementPartBEntity estimateDetailStatement) { const string sql = @"uspInsert_EstimateDetailStatementPartB"; return(Db.Insert(sql, true, Take(estimateDetailStatement))); }