public Task <int> PostFamilyValues(FamilyValues familyValues)
        {
            int result = 0;

            using (IDbConnection db = GetConnection())
            {
                db.Open();

                if (familyValues.FamilyValuesName != "")
                {
                    var p = new DynamicParameters();

                    p.Add("@FamilyValuesId", familyValues.FamilyValuesId, DbType.Int32, ParameterDirection.Input);
                    p.Add("@FamilyValuesName", familyValues.FamilyValuesName, DbType.String, ParameterDirection.Input);
                    p.Add("@FamilyValuesCreatedDate", familyValues.FamilyValuesCreatedDate, DbType.DateTime, ParameterDirection.Input);
                    p.Add("@FamilyValuesCreatedBy", familyValues.FamilyValuesCreatedBy, DbType.Int32, ParameterDirection.Input);
                    p.Add("@FamilyValuesModifiedDate", familyValues.FamilyValuesModifiedDate, DbType.DateTime, ParameterDirection.Input);
                    p.Add("@FamilyValuesModifiedBy", familyValues.FamilyValuesModifiedBy, DbType.Int32, ParameterDirection.Input);
                    p.Add("@FamilyValuesStatus", familyValues.FamilyValuesStatus, DbType.Int32, ParameterDirection.Input);

                    if (familyValues.FamilyValuesId == 0)
                    {
                        p.Add("@ActionType", ActionType.Add.ToString(), DbType.String, ParameterDirection.Input);
                    }
                    else
                    {
                        p.Add("@ActionType", ActionType.Update.ToString(), DbType.String, ParameterDirection.Input);
                    }

                    result = db.Execute("usp_CRED_FamilyValues", p, commandType: CommandType.StoredProcedure);
                }

                return(Task.FromResult(result));
            }
        }
Beispiel #2
0
 public Task <int> FamilyValues(FamilyValues familyValues)
 {
     return(familyValuesRepositoryobj.PostFamilyValues(familyValues));
 }
 public Task <int> FamilyValues(FamilyValues familyValues)
 {
     return(familyValuesServiceobj.PostFamilyValues(familyValues));
 }