Ejemplo n.º 1
0
        public int Update(string organizationId, Name name, TypeModify typeModify)
        {
            int result = 0;

            string updateSql = @"update system_Flag_Data_Modified set flag_modified=@flagModified,
                               DateModified=@dateModified,TypeModify=@typeModified
                               where OrganizationID=@organizationId and Name=@name";
            List<SqlParameter> parameters = new List<SqlParameter>();
            parameters.Add(new SqlParameter("@organizationId", organizationId));
            parameters.Add(new SqlParameter("@name", GetNameByEnum(name)));
            parameters.Add(new SqlParameter("@typeModified", typeModify));
            parameters.Add(new SqlParameter("@dateModified", DateTime.Now));
            parameters.Add(new SqlParameter("@flagModified", 1));

            _dataFactory.ExecuteSQL(updateSql, parameters.ToArray());

            return result;
        }
Ejemplo n.º 2
0
        public int Update(string organizationId, Name name, TypeModify typeModify)
        {
            int result = 0;

            string updateSql = @"update system_Flag_Data_Modified set flag_modified=@flagModified,
                               DateModified=@dateModified,TypeModify=@typeModified
                               where OrganizationID=@organizationId and Name=@name";
            List <SqlParameter> parameters = new List <SqlParameter>();

            parameters.Add(new SqlParameter("@organizationId", organizationId));
            parameters.Add(new SqlParameter("@name", GetNameByEnum(name)));
            parameters.Add(new SqlParameter("@typeModified", typeModify));
            parameters.Add(new SqlParameter("@dateModified", DateTime.Now));
            parameters.Add(new SqlParameter("@flagModified", 1));

            _dataFactory.ExecuteSQL(updateSql, parameters.ToArray());

            return(result);
        }