private static void BuildIncPayParameter(IncomePaymen incPay, string statement) { if (statement == "update") { cmd.Parameters.Add(new SqlParameter("@id", incPay.Id)); } cmd.Parameters.Add(new SqlParameter("@name", incPay.Name)); cmd.Parameters.Add(new SqlParameter("@description", incPay.Description)); cmd.Parameters.Add(new SqlParameter("@statusid", incPay.StatusID)); }
private static IncomePaymen BindIncomePaymenProperties(IncomePaymen obj, ref SqlDataReader reader) { while (reader.Read()) { obj.Name = reader.GetString(0); obj.Description = reader.GetString(1); obj.Id = (int)reader.GetSqlInt32(2); if (!reader.GetSqlInt32(3).IsNull) { obj.StatusID = (int)reader.GetInt32(3); } } return(obj); }