コード例 #1
0
        public IDictionary <object, object> Updatecustomer@Dynamicdetails(personalDetails lt, string spName)
        {
            var dapperParam = new DynamicParameters();

            dapperParam.Add("@CustID", lt.intCusID);
            dapperParam.Add("@EmpID", lt.EmpID);
            dapperParam.Add("@IsReViewed", lt.Admin);
            dapperParam.Add("@dt@Dynamicdetails", lt.dtTableValues, dbType: DbType.Object);
            dapperParam.Add("@Status", dbType: DbType.Int32, direction: ParameterDirection.Output, size: 5000);

            int?status = 0;

            using (IDbConnection conn = SQLHelper.GetSQLConnection())
            {
                var reader = conn.QueryMultiple(spName, param: dapperParam, commandType: CommandType.StoredProcedure);
                status = dapperParam.Get <int?>("@Status");
            }

            IDictionary <object, object> workingObjects = new Dictionary <object, object>();

            workingObjects.Add("response", status);
            return(workingObjects);
        }
コード例 #2
0
ファイル: DynamicDal.cs プロジェクト: vinuuu/DynamicAPI
 public IDictionary <object, object> Updatecustomer@Dynamicdetails(personalDetails lt, @DynamicSvc svc)
 {
     return(svc.Updatecustomer@Dynamicdetails(lt, spNames.@DynamicDetailsUpdateSP));
 }